Ukusebenza ngamatafula kuwumsebenzi ophambili wohlelo lwe-Excel. Ukuze wenze umphumela ohlanganisiwe ngaphezu kwayo yonke indawo ye-tabular, kufanele uqale wabe njengoluhlu oluqinile. Akubona bonke abasebenzisi abakwaziyo ukukwenza kahle. Ngaphezu kwalokho, kunezindlela eziningana zokwaba le nto. Ake sifunde ukuthi ngosizo lwezinketho ezahlukahlukene, ungakhiqiza lokhu kukhohlisa phezu kwetafula.
Inqubo yokukhetha
Kunezindlela eziningana zokuqokomisa itafula. Zonke zilula futhi zisebenza cishe kuwo wonke amacala. Kepha ngaphansi kwezimo ezithile, enye yalezi zinketho ilula kunezinye. Masihlale emalongeni okusebenzisa ngakunye kwawo.Indlela 1: Ukukhetha okulula
Inketho evame kakhulu ukugqamisa ithebula, elisetshenziswa cishe ngabo bonke abasebenzisi - lokhu ukusetshenziswa kwegundane. Indlela elula ngangokunokwenzeka futhi iqonda kahle. Sula inkinobho yegundane kwesobunxele bese unikeza lonke uhla lwetafula nesikhombisi. Inqubo ingenziwa zombili ezizungeze i-perimeter nakwi-diagonally. Kunoma ikuphi, wonke amaseli ale ndawo azomakwa.
Kulula futhi kucace - inzuzo eyinhloko yale nketho. Ngasikhathi sinye, yize kumatafula amakhulu, kuyasebenza futhi, kepha akukubi kakhulu ukuyisebenzisa.
Isifundo: Ungagcizelela kanjani amaseli e-Excel
Indlela 2: Ukukhetha inhlanganisela yokhiye
Lapho usebenzisa amatafula amakhulu, indlela elula kakhulu ukusebenzisa inhlanganisela yezinkinobho ezishisayo i-CTRL + a. Ezinhlelweni eziningi, le nhlanganisela iholela ekwabiweni kwawo wonke umqulu. Ngaphansi kwezimo ezithile, lokhu kusebenza ehlane. Kepha kuphela uma umsebenzisi eshayela le nhlanganisela lapho isikhombisi singenalutho noma esitokisini esiqediwe. Uma ucindezela inhlanganisela ye-CTRL + Izinkinobho zokukhiqiza lapho ikhesa kungenye yamangqamuzana aqothulayo (amabili nangaphezulu eduze kwento egcwele idatha egcwele) kuphela lapho kuphela Okwesibili - lonke ishidi.
Futhi itafula empeleni, uhla oluqhubekayo. Ngakho-ke, chofoza kunoma yisiphi iseli bese uthayipha i-CTRL + inhlanganisela yekhibhodi.
Ithebula lizoqokonyiswa njengebanga elilodwa.
Inzuzo engenamikhawulo yale nketho ukuthi ngisho netafula elikhulu kakhulu lingaqokonyiswa cishe ngokushesha. Kepha le ndlela inezinto zayo "izingibe". Uma inani elithile noma inothi liqoshwe ngqo esitokisini sendawo yomngcele noma inothi, khona-ke ikholomu noma intambo eseduze izoqokonyiswa ngokuzenzakalela, lapho leli nani likhona. Lesi simo sezinto asona ngaso sonke isikhathi samukelekile.
Isifundo: Okhiye abashisayo ku-evelela
Indlela 3: Ukukhetha ukhiye we-Shift
Kunendlela yokusiza ukuxazulula inkinga echazwe ngenhla. Vele, akuhlinzeki ngokukhethwa okusheshayo, njengoba kungenziwa kusetshenziswa i-CTRL + inhlanganisela yokhiye, kepha ngasikhathi sinye, kumatafula amakhulu, kungcono kakhulu kunokukhethwa okulula okuchazwe kwinguqulo yokuqala.
- Chofoza ukhiye we-Shift kwikhibhodi, usethe isikhombisi esitokisini esingenhla kwesokunxele bese uqhafaza inkinobho yegundane kwesobunxele.
- Ungakhipheli ukhiye we-Shift, skrolela ishidi kuze kube sekupheleni kwetafula, uma lingahambisani nokuphakama esikrinini sokuqapha. Faka isikhombisi esitokisini esingezansi kwesokudla sendawo yethebula bese uchofoza futhi inkinobho yegundane kwesobunxele.
Ngemuva kwalesi senzo, lonke ithebula lizoqokonyiswa. Ngaphezu kwalokho, ukukhethwa kuzokwenzeka kuphela ngaphakathi kwebanga lobubanzi phakathi kwamaseli amabili, ngokusho kwawo esichofoze. Ngakho-ke, noma ngabe kukhona izindawo eziseduze nedatha, ngeke zifakwe kulokhu kukhethwa.
Ukukhetha nakho kungenziwa ngokuhleleka okuguquguqukayo. Okokuqala, iseli elingezansi, bese liphezulu. Kungenzeka ukwenza inqubo kwenye indlela: ukugqamisa amaseli aphezulu angesokudla naphansi nge-Shift Key. Umphumela wokugcina osuka ekuqondeni futhi i-oda lizimele ngokuphelele.
Njengoba sibona, kunezindlela ezintathu eziyisisekelo zokuqokomisa itafula ku-Excel. Esokuqala sithandwa kakhulu, kepha singakhululeki ezindaweni ezinkulu zetafula. Inketho esheshayo ukusebenzisa i-CTRL + inhlanganisela yokhiye. Kepha unobubi obuthile obungakwazi ukuqeda ukusebenzisa inkinobho yokushintsha. Ngokuvamile, ngokuhlukahluka okungavamile, zonke lezi zindlela zingasetshenziswa kunoma yisiphi isimo.