Ukusebenza ngamatafula kungumsebenzi oyinhloko we-Excel. Ukuze wenze isenzo esiyinkimbinkimbi kuyo yonke indawo yetafula, kufanele uyikhethe kuqala njengefreyimu eqinile. Akubona bonke abasebenzisi abakwazi ukukwenza kahle lokhu. Ngaphezu kwalokho, kunezindlela eziningi zokugqamisa le nto. Ake sibheke ukuthi, ngokusebenzisa izinketho ezahlukahlukene, ungakwenza kanjani lokhu kukhwabanisa etafuleni.
Inqubo Yesisodwa
Kunezindlela eziningana zokukhetha itafula. Zonke zilula futhi zisebenza cishe kuwo wonke amacala. Kepha ngaphansi kwezimo ezithile, ezinye zalezi zinketho zilula ukuzisebenzisa kunezinye. Ake sigxile emibonweni yokusebenzisa ngayinye yazo.
Indlela yoku-1: Ukukhetha okulula
Ukukhethwa kwetafula okuvame kakhulu ukuthi cishe bonke abasebenzisi basebenzise ukusetshenziswa kwegundane. Indlela ilula futhi inembile ngangokunokwenzeka. Bamba inkinobho yegundane kwesobunxele bese unyakazisa isikhombisi kulo lonke uhla lwethebula. Inqubo ingenziwa ku-perimeter naku-diagonal. Kunoma yikuphi, wonke amaseli akule ndawo azomakwa.
Ukulula kanye nokucaca kuyizinzuzo eziphambili zale nketho. Ngasikhathi sinye, yize kusebenza futhi kumatafula amakhulu, akulula kakhulu ukuyisebenzisa.
Isifundo: Ungawakhetha kanjani amaseli ku-Excel
Indlela 2: ukukhetha ngenhlanganisela yokhiye
Uma usebenzisa amatafula amakhulu, indlela elula kakhulu ukusebenzisa inhlanganisela ye-hotkey I-Ctrl + A. Ezinhlelweni eziningi, lokhu kuhlanganiswa kuphumela ekugqanyisweni kwalo lonke idokhumenti. Ngaphansi kwezimo ezithile, lokhu kuyasebenza naku-Excel. Kepha kuphela uma umsebenzisi ebeka le nhlanganisela lapho isesigcini esitokisini esingenalutho noma kuseli elihlukile eligcwele. Uma ucindezela inhlanganisela yezinkinobho I-Ctrl + A ukukhiqiza lapho ikhesa ikwelinye lamaseli we-array (izinto ezimbili noma ngaphezulu ezisondelene ezigcwaliswe ngemininingwane), ke lokho kuqhafaza kokuqala kuzoqokomisa le ndawo kuphela futhi kungokwesibili kuphela - lonke ishidi.
Futhi itafula, empeleni, libanga eliqhubekayo. Ngakho-ke, sichofoza kunoma yiliphi lamaseli alo bese sithayipha ukuhlanganiswa kwezinkinobho I-Ctrl + A.
Ithebula lizogqanyiswa njengobubanzi olulodwa.
Inzuzo engabazeki yale nketho ukuthi ngisho netafula elikhulu kunawo wonke lingakhethwa cishe khona manjalo. Kodwa le ndlela futhi ine "izingibe" zayo. Uma noma iliphi inani noma isichasiselo lifakwa ngqo esitokisini eduze kwemingcele yendawo yetafula, ikholomu eliseduze noma umugqa lapho leli nani litholakala khona lizokhethwa ngokuzenzakalelayo. Lesi simo sezinto asemukelekile ngaso sonke isikhathi.
Isifundo: Izitolo ezishisayo
Indlela 3: Shift
Kukhona indlela yokusiza ukuxazulula inkinga echazwe ngenhla. Vele, ayihlinzeki ngokwabiwa kwamanje, ngoba lokhu kungenziwa kusetshenziswa isinqamuleli sekhibhodi I-Ctrl + A, kepha ngasikhathi sinye samatafula amakhulu kungcono kakhulu futhi kufanelekile kunokukhethwa okulula okuchazwe embodiment yokuqala.
- Bamba ukhiye I-Shift kukhibhodi, beka isikhombisi esitokisini esingaphezulu ngakwesokunxele bese uqhafaza kwesobunxele.
- Ngaphandle kokukhipha ukhiye I-Shift, skrolela ishidi ekugcineni kwetafula, uma lingalingani ukuphakama esibukweni sokuqapha. Sibeka isikhombisi esitokisini esingezansi kwesokudla sendawo yetafula bese siphinda sichofoza inkinobho yegundane kwesobunxele.
Ngemuva kwalesi senzo, kuzokhethwa itafula lonke. Ngaphezu kwalokho, ukukhetha kuzokwenzeka kuphela phakathi kobubanzi phakathi kwamaseli amabili esichofoze kuwo. Ngakho-ke, noma ngabe kunezindawo zedatha emabangeni asondelene, ngeke afakwe kulokhu kukhethwa.
Ukuhlukaniswa kungenziwa futhi ngokulandelana okuphambene. Okokuqala iseli elingaphansi, bese kuba ngaphezulu. Ungaqhubeka nenqubo kwenye indawo: khetha amaseli aphezulu aphezulu nangaphansi kwesokunxele ukhiye ocindezelwe I-Shift. Umphumela wokugcina awuxhomekile enkombeni nasekuhlelweni.
Njengoba ukwazi ukubona, kunezindlela ezintathu eziyinhloko zokukhetha itafula ku-Excel. Owokuqala wabo udume kakhulu, kepha ophazamisayo ezindaweni ezinkulu zetafula. Inketho esheshayo ukusebenzisa isinqamuleli sekhibhodi I-Ctrl + A. Kepha kunezinkinga ezithile ezingasuswa kusetshenziswa inketho usebenzisa inkinombo I-Shift. Ngokuvamile, ngaphandle kokungajwayelekile, zonke lezi zindlela zingasetshenziswa kunoma yisiphi isimo.
