Okuqukethwe
Ukwethulwa kwedokhumenti kuncike ngokuqondile ekutheni idatha yakhiwe kanjani. Ungasiza ukuhlela idatha ngendlela enhle nelula ngokuyifometha ibe amatafula ku-Excel, okungenakwenzeka ukusebenza ngaphandle kokusebenza okuhlukahlukene ngamaseli. Izinguquko kumaseli, imigqa namakholomu zisiza ukwenza ithebula lifundeke kakhudlwana futhi libe lihle, amaseli ahlukanisayo kungenye inketho enjalo. Kunezindlela ezimbalwa ezilula ezithandwayo zokuhlukanisa amaseli, okuzoxoxwa ngakho ngezansi.
Indlela 1: Ukuhlanganisa Amaseli Asondelene Amaningi
Iseli kuthebula iyunithi yokulinganisa encane kakhulu ngakho-ke iyingxenye engahlukaniseki. Umsebenzisi angakwazi ukushintsha usayizi wawo, awuhlanganise nomakhelwane, kodwa angawuhlukanisi. Kodwa-ke, ngosizo lwamanye amaqhinga, ungenza ukuhlukaniswa okubonakalayo kube mpo, umugqa ovundlile kanye ne-diagonal. Usebenzisa le ndlela, ungahlukanisa amaseli ku-Excel ngokuhlanganisa amaseli ancikene. I-algorithm elandelayo:
- Thola amaseli azohlukaniswa. Kulesi sibonelo, ukuhlukaniswa kube izingxenye ezi-2 kuzocatshangelwa.
- Khetha amaseli amabili ancikene, chofoza okuthi “Hlanganisa futhi Maphakathi” kuthebhu ethi “Ukuqondanisa”.
- Yenza okufanayo nakwamanye amaseli emgqeni.
Ngokufanayo, ungenza ukwahlukanisa ube inombolo ehlukile yezingxenye ngaphandle kwezimbili. Ngokuqhubekayo, usebenzisa izenzo ezijwayelekile, ungalungisa osayizi bamaseli, amakholomu nemigqa. Ngenxa yalokho, amakholomu angaphansi kweseli azohlukaniswa ngokubukeka abe yisigamu, futhi ulwazi oluvela etafuleni luzotholakala maphakathi neseli.
Indlela 2: hlukanisa amaseli ahlanganisiwe
Indlela isetshenziselwa ukuhlukanisa amaseli athile kuthebula noma yikuphi kudokhumenti. Udinga ukwenza lezi zinyathelo ezilandelayo:
- Khetha amakholomu noma imigqa kuphaneli yezixhumanisi lapho amaseli ahlukene azoba khona. Kulesi sibonelo, kuzoba nokuhlukaniswa ngamakholomu.
- Chofoza umcibisholo kubha yamathuluzi eduze kwesithonjana sokuhlanganisa nokuthi maphakathi bese ukhetha Hlanganisa Ngemigqa.
- Kusuka kumakholomu angu-2 ngokubonakalayo kuzovela eyodwa. Okulandelayo, kufanele uthole izakhi ezizohlukaniswa zibe izingxenye ezimbili, chofoza kuzo bese ukhetha "Hlanganisa futhi ubeke phakathi."
Ngendlela efanayo, ungahlukanisa ube izingxenye eziningi, kodwa uzodinga ukuhlanganisa ikholomu ngayinye ngokwehlukana. Ngale ndlela, amaseli akhethiwe azohlanganiswa abe elilodwa, futhi okuqukethwe kuzobekwa phakathi nendawo.
Kubalulekile ukuqaphela ukuthi ukuhlukanisa amaseli akuzuzisi ngaso sonke isikhathi. Kungcono ukuyisebenzisa uma udinga kuphela ukuhlukanisa iseli. Uma ukuhlunga nokunye kusetshenziswa kudokhumenti, ama-elementi ahlukene azokweqiwa.
Indlela yesi-3: Ukuhlukaniswa kwamaseli ediagonal
Amathebula amaningi angase adinge ukwahlukaniswa hhayi ngokuqondile nangokuvundlile, kodwa ngokudayagonali. Ungenza ukuhlukaniswa kwe-diagonal usebenzisa amathuluzi e-Excel akhelwe ngaphakathi. Ukuze wenze lokhu udinga:
- Chofoza kwesokudla entweni lapho kudingeka khona ukuhlukaniswa kwe-diagonal, faka umbhalo kuyo ngemigqa emibili.
- Khetha "Fometha Amaseli".
- Ewindini elivelayo, khetha ithebhu "Border". Okulandelayo, izithonjana ezimbili ezine-diagonal division zizovela, udinga ukukhetha ezifanele. Amapharamitha womugqa angalungiswa njengoba kudingeka.
- Chofoza futhi inkinobho enomugqa we-diagonal.
- Cindezela OK.
Nakani! Iseli lizohlukaniswa ngokubonakalayo, kodwa uhlelo luyibona iyonke.
Indlela yesi-4: Dweba isihlukanisi ngethuluzi le-Shapes
Umsebenzi wokufaka umumo ungase futhi usetshenziselwe ukuhlukanisa imidwebo ngokudweba umugqa. I-algorithm elandelayo:
- Khetha into ozoyihlukanisa.
- Yiya kuthebhu ethi "Faka" bese uchofoza "Amamo".
- Khetha uhlobo lomugqa olufanele ohlwini lwezinketho eziphakanyisiwe.
- Sebenzisa inkinobho yegundane engakwesokunxele ukuze udwebe isihlukanisi.
Iseluleko! Kuthebhu ethi "Fometha", ungashuna kahle umugqa odwetshiwe.
Isiphetho
Ukufundeka kungenye yezidingo eziyinhloko zanoma iyiphi idatha ehlelekile. Uma ithebula lizoba nokubukeka okuyinkimbinkimbi namaseli ahlanganisiwe noma ahlanganisiwe, imigqa noma amakholomu, uzodinga ukwenza imisebenzi efanele. Ngisho noma iseli liyinto encane kakhulu yetafula, amathuluzi akhelwe ngaphakathi ku-Excel akuvumela ukuthi uyihlukanise ngokuyibuka ibe izingxenye ezi-2, ezi-3 noma ngaphezulu noma yikuphi kuthebula usebenzisa izindlela ezingenhla.