Ungayifaka kanjani itafula ekudingisweni

Kwesinye isikhathi kunezimo lapho kudingeka ukuguqula itafula, okungukuthi, shintsha imigqa namakholomu ezindaweni. Vele, ungambulala ngokuphelele yonke imininingwane njengoba udinga, kepha ingathatha isikhathi esiningi. Akubona bonke abasebenzisi be-Excel abaziyo ukuthi le processor yethebula inomsebenzi ozosiza ekusebenzeleni le nqubo. Ake sifunde ngokuningiliziwe ukuthi imigqa yenza kanjani amakholomu e-Excel.

Inqubo eguqukayo

Izinguquko ezindaweni zamakholomu nemigqa ku-Pentando ibizwa nge-transposition. Ungenza le nqubo ngezindlela ezimbili: Ngokufaka okukhethekile nokusebenzisa umsebenzi.

Indlela 1: Ukufakwa okukhethekile

Thola ukuthi ungayikhipha kanjani itafula ku-Excel. Ukuguqulwa kusetshenziswa ukufaka okukhethekile kuyinto elula futhi ethandwa kakhulu yohlobo lokuhlanza lwethebula kubasebenzisi.

1. Sigqamisa lonke itafula nesikhombisi segundane. Chofoza kuyo chofoza kwesokudla. Kumenyu evelayo, khetha into ethi "Kopisha" noma umane uchofoze kukhibhodi inhlanganisela ye-CTRL + C.



2. Siba ngokufanayo noma kwelinye ishidi esitokisini esingenalutho, okuzodingeka kube yiseli elingakwesobunxele letafula elisanda kukopishwa. Chofoza inkinobho yegundane kwesokudla. Kumenyu yomongo, dlula entweni ethi "Ukufaka Okukhethekile ...". Kumenyu eyengeziwe evela, khetha into enegama elifanayo.



3. Kuvulwa iwindi lokucushwa elikhethekile lokucushwa. Faka ibhokisi lokuhlola elibhekene nenani elithi "Transpose". Chofoza inkinobho ethi "KULUNGILE".

Njengoba ubona, ngemuva kwalezi zenzo, itafula lomthombo lalikopishwa endaweni entsha, kepha vele ngamaseli angenele.

Ngemuva kwalokho, ungasusa itafula lasekuqaleni ngokukhetha ngokuchofoza isikhombisi, nangokukhetha into ethi "Delete ...". Kepha awukwazi ukukwenza lokhu uma kungeke kuphazamise ishidi.

Indlela 2: Umsebenzi wohlelo lokusebenza

Indlela yesibili yokuvula i-Excel ifaka ukusetshenziswa komsebenzi okhethekile we-TRAC.

1. Khetha indawo eshidini elilingana nohlu oluthe mpo nasevundlile lwethebula lomthombo. Chofoza isithonjana esithi "Insert Function" esibekwe ngakwesobunxele sentambo yefomula.



2. I-Wizard iyavula. Uhlu lwamathuluzi angenisiwe lufuna igama elithi "transp". Ngemuva kokutholakele, sabela futhi sicindezele inkinobho ethi "KULUNGILE".



3. Iwindi lokuphikisana livuleka. Lesi sici sinengxabano eyodwa kuphela - "uhlu". Sibeka isikhombisi emkhakheni waso. Ukulandela lokhu, sabela lonke ithebula esifuna ukulukhipha. Ngemuva kwekheli lebanga elizinikezele liqoshwe enkundleni, chofoza inkinobho ethi "Kulungile".



4. Sibeka isikhombisi ekugcineni kwentambo yefomula. Kwikhibhodi, uthayipha inhlanganisela yokhiye we-CTRL + Shift + Enter. Lesi senzo siyadingeka ukuze idatha iguqulwe kahle, ngoba asikhokhelwa ngeseli elilodwa, kodwa luhlu lwamanani afanayo.



5. Ngemuva kwalokho, lolu hlelo lwenza inqubo yokuguqulela, okungukuthi, lushintsha amakholomu nemigqa ezindaweni ezisetafuleni. Kepha ukudluliswa kwenziwa ngaphandle kokufometha.



6. Sifometha itafula ukuze libe nombono owamukelekayo.

Isici sale ndlela ye-Transfer, ngokungafani neyedlule, ukuthi idatha yokuqala ayikwazi ukususwa, ngoba lokhu kuzosusa uhla oludluliselwe. Ngaphezu kwalokho, noma iziphi izinguquko kwidatha eyinhloko kuzoholela ekushintsheni okufanayo etafuleni labo elisha. Ngakho-ke, le ndlela ilungele ikakhulukazi ukusebenza ngamatafula ahlobene. Ngasikhathi sinye, kunzima kakhulu ekukhetheni kokuqala. Ngaphezu kwalokho, lapho usebenzisa le ndlela, kuyadingeka ukugcina umthombo, okungeyona ngaso sonke isikhathi ikhambi elifanele.

Sithole ukuthi singashintshana kanjani amakholomu nezintambo ku-Excel. Kunezindlela ezimbili eziphambili zokuguqula itafula. Kusho ukuthini ngabo ukuthi uhlela ukusebenzisa idatha ehlobene noma cha. Uma kungekho zinhlelo ezinjalo, kunconywa ukusebenzisa inguqulo yokuqala yokuxazulula umsebenzi njengoba elula.