Ukuguqula itafula ku-Excel

Impela wonke umsebenzisi osebenza ku-Excel uhlangabezane nesimo lapho imigqa namakholomu ethebula kudingeka kushintshwe. Uma sikhuluma ngenani elincane ledatha, khona-ke inqubo ingenziwa ngesandla, futhi kwezinye izimo, lapho kunolwazi oluningi, amathuluzi akhethekile azoba usizo kakhulu noma abaluleke kakhulu, ongaguqula ngawo itafula ngokuzenzakalelayo. . Ake sibone ukuthi kwenziwa kanjani.

Ukuguqulwa kwethebula

Ukuguqulwa - lokhu "ukudluliselwa" kwemigqa namakholomu ethebula ezindaweni. Lo msebenzi ungenziwa ngezindlela ezahlukene.

Indlela yesi-1: Sebenzisa Namathisela Okukhethekile

Le ndlela isetshenziswa kaningi, futhi nakhu ehlanganisa:

1. Khetha ithebula nganoma iyiphi indlela elula (ngokwesibonelo, ngokubamba phansi inkinobho yegundane kwesokunxele ukusuka kuseli elingaphezulu kwesokunxele kuye kwesokudla ngezansi).
2. Manje chofoza kwesokudla endaweni ekhethiwe bese ukhetha umyalo kumenyu yokuqukethwe evulayo. "Kopisha" (noma esikhundleni salokho mane ucindezele inhlanganisela Ctrl + C).
3. Ngakolunye uhlangothi noma kwelinye ishidi, sima esitokisini, esizoba iseli elingaphezulu kwesokunxele setafula eliguquliwe. Sichofoza kwesokudla kuso, futhi kulokhu sidinga umyalo kumenyu yokuqukethwe "Ukunamathisela Okukhethekile".
4. Ewindini elivulayo, khetha ibhokisi eliseduze kokuthi "I-Transpose" bese uchofoza OK.
5. Njengoba sibona, itafula elihlanekezelwe ngokuzenzakalelayo livele endaweni ekhethiwe, lapho amakholomu ethebula lokuqala aba imigqa futhi ngokuphambene nalokho. Manje sesingaqala ukwenza ngendlela oyifisayo ukubukeka kwedatha ngendlela esiyithandayo. Uma ithebula langempela lingasadingeki, lingasuswa.

Indlela yesi-2: Sebenzisa umsebenzi othi “TRANSPOSE”

Ukuze uphenye itafula ku-Excel, ungasebenzisa umsebenzi okhethekile "TRANSP".

1. Eshidini, khetha ububanzi bamaseli aqukethe imigqa eminingi njengoba kunamakholomu kuthebula lokuqala, futhi ngokufanelekile, kuyasebenza okufanayo kumakholomu. Bese ucindezela inkinobho "Faka umsebenzi" kwesokunxele sebha yefomula.
2. Ekuvuleni Umsebenzi Wizard khetha isigaba “Uhlu oluphelele lwama-alfabhethi”, sithola u-opharetha "TRANSP", yimaka bese uchofoza OK.
3. Iwindi lezimpikiswano zomsebenzi lizovela esikrinini, lapho udinga ukucacisa izixhumanisi zetafula, ngesisekelo lapho ukuguqulwa kuzokwenziwa khona. Ungakwenza lokhu ngesandla (ukufaka ikhibhodi) noma ngokukhetha uhla lwamaseli eshidini. Uma yonke into isilungile, chofoza OK.
4. Lo mphumela siwuthola eshidini, kodwa akugcini lapho.
5. Manje, ukuze kuvele ithebula eliguquliwe esikhundleni sephutha, chofoza ibha yefomula ukuze uqale ukuhlela okuqukethwe kwayo, ubeke ikhesa ekugcineni, bese ucindezela inhlanganisela yokhiye. Ctrl + Shift + Faka.
6. Ngakho, sikwazile ukudlulisa ngempumelelo ithebula lokuqala. Kubha yefomula, siyabona ukuthi isisho manje sifakwe izinhlaka ezisontekile.Qaphela: Ngokungafani nendlela yokuqala, ukufometha okuyinhloko akuzange kulondolozwe lapha, okuthi kwezinye izimo kube kuhle nakakhulu, njengoba singakwazi ukusetha yonke into kusukela ekuqaleni ngendlela esiyifunayo. Futhi, lapha asinalo ithuba lokususa ithebula lokuqala, ngoba umsebenzi "udonsa" idatha kuwo. Kodwa inzuzo engangabazeki ukuthi amatafula axhunyiwe, okungukuthi noma yiziphi izinguquko kudatha yangempela zizobonakala ngokushesha kulawo ashintshiwe.

Isiphetho

Ngakho, kunezindlela ezimbili ongazisebenzisa ukuze uguqule itafula ku-Excel. Zombili zilula ukuzisebenzisa, futhi ukukhethwa kwenketho eyodwa noma enye kuncike ezinhlelweni ezengeziwe zokusebenza nedatha yokuqala neyamukelwe.