Isifundo sokukhetha ithebula ku-Excel

Uhlelo lwe-Excel lwenzelwe ukwenza izibalo ezehlukene zezibalo, ukwakha amathebula, amagrafu namashadi. Ukuze wenze noma yiziphi izenzo ngethebula, kufanele ukwazi ukulikhetha ngendlela efanele.

Ngokuya ngosayizi wamatafula, ukuba khona kwanoma yimaphi amanani ezindaweni ezingomakhelwane, kunezinketho ezi-3 zokukhetha amatafula ku-Excel. Ukukhetha okwamukelekayo kakhulu, kuyadingeka ukucabangela ngamunye wabo ngokuningiliziwe.

Inketho 1: ukugqamisa ithebula ngegundane

Indlela ilula futhi ivame kakhulu. Izinzuzo zayo, yiqiniso, zilula futhi ziqondakala inombolo enkulu yabasebenzisi. Okubi yiqiniso lokuthi le nketho ayilungele ukwaba itafula elikhulu, kodwa, noma kunjalo, iyasebenza.

Ngakho-ke, ukukhetha ithebula ngale ndlela, udinga ukucindezela inkinobho yegundane kwesokunxele, bese uyibamba, khetha yonke indawo yetafula kusukela ekhoneni eliphezulu kwesokunxele kuya ekhoneni elingezansi kwesokudla.

Ngaphezu kwalokho, ungaqala ukukhetha nokunyakazisa igundane kusuka ekhoneni elingaphezulu kwesokunxele kanye nasekhoneni elingezansi kwesokudla, ukhethe elibhekene ne-diametrically njengephoyinti lokugcina. Kusukela ekukhethweni kwamaphuzu okuqala nokuphela, ngeke kube khona umehluko kumphumela.

Inketho 2: okhiye abashisayo bokukhethwa

Ukukhetha amatafula amakhulu, kulula kakhulu ukusebenzisa isinqamuleli sekhibhodi "CTRL + A" ("Cmd + A" - ye-macOS). Ngendlela, le ndlela ayisebenzi ku-Excel kuphela, kodwa nakwezinye izinhlelo.

Sicela uqaphele ukuthi ukukhetha itafula usebenzisa le ndlela, kune-nuance encane - okwamanje izinkinobho ezishisayo zicindezelwa, isikhombisi segundane kufanele sibekwe esitokisini esiyingxenye yetafula. Labo. ukuze ukhethe ngempumelelo yonke indawo yetafula, udinga ukuchofoza kunoma iyiphi iseli etafuleni bese ucindezela inhlanganisela yokhiye “Ctrl + A” kukhibhodi.

Ukucindezela okhiye abashisayo abafanayo futhi kuzokhetha ishidi lonke.

Uma ikhesa ibekwe ngaphandle kwetafula, ukucindezela okuthi Ctrl+A kuzokhetha lonke ishidi kanye netafula.

Inketho yesi-3: Khetha ngokhiye u-Shift

Kule ndlela, ubunzima njengakweyesibili akufanele buvele. Nakuba le nketho yokukhetha iyinde kancane mayelana nokuqaliswa kunokusebenzisa ama-hotkeys, ingcono kakhulu kwezinye izimo, futhi ilula kakhulu kunenketho yokuqala, lapho amatafula akhethwa kusetshenziswa igundane.

Ukukhetha ithebula ngale ndlela, kufanele ulandele le nqubo elandelayo:

1. Beka ikhesa kuseli engaphezulu kwesokunxele setafula.
2. Cindezela ukhiye we-Shift bese uchofoza kuseli elingezansi kwesokudla. Ungabese ukhulula ukhiye we-Shift.
3. Uma ithebula likhulu kakhulu ukuthi lingalingana esikrinini, qala ngokubeka ikhesa kuseli yokuqala, bese upheqa ithebula, uthole indawo yokugcina, bese ulandela izinyathelo ezingenhla.

Ngakho, lonke ithebula lizokhethwa. Ingamakwa ngokusebenzisa le nqubo kokubili ohlangothini olungenhla nakwehlukile. Labo. esikhundleni seseli engaphezulu kwesokunxele, ungakhetha ngezansi kwesokudla njengendawo yokuqala, ngemuva kwalokho udinga ukuchofoza kwesokunxele phezulu.

Isiphetho

Ezintweni ezintathu ongakhetha kuzo zokukhetha ithebula ku-Excel echazwe ngenhla, ungasebenzisa zontathu. Futhi lapho ukhetha indlela ethile, kubalulekile ukucabangela, okokuqala, ubukhulu betafula. Indlela yokuqala ilula futhi iqondakala kakhulu, kodwa ingcono futhi ilungele ukuyisebenzisa ematafuleni amancane. Njengoba ukukhethwa kwendawo yonke yetafula ngegundane kuyoba nzima kakhulu uma itafula liqukethe inombolo enkulu yemigqa, ngenxa yalokho kuzodingeka ubambe inkinobho yegundane kwesokunxele isikhathi eside. Inketho yesibili enama-hotkeys ishesha kakhulu, kepha ama-nuances ayo angabangela ubunzima obuthile kumsebenzisi. Indlela yesithathu igwema lobu bunzima, kodwa ithatha isikhathi eside kunokusebenzisa inhlanganisela yenkinobho ehlongozwayo kunketho yesibili.