Ngezinye izikhathi kunezimo lapho kudingeka ukuguqula itafula, okusho ukuthi, shintsha imigqa namakholomu. Yiqiniso, ungakwazi ukuphazamisa ngokuphelele yonke idatha njengoba udinga, kodwa lokhu kungathatha isikhathi esiningi. Akubona bonke abasebenzisi be-Excel abaqaphela ukuthi kunomsebenzi kule prosesa ye-tabular ezosiza ukuzenzakalela le nqubo. Ake sibheke ngokuningiliziwe ukuthi amakholomu enza kanjani amakholomu ku-Excel.
Inkambiso yokuguqula
Ukususa amakholomu nemigqa ku-Excel kubizwa ngokuthi ukuguqulwa. Ungenza le nqubo ngezindlela ezimbili: ngokusebenzisa ukufaka okukhethekile nokusebenzisa umsebenzi.
Indlela 1: Ukufaka okukhethekile
Thola ukuthi ungadlulisela kanjani ithebula ku-Excel. Ukudlulisa ngosizo lwe-insert ekhethekile kuyindlela elula kakhulu futhi ethandwa kakhulu yokukhishwa kwe-tabular phakathi kwabasebenzisi.
- Khetha ithebula lonke ne-cursor yegundane. Chofoza kuso nge inkinobho efanele. Emenyu evelayo, khetha into "Kopisha" noma uchofoze nje inhlanganisela yekhibhodi Ctrl + C.
- Sifika okufanayo noma kwenye ishidi kuseli elingenalutho, okufanele libe iseli eliphezulu ngakwesokunxele kwetafula elisha elikopishiwe. Chofoza kuso nge inkinobho yegundane kwesokudla. Emenyu yomongo, chofoza entweni "Faka okukhethekile ...". Emenyu eyengeziwe evelayo, khetha into enegama elifanayo.
- Ifasitela yezilungiselelo zokufaka ngezifiso zivulwa. Setha uphawu ngokumelene nenani "Ukuthutha". Sicindezela inkinobho "Kulungile".
Njengoba ubona, ngemuva kwalezi zenzo, ithebula langempela likopishwe endaweni entsha, kodwa ngamaseli aguquliwe.
Khona-ke, kuyokwazi ukususa ithebula langempela, ukulikhetha, ukuchofoza isikhombisi, nokukhetha into kwimenyu evele ibonakala "Susa ...". Kodwa awukwazi ukwenza lokhu uma kungakukhathazi kushidi.
Indlela 2: sebenzisa umsebenzi
Indlela yesibili yokubuyela ku-Excel ihilela ukusetshenziswa komsebenzi okhethekile IZITHUTHUKO.
- Khetha indawo eshadini elilingana nobubanzi obuqondile nobubanzi bamaseli etafuleni lomthombo. Chofoza kusithonjana "Faka umsebenzi"ngakwesokunxele kwebha yefomula.
- Ivula Umsebenzi weWebhu. Kuhlu lwamathuluzi athunyelwe esibuka igama. "IZITHUTHUKO". Uma usutholiwe, khetha bese uchofoza inkinobho "Kulungile".
- Iwindi lempikiswano ivuleka. Lo msebenzi unengxabano eyodwa kuphela - "Uhlu". Faka i-cursor ensimini yayo. Ngemva kwalokhu, khetha yonke ithebula esiyifunayo. Ngemuva kwekheli lebanga elikhethiwe lirekhodiwe ensimini, chofoza inkinobho "Kulungile".
- Beka isikhombisi ekugcineni kwebha yefomula. Khibhodi, thayipha isinqamuleli Ctrl + Shift + Faka. Lesi senzo siyadingeka ukuze idatha iguqulwe kahle, ngoba asihambisani neseli elilodwa, kodwa ngehlu lonke.
- Ngemuva kwalokho, loluhlelo lwenza inqubo yokuguqula, okungukuthi, iguqula amakholomu nemigqa etafuleni. Kodwa ukudluliswa kwenziwa ngaphandle kokufometha.
- Fometha itafula ukuze ibe nokubonakala okwamukelekayo.
Isici sale ndlela yokuguqula, ngokungafani neyaphambilini, ukuthi idatha yangempela ayikwazi ukususwa, njengoba lokhu kuzosusa ibanga elidlulisiwe. Ngaphezu kwalokho, noma yikuphi ushintsho kumininingwane eyinhloko kuzoholela ekuguqulweni okufanayo kuthebula elisha. Ngakho-ke, le ndlela inhle kakhulu ukusebenza namatafula ahlobene. Ngesikhathi esifanayo, kunzima kakhulu kunokhetho lokuqala. Ngaphezu kwalokho, uma usebenzisa le ndlela, kufanele ulondoloze umthombo, okungeyona isisombululo esihle ngaso sonke isikhathi.
Sithole ukuthi singashintsha kanjani amakholomu nemigqa ku-Excel. Kunezindlela ezimbili eziyinhloko zokufakela itafula. Yikuphi kubo okuzoyisebenzisa kuncike ekutheni uhlela ukusebenzisa idatha ehlobene noma cha. Uma izinhlelo ezinjalo zingekho, ngakho-ke kunconywa ukuthi usebenzise isisombululo sokuqala kule nkinga, njengoba kulula.
