Lapho usebenza namatafula e-Excel, ngesinye isikhathi udinga ukuphula iseli ethile libe izingxenye ezimbili. Kepha, akulula njengoba kubonakala ekuqaleni. Ake sibheke ukuhlukanisa iseli libe izingxenye ezimbili kuMicrosoft Excel, nokuthi ungayihlukanisa kanjani ngocingo.
Ukwahlukanisa amaseli
Kufanele kwaziwe ngaso leso sikhathi ukuthi amaseli kuMicrosoft Excel ayizakhi eziyisisekelo zokwakheka, futhi angeke ahlukaniswe izingxenye ezincanyana uma bekungazange kuhlanganiswe ngaphambili. Kepha kuthiwani uma, ngokwesibonelo, sidinga ukudala inhloko yetafula eyinkimbinkimbi, esinye sezingxenye sazo esihlukaniswe izigaba ezimbili? Kulokhu, ungasebenzisa amaqhinga amancane.
Indlela yoku-1: Hlanganisa Amaseli
Ukuze amaseli athile abonakale ehlukanisiwe, kufanele uhlanganise namanye amaseli etafuleni.
- Kuyadingeka ukucabanga ngesakhiwo sonke setafula elizayo.
- Ngaphezulu kwaleyo ndawo eshidini lapho udinga khona into ehlukanisiwe, khetha amaseli amabili aseduze. Ukuba kuthebhu "Ikhaya", bheka ibhulokhi yamathuluzi Ukuqondanisa inkinobho iribhoni "Hlanganisa nesikhungo". Qhafaza kuwo.
- Ukucaciseleka, ukuze ubone kangcono esikwenzile, sabeka imingcele. Khetha lonke uhla lwamaseli esihlela ukuwabekela itafula. Kuthebhu efanayo "Ikhaya" ebhokisini lamathuluzi Ifonti chofoza isithonjana "Imingcele". Kuluhlu olubonakala, khetha "Yonke Imingcele".
Njengoba ubona, ngaphandle kweqiniso lokuthi asizange sabelane ngokuthile, kepha kunalokho okuxhunyiwe, kwakha ukukhohlisa kweseli elihlukanisiwe.
Isifundo: Ungawahlanganisa kanjani amaseli ku-Excel
Indlela 2: ukwahlukanisa amaseli ahlanganisiwe
Uma sidinga ukuhlukanisa isitokisi hhayi kunhlokweni, kepha phakathi kwetafula, kulokhu-ke, kulula ukuhlanganisa wonke amaseli wamakholomu amabili aseceleni, bese kuphela uhlukanisa iseli oyifunayo.
- Khetha amakholomu amabili asondele. Chofoza umcibisholo eduze nenkinobho "Hlanganisa nesikhungo". Kuluhlu olubonakala, chofoza entweni Hlanganisa Umugqa.
- Chofoza kuseli elihlanganisiwe ofuna ukulihlukanisa. Futhi, chofoza umcibisholo eduze nenkinobho "Hlanganisa nesikhungo". Manje khetha into Khansela Inhlangano.
Ngakho-ke sineseli elihlukanisayo. Kepha, udinga ukubheka ukuthi i-Excel ibona ngale ndlela iseli elihlukaniswe njengento eyodwa.
Indlela 3: Ihlukaniswa ngokobuciko ngokufometha
Kepha, ngocingo, ungahlukanisa ngisho neseli elijwayelekile.
- Sichofoza ngakwesokudla kuseli elifunayo, futhi kumenyu yokuqukethwe evela, khetha into "Ifomethi yeseli ...". Noma, ukuthayipha isinqamuleli sekhibhodi kwikhibhodi I-Ctrl + 1.
- Ewindini elivuliwe lefomathi yeseli, iya kuthebhu "Umngcele".
- Eduze kwaphakathi kwewindi "Okubhaliwe" sichofoza kwesinye sezinkinobho ezimbili lapho umugqa we-oblique udonswa khona, ususwe kwesokunxele uye kwesokunxele, noma usuka kwesobunxele uye kwesokudla. Khetha inketho oyidingayo. Ungakwazi ukukhetha ngokushesha uhlobo nombala wolayini. Lapho kwenziwa ukhetho, chofoza inkinobho "Kulungile".
Emva kwalokho, iseli lizohlukaniswa yisilayidi ngokokuphamba. Kepha, udinga ukubheka ukuthi i-Excel ibona ngale ndlela iseli elihlukaniswe njengento eyodwa.
Indlela 4: Ngehlukaniswe ngokokufaka ngokufaka ukwakheka
Indlela elandelayo ilungele ukulengisa iseli kuphela uma inkulu, noma idalwe ngokuhlanganisa amaseli ambalwa.
- Ukuba kuthebhu Faka, kubha yamathuluzi "Imifanekiso", chofoza inkinobho "Izimo".
- Kumenyu evulayo, ebhlokini "Imigqa", chofoza isibalo sokuqala.
- Dweba umugqa usuka ekhoneni uye ekhoneni leseli oqonde kulo oludingayo.
Njengoba ukwazi ukubona, naphezu kweqiniso lokuthi kuMicrosoft Excel azikho izindlela ezijwayelekile zokuhlukanisa iseli eliyinhloko libe izingxenye, usebenzisa izindlela eziningana ongathola ngazo umphumela oyifunayo.
