Kwesinye isikhathi kunezimo lapho udinga ukuthinta itafula, okungukuthi, imigqa yokushintshana namakholomu. Vele, ungayibulala ngokuphelele yonke idatha njengoba udinga, kodwa kungathatha isikhathi esikhulu. Akubona bonke abasebenzisi be-Excel abakwaziyo ukuthi le processor yetafula inomsebenzi ozosiza ukusebenza kwale nqubo. Masifunde ngokuningiliziwe ukuthi angenza kanjani amakholomu ku-Excel.
Inqubo yeTranspose
Izinsika eziguqulwayo nemigqa e-Excel ibizwa ngokuthi ukuguqulwa. Kunezindlela ezimbili zokwenza le nqubo: ngokusebenzisa ukufaka okhethekile nokusebenzisa umsebenzi.
Indlela yoku-1: ukufaka ngokwezifiso
Thola ukuthi ungahambisa kanjani itafula ku-Excel. Ukuguqula usebenzisa ukufaka okhethekile kuyindlela elula nethandwa kakhulu yokufaka uhlu lwamalungu etafula phakathi.
- Khetha itafula lonke nesikhombisi segundane. Sichofoza kukho inkinobho efanele. Kumenyu evelayo, khetha Kopisha noma vele uchofoze kwinhlanganisela yekhibhodi I-Ctrl + C.
- Simi ngokufana noma kwelinye ishidi esitokisini esingenalutho, okufanele sibe iseli elingaphezulu kwesobunxele setafula elisha. Sichofoza kukho inkinobho yegundane elifanele. Kumenyu yokuqukethwe, iya entweni "Faka okhethekile ...". Kumenyu eyengeziwe evelayo, khetha into enegama elifanayo.
- Kuvulwa iwindi lezilungiselelo zokufaka ngokwezifiso. Hlola ibhokisi eliseduze nenani "Transpose". Chofoza inkinobho "Kulungile".
Njengoba ubona, ngemuva kwalezi zenzo itafula lasekuqaleni likopishelwe endaweni entsha, kodwa ngamaseli aphendukela phansi.
Ngemuva kwalokho, kuzokwazi ukususa itafula lasekuqaleni ngokulikhetha, chofoza isikhombisi, bese ukhetha into kumenyu evela. "Susa ...". Kepha awukwazi ukukwenza lokhu uma kungakukhathazi eshidi.
Indlela 2: ukusebenzisa umsebenzi
Indlela yesibili yokudlulela ku-Excel ukusebenzisa umsebenzi okhethekile UKUTHENGA.
- Khetha indawo eshidini, elingana nobubanzi bokunqama nokuvundlile kwamaseli etafuleni lokuqala. Chofoza isithonjana "Faka umsebenzi"etholakala kwesobunxele sebha yefomula.
- Iyavula Isici Wizard. Uhlu lwamathuluzi wethuliwe, funa igama I-TRANSP. Uma usutholile, khetha bese uchofoza inkinobho "Kulungile".
- Iwindi lokuphikisana liyavula. Lo msebenzi unempikiswano eyodwa kuphela - Array. Sibeka isikhombisi emkhakheni waso. Ngemuva kwalokhu, khetha itafula lonke esifuna ukulihambisa. Ngemuva kokuthi ikheli lohlu olukhethiwe lurekhodwe endle, chofoza inkinobho "Kulungile".
- Beka isikhombisi ekugcineni komugqa wamafomula. Ekhibhodi sibhala inhlanganisela yezinkinobho I-Ctrl + Shift + Faka. Lesi senzo siyadingeka ukuze idatha iguqulwe ngokufanele, ngoba asisebenzelani neseli elilodwa, kepha ngeqoqo lonke.
- Ngemuva kwalokho, lolu hlelo lwenza inqubo yokufakelwa, okungukuthi, luguqa amakholomu nezintambo etafuleni. Kepha ukudluliswa kwenziwa ngaphandle kokubuka ukufomatha.
- Sifometha itafula ukuze libe nokubukeka okwamukelekayo.
Isici sale ndlela yokuguqulwa, ngokungafani neyedlule, ukuthi idatha yasekuqaleni ayinakususwa, ngoba lokhu kuzosusa ububanzi obudlulisiwe. Ngaphezu kwalokho, noma yiluphi ushintsho kudatha eyinhloko luzoholela ekuguqukeni okufanayo kutafula elisha. Ngakho-ke, le ndlela ihle kakhulu ekusebenzeni namatafula ahlobene. Ngasikhathi sinye, kuyinkimbinkimbi kakhulu kunendlela yokuqala. Ngaphezu kwalokho, lapho usebenzisa le ndlela, kuyadingeka ukonga umthombo, okungeyona ngaso sonke isikhathi isixazululo esifanele.
Sithole ukuthi ungashintsha kanjani amakholomu nezinqa ku-Excel. Kunezindlela ezimbili eziphambili zokuphephisa itafula. Yikuphi okumele uyisebenzise kuncike ekutheni uhlela ukusebenzisa idatha ehlobene noma cha. Uma amacebo anjalo engatholakali, kuyanconywa ukusebenzisa inketho yokuqala ukuxazulula inkinga, njengento elula.
