Uma usebenzisa ama-spreadsheets e-Excel, ngezinye izikhathi kudingekile ukuhlukanisa iseli elithile zibe izingxenye ezimbili. Kodwa, akulula njengoba kubonakala ekuqaleni. Ake sibone indlela yokuhlukanisa iseli zibe izingxenye ezimbili ku-Microsoft Excel, nokuthi ungayahlukanisa kanjani.
Ukuhlukaniswa kwamaseli
Ngokushesha kufanele kuqashelwe ukuthi amangqamuzana e-Microsoft Excel yizona zakhi eziyinhloko zokwakha, futhi azikwazi ukuhlukaniswa zibe izingxenye ezincane, uma zingenakumbalwa ngaphambilini. Kodwa, yini okufanele uyenze uma, isibonelo, sidinga ukudala i-header ithebula eyinkimbinkimbi, esinye sezigaba zazo esihlukaniswe sibe yizigatshana ezimbili? Kulokhu, ungasebenzisa amacebo amancane.
Indlela 1: Hlanganisa Amaseli
Ukuze amaseli athile avele ehlukene, kubalulekile ukuhlanganisa amanye amaseli etafula.
- Kubalulekile ukucabanga ngesakhiwo sonke setafula elizayo.
- Ngaphezulu kwendawo eshicilelwe lapho kudingeka ube nesici esahlukanisiwe, khetha amaseli amabili aseduze. Ukuba ngaphakathi kuthebhu "Ikhaya"ebuka ebhodini lamathuluzi "Ukuqondanisa" ku-inkinobho yebhebhoni "Hlanganisa futhi ubeke phakathi". Chofoza kuso.
- Ukuze kucaciswe, ukuze sibone kangcono lokho esinakho, sibeka imingcele. Khetha lonke uhla lwamaseli esiwahlela ukuwabela ngaphansi kwetafula. Kuthebhu efanayo "Ikhaya" ebhodini lamathuluzi "Ifonti" chofoza kusithonjana "Imingcele". Ohlu oluvela, khetha into "Yonke imingcele".
Njengoba ungabona, naphezu kokuthi asizange sihlukanise, kodwa esikhundleni salokhu kuxhunyiwe, ukukhohliswa kweseli ehlukanisiwe kudalwe.
Isifundo: Indlela yokuhlanganisa amaseli ku-Excel
Indlela 2: Amaseli ahlanganisiwe ahlukene
Uma sidinga ukuhlukanisa iseli hhayi ekhanda, kodwa phakathi kwetafula, bese kulesi simo, kulula ukuhlanganisa wonke amaseli amakholomu amabili aseduze, futhi kuphela ukuhlukanisa iseli elifunayo.
- Khetha amakholomu amabili aseduze. Chofoza kumcibisholo eduze kwenkinobho "Hlanganisa futhi ubeke phakathi". Kulolu hlu olubonakalayo, chofoza entweni "Hlanganisa ngomugqa".
- Chofoza kuseli elihlanganisiwe ofuna ukuhlukanisa. Futhi, chofoza umcibisholo eduze kwenkinobho "Hlanganisa futhi ubeke phakathi". Okwamanje, khetha into "Khansela i-Association".
Ngakho sathola iseli ehlukaniswe. Kodwa, kubalulekile ukucabangela ukuthi i-Excel ibona ngale ndlela indlela yeseli ehlukanisiwe njengento eyodwa.
Indlela yesithathu: ukuhlukanisa ngokuhlukanisa ngokufometha
Kodwa, ngokulandelana, ungahlukanisa ngisho neseli ejwayelekile.
- Sichofoza ngakwesokudla kuseli elifunayo, futhi kumenyu yokuqukethwe evelayo, ukhethe into "Fometha amaseli ...". Noma, siyiphatha isinqamuleli sekhibhodi Ctrl + 1.
- Ewindini lefomathi yesifthiwe evuliwe, iya kuthebhu "Umngcele".
- Eduze phakathi kwefasitela "Ukubhalwa" Chofoza kwenye yezinkinobho ezimbili, ezibonisa umugqa oblique osuselwe ngakwesokudla kuya kwesobunxele, noma kusukela kwesobunxele kuya kwesokudla. Khetha inketho oyifunayo. Lapha ungakhetha uhlobo nombala womugqa. Uma ukhetho lwenziwa, chofoza inkinobho ethi "Kulungile".
Ngemuva kwalokho, iseli lizohlukaniswa nge-slash diagonally. Kodwa, kubalulekile ukucabangela ukuthi i-Excel ibona ngale ndlela indlela yeseli ehlukanisiwe njengento eyodwa.
Indlela 4: ukwehlukanisa ngokuhlukanisa ngokufaka umumo
Indlela elandelayo ifanelekile ukwehlukanisa iseli diagonally kuphela uma likhulu, noma lidalwe ngokuhlanganisa amangqamuzana amaningana.
- Ukuba ngaphakathi kuthebhu "Faka", ebhodini lamathuluzi "Imizekeliso", chofoza inkinobho "Amanani".
- Emenyu evulekayo, ku-block "Imigqa", chofoza isibalo sokuqala.
- Dweba umugqa kusuka ekhoneni kuya ekhoneni leseli ngendlela oyidingayo.
Njengoba ungabona, naphezu kokuthi ku-Microsoft Excel, azikho izindlela ezijwayelekile zokuhlukanisa iseli eliyinhloko zibe izingxenye, usebenzisa izindlela eziningana, ungafinyelela umphumela oyifunayo.
