Momwe mungaphatikizire mizati iwiri mu Excel popanda kutaya deta

M'nkhani yaifupi iyi, muphunzira njira yothandiza yophatikiza mizati yambiri mu Excel kuti zonse zofunika zisungidwe.

Tiyerekeze kuti muli ndi spreadsheet yomwe ili ndi mizati iwiri pamwamba pa ina. Mwachitsanzo, muyenera kuphatikiza zipilala ndi dzina loyamba ndi lomaliza kukhala limodzi kapena kuphatikiza mizati ingapo ndi mawu oti "msewu", "mzinda", "zip code" kukhala imodzi - "adilesi yakunyumba", kuti mulekanitse ma values ​​okhala ndi koma. Kodi zimenezi zingatheke bwanji?

Tsoka ilo, Excel ilibe ntchito yomangidwira yomwe imakulolani kuchita zomwe tanena pamwambapa. Zachidziwikire, pali batani la "Merge Cells" ndi ena onga iwo, koma zikhalidwe zauXNUMXbuXNUMXbare zidatayika.

Chenjezo lotsatirali lidzawonetsedwa:

1. Excel 2013 idzanena kuti mtengo wokhawo womwe uli pamwamba kumanzere wamtunduwo udzasungidwa mu selo lophatikizidwa. Zina zonse zichotsedwa. 
2. Excel 2010 ndi pansipa ziwonetsa chenjezo lomwe lili ndi tanthauzo lofanana koma mawu osiyana pang'ono.

Izi zimayika zoletsa zazikulu pakugwiritsa ntchito pulogalamuyi ndipo zimapangitsa kuti zikhale zosatheka kuchita bwino ntchitozo.

Kenaka, muphunzira njira zitatu zophatikizira deta kuchokera kumagulu angapo kukhala imodzi kuti musataye deta (popanda kugwiritsa ntchito macros). Ngati mukufuna njira yosavuta, mutha kudumpha njira ziwiri zoyambirira ndikuphunzira yachitatu yokha.

Kuphatikiza ma columns angapo pogwiritsa ntchito fomula

Tiyerekeze kuti muli ndi tebulo lokhala ndi zambiri za makasitomala, ndipo abwana akhazikitsa ntchito yophatikiza mizati «Dzina loyamba» и «Dzina lomaliza» m'modzi "Dzina lonse". Kuti muchite izi, muyenera kuchita zotsatirazi:

1. Ikani ndime yowonjezera mu tebulo. Kuti muchite izi, ikani cholozera pamutu wamutu (kwa ife, ndi gawo D) ndikudina pomwepa. Menyu yankhani idzawoneka momwe muyenera kusankha chinthucho "Ikani". Tiyeni tiyimbe mzere wotsatira "Dzina lonse", lomwe limamasulira kuti "Dzina lonse".
2. Kenako, mu cell D2, muyenera kulemba fomula ili: =KULUMIKIZANA(B2;” “;C2) . Kwa ife, B2 ndi adilesi ya selo yokhala ndi dzina loyamba, ndipo C2 ndi adilesi ya selo yokhala ndi dzina lomaliza. Mutha kuwonanso chizindikiro cha danga pakati pa mawu apo. Panthawiyi, cholekanitsa chimalembedwa, choyikidwa pakati pa zomwe zili m'maselo oyambirira ndi achiwiri. Ngati mukufuna kulekanitsa zinthuzo ndi koma (mwachitsanzo, kuti mutchule adilesi yonse), mutha kuyilemba ngati mkangano wachiwiri pantchitoyo. Mutha kuphatikiza mizati ingapo kukhala imodzi pogwiritsa ntchito cholekanitsa china chilichonse.
3. Fomulayi imakopera ku maselo ena onse omwe ali mugawoli. Kuti mumvetsetse momwe mungachitire izi, mutha kugwiritsa ntchito malangizo akuti "Momwe mungayikitsire fomula yofanana m'maselo onse osankhidwa" (onani nkhani patsamba lathu).
4. Chifukwa chake mizati iwiriyo yaphatikizidwa kukhala imodzi, koma ikadali chilinganizo. Chifukwa chake, ngati muchotsa gawo loyamba kapena lomaliza, zomwe zili patsamba lonselo zidzatayikanso.
5. Tsopano tifunika kusintha ndondomeko mu selo kukhala mtengo wokonzeka kuti tithe kuchotsa zipilala zowonjezera pa chikalatacho. Kuti muchite izi, sankhani ma cell onse omwe ali ndi chidziwitso cha gawo lophatikizika (sankhani selo loyamba pagawo la D mwa ife ndikusindikiza makiyiwo. Ctrl + Shift + Down Arrow; ndiye muyenera kukopera deta kuchokera mzati ndikudina kumanja pa selo iliyonse yomwe ili mugawoli ndikudina "Paste Special". Sankhani chinthu kumanzere kwa zenera "Values" ndipo dinani batani "CHABWINO".
6. Tsopano mutha kufufuta mizati yoyambirira. Kuti muchite izi, muyenera kudina dzina la ndime B, ndiyeno yesani Ctrl kiyi ndikuchita chimodzimodzi ndi ndime C. Izi ndizofunikira kusankha mizati yonseyi. Mukhozanso kugwiritsa ntchito makiyi ophatikizira Ctrl + Space kuti musankhe ndime yonse, ndiyeno yesani Ctrl + Shift + Mtsinje Wakumanja, koperani zosankhidwazo ku gawo loyandikana nalo C. Kenako, menyu yankhaniyo imatsegula ndikudina kumanja pa imodzi mwazosankhidwa. mizati, ndiyeno muyenera dinani chinthucho "Chotsani".

Tsopano mayina ochokera m'zaza zingapo aphatikizidwa kukhala amodzi. Ngakhale kuti zimatenga nthawi, ndondomeko yeniyeni ya zochitikazo imawonekera ngakhale kwa oyamba kumene.

Kulumikiza mizati pogwiritsa ntchito Notepad

Njirayi itenga nthawi yocheperapo kuti ikwaniritsidwe poyerekeza ndi njira yapitayi, ndipo palibe mafomu omwe akuyenera kugwiritsidwa ntchito. Koma ndizoyenera kulumikiza mizati yomwe ili moyandikana, komanso ngati cholekanitsa chimodzi chikugwiritsidwa ntchito (mwachitsanzo, comma yokha).

Tinene kuti tifunika kujowina mizati yofanana ndi yachitsanzo chapitachi. Kuti muchite izi, tsatirani malangizo awa:

1. Sankhani zigawo zonse kuti zilumikizidwe. Kuti mukwaniritse ntchitoyi, sankhani cell B1 ndikusindikiza batani Shift + Right Arrow. Kenako kusankha kudzakhudzanso cell yoyandikana nayo C1. Pambuyo pake, muyenera kukanikiza kuphatikiza Ctrl + Shift + Down Arrow kuti musunthe kusankha kumapeto kwenikweni kwa mizati.
2. Tumizani zambiri pa bolodi (mwanjira ina, zikoperani). Kuti muchite izi, kanikizani kuphatikiza kiyi Ctrl + C kapena gwiritsani ntchito njira ina iliyonse.
3. Yambitsani pulogalamu ya Notepad, yomwe imabwera yokhazikika ndi Windows. Ili mu Start menyu. Njira yeniyeni ingasiyane pang'ono kutengera mtundu wa opaleshoni. Koma kupeza pulogalamu sikovuta mulimonsemo. 
4. Tumizani zomwe mwakopera ku Notepad pogwiritsa ntchito kiyi Ctrl + V.
5. Dinani batani la Tab ndikukopera zilembo izi.
6. Kenako, sinthani munthuyu ndi wina aliyense pogwiritsa ntchito bokosi la zokambirana "M'malo".
7. Sankhani malemba onse, koperani.
8. Bwererani ku Excel, sankhani selo limodzi lokha (B1 kwa ife) ndikuyika mawuwo patebulo.

Zimangotsala kutchulanso gawoli.

Momwe mungaphatikizire mizati iwiri muzosavuta 4?

Kuti muchite izi:

1. Download wapadera addon. 
2. Sankhani mizati iwiri ndikupita ku tabu "Ablebits.com Data". Dinani batani "Phatikizani Maselo".
3. Sankhani zomwe zikuwonetsedwa pachithunzichi.
4. Masitepe ochepa osavuta, ndipo timapeza zotsatira zabwino kwambiri popanda zina zowonjezera.

Kuti mumalize, ingosinthani dzina B kukhala "Dzina Lonse" ndikuchotsa gawo C, lomwe silikufunikanso.