Zamkatimu
Pogwira ntchito ndi matebulo ku Excel, ogwiritsa ntchito nthawi zambiri amafunika kuphatikiza ma cell ena. Payokha, ntchitoyi sivuta ngati mulibe deta m'maselo awa, mwachitsanzo, alibe kanthu. Koma bwanji ngati ma cell ali ndi chidziwitso chilichonse? Kodi deta idzatayika pambuyo pophatikizana? M’nkhaniyi tikambirana mwatsatanetsatane nkhaniyi.
Timasangalala
Momwe mungaphatikizire ma cell
Njirayi ndiyosavuta ndipo ingagwiritsidwe ntchito pazifukwa zotsatirazi:
- Phatikizani ma cell opanda kanthu.
- Kuphatikiza ma cell pomwe amodzi okha ali ndi data yodzazidwa.
Choyamba, muyenera kusankha ma cell kuti agwirizane ndi batani lakumanzere. Kenaka timapita ku mndandanda wa pulogalamu pa "Home" tabu ndikuyang'ana chizindikiro chomwe tikufuna pamenepo - "Gwirizanitsani ndi kuika pakati".
Ndi njirayi, maselo osankhidwa adzaphatikizidwa mu selo limodzi, ndipo zomwe zili mkati mwake.
Ngati mukufuna kuti chidziwitsocho zisakhazikike, koma poganizira masanjidwe a cell, muyenera dinani kachidutswa kakang'ono komwe kamakhala pafupi ndi chithunzi cha kuphatikiza ma cell ndikusankha chinthu cha "Gwirizanitsani Ma cell" pamenyu yomwe imatsegulidwa.
Ndi njira iyi yophatikizira, deta idzayanjanitsidwa kumphepete kumanja kwa selo lophatikizidwa (mwachisawawa).
Pulogalamuyi imapereka mwayi wophatikizana mzere ndi mzere wa maselo. Kuti muchite izi, sankhani mitundu yofunikira yamaselo, yomwe ili ndi mizere ingapo, ndikudina chinthucho "Gwirizanitsani ndi Mizere".
Ndi njira iyi yophatikizira, zotsatira zake zimakhala zosiyana: maselo amaphatikizidwa kukhala amodzi, koma kusweka kwa mzere kumasungidwa.
Maselo amathanso kuphatikizidwa pogwiritsa ntchito menyu yankhani. Kuti muchite ntchitoyi, sankhani malo oti muphatikizepo ndi cholozera, dinani kumanja, kenako sankhani "Maselo a Format" pamndandanda.
Ndipo pazenera lomwe likuwoneka, sankhani chinthucho "Malumikizidwe" ndikuyika chizindikiro kutsogolo kwa "Gwirizanitsani ma cell". Pamndandandawu, mutha kusankhanso zosankha zina zophatikiza: kukulunga mawu, m'lifupi mwake, kuyang'ana kopingasa komanso koyima, mayendedwe, njira zingapo zolumikizirana, ndi zina zambiri. Pambuyo magawo onse akhazikitsidwa, dinani "Chabwino".
Chifukwa chake, monga momwe timafunira, ma cell adalumikizana kukhala amodzi.
Momwe mungaphatikizire ma cell osataya deta
Koma bwanji ngati maselo angapo ali ndi deta? Zowonadi, ndi kuphatikiza kosavuta, zidziwitso zonse, kupatula cell yakumanzere yakumanzere, zidzachotsedwa.
Ndipo ntchito yooneka ngati yovutayi ili ndi yankho. Kuti muchite izi, mutha kugwiritsa ntchito "CONNECT".
Choyamba ndi kuchita zotsatirazi. Selo yopanda kanthu iyenera kuwonjezeredwa pakati pa maselo ophatikizidwa. Kuti muchite izi, muyenera dinani kumanja pamzati / mzere nambala yomwe tikufuna kuwonjezera mzere / mzere watsopano ndikusankha "Ikani" kuchokera pamenyu yomwe imatsegulidwa.
Mu cell yatsopano yomwe yatuluka, lembani fomula molingana ndi template iyi: “=CONCATENATE(X,Y)“. Pakadali pano, X ndi Y ndizofunika zomwe zimagwirizanitsa ma cell omwe akuphatikizidwa.
Kwa ife, tiyenera kugwirizanitsa maselo B2 ndi D2, zomwe zikutanthauza kuti timalemba ndondomeko "=CONCATENATE(B2,D2)” ku cell C2.
Zotsatira zake zidzakhala gluing deta mu selo ophatikizidwa. Komabe, monga mukuwonera, tili ndi maselo atatu athunthu, m'malo mwa amodzi ophatikizidwa: awiri oyambilira ndipo, molingana, ophatikizana okha.
Kuti muchotse ma cell owonjezera, dinani (dinani-kumanja) pa selo lophatikizana. Pamndandanda wotsitsa, dinani "Koperani".
Kenako, pitani ku selo kumanja kwa ophatikizidwa (omwe ali ndi deta yoyambirira), dinani kumanja kwake, kenako sankhani "Paste Special" pamndandanda.
Pazenera lomwe limatsegulidwa, sankhani "Values" pazosankha zonse ndikudina "Chabwino".
Zotsatira zake, selo ili lidzakhala ndi zotsatira za selo C2, momwe timagwirizanitsa mfundo zoyamba za maselo B2 ndi D2.
Tsopano, titatha kuyika zotsatira mu selo D2, tikhoza kuchotsa maselo owonjezera omwe sakufunikanso (B2 ndi C2). Kuti muchite izi, sankhani ma cell / mizati yowonjezera ndi batani lakumanzere la mbewa, kenako dinani kumanja pazomwe mwasankha ndikusankha "Chotsani" pamenyu yomwe imatsegulidwa.
Chotsatira chake, selo limodzi lokha liyenera kukhala, momwe deta yophatikizidwa idzawonetsedwa. Ndipo maselo onse owonjezera omwe atuluka pazigawo zapakati za ntchito adzachotsedwa patebulo.
Kutsiliza
Chifukwa chake, palibe chovuta pakuphatikizana kwa cell. Koma kuti muphatikize ma cell ndikusunga deta, muyenera kugwira ntchito pang'ono. Komabe, ntchitoyi ndi yotheka chifukwa cha magwiridwe antchito a pulogalamu ya Excel. Chinthu chachikulu ndikukhala oleza mtima ndikutsatira ndondomeko yoyenera ya zochita. Tikukulimbikitsani kuti musanayambe ntchito, pokhapokha, pangani kopi ya chikalatacho, ngati mwadzidzidzi chinachake sichikuyenda ndipo deta yatayika.
Zindikirani: Ntchito zonse zomwe zili pamwambapa zitha kugwiritsidwa ntchito pama cell amizere (mizere ingapo) ndi ma cell amizere (mizere ingapo). Mndandanda wa zochita ndi kupezeka kwa ntchito kumakhalabe chimodzimodzi.