Nthawi zina pamakhala zochitika pakafunika kutembenuza tebulo, ndiko kuti, sinthani mizere ndi mizamu m'malo. Zachidziwikire, mutha kupha zonse zomwe mukusowa, koma zimatha kutenga nthawi yayitali. Sikuti ogwiritsa ntchito onse akudziwa kuti pulosesayi imagwira ntchito yomwe ingathandize kusintha njirayi. Tiyeni tiwerenge mwatsatanetsatane momwe miviyo imapangira zikuluzikulu.
Njira yotumiza
Zosintha m'malo mwa mizere ndi mizere yodziwika bwino imatchedwa Indust. Mutha kuchita njirayi munjira ziwiri: kudzera mu gawo lapadera ndikugwiritsa ntchito ntchitoyo.Njira 1: Ikani Kwapadera
Dziwani momwe mungasinthire tebulo pa Excel. Kutumiza pogwiritsa ntchito gawo lapadera ndi mtundu wosavuta komanso wotchuka kwambiri wa tebulo la ogwiritsa ntchito.
- Timatsindika tebulo lonse ndi cholozera mbewa. Dinani panja-dinani. Mumenyu yomwe imawoneka, sankhani "Copy" kapena ingodinani pa kiyibodi kuphatikiza Ctrl + C.
- Timakhala chimodzimodzi kapena pa pepala linalo pachipinda chopanda kanthu, chomwe chidzayenera kukhala khungu lakumanzere kwa tebulo lomwe latayidwa kumene. Dinani pa batani la mbewa. Muzosankha zomwe zalembedwa, pitani pa "yapadera ..." chinthu. Mumenyu yowonjezera yomwe imawoneka, sankhani chinthucho ndi dzina lomweli.
- Windo lapadera losinthitsa. Ikani batani loyang'anitsitsa "TransPose". Dinani pa batani la "OK".
Monga mukuwonera, zitatha izi, tebulo lopanga lidakopera kukhala malo atsopano, koma maselo osokonezeka.
Kenako, mutha kuchotsa tebulo loyambirira posankha izi podina chotemberero, komanso posankha "Chotsani ..." chinthu. Koma simungathe kuchita izi ngati sizingasokoneze pepalalo.
Njira 2: Ntchito Ntchito
Njira yachiwiri yotembenukira ku Excel imaphatikizapo kugwiritsa ntchito ntchito yapadera ya trac.
- Sankhani malowo papepala lofanana ndi mitundu yopingasa ndi yopingasa ya prosege. Dinani pa "ikani ntchito" icon yoyikidwa kumanzere kwa chingwe.
- Wizard akutsegula. Mndandanda wa zida zoperekedwa ndikuyang'ana dzina "Transp". Pambuyo papeza, timagawa ndikudina batani la "OK".
- Khomo lachikangano limatseguka. Izi zili ndi mkangano umodzi chabe - "gulu". Tidamutcha cholozera m'munda wake. Pambuyo pa izi, timagawa tebulo lonse lomwe tikufuna kutchula. Pambuyo pa adilesi yodzipatulira yalembedwa m'munda, dinani pa batani la "OK".
- Timayika cholembera kumapeto kwa chingwe. Pa kiyibodi, mumalemba CTRL + Shift + kulowa. Izi ndizofunikira kuti izi zisasinthidwe molondola, popeza sitikuchita ndi khungu limodzi, koma ndi ziwerengero.
- Pambuyo pake, pulogalamuyi imachita izi, ndiye kuti, amasintha mizati ndi mizere m'malo mwa tebulo. Koma kusamutsa kunapangidwa popanda kutsukidwa.
- Timapanga tebulo kuti likhale lovomerezeka.
Cholinga cha njira iyi yosinthira, mosiyana ndi zomwe zidachitika kale, ndikuti deta yoyamba ingathe kuchotsedwa, chifukwa izi zimachotsa mtundu womwe wasinthidwa. Kuphatikiza apo, kusintha kulikonse pamalingaliro oyambira kumabweretsa kusintha komweko mu tebulo lawo latsopano. Chifukwa chake, njirayi ndiyofunika kugwira ntchito ndi matebulo ophatikizidwa. Nthawi yomweyo, ndizovuta kwambiri kusankha koyamba. Kuphatikiza apo, mukamagwiritsa ntchito njirayi, ndikofunikira kuti muzisamalira bwino, zomwe sizikhala yankho labwino nthawi zonse.
Tidazindikira momwe mungasinthire ku mizamu ndi zingwe zabwino. Pali njira ziwiri zazikulu zosinthira tebulo. Nanga bwanji za iwo zimatengera ngati mukufuna kugwiritsa ntchito deta yokhudzana kapena ayi. Ngati palibe mapulani amenewo, tikulimbikitsidwa kugwiritsa ntchito mtundu woyamba wothetsa ntchitoyo ngati yosavuta.