Nthawi zina pali zochitika pamene muyenera kutembenuza tebulo, ndiko kuti, kusinthana mizere ndi mizere. Inde, mungathe kusokoneza zonse zomwe mukufunikira, koma izi zingatenge nthawi yochuluka. Osati onse ogwiritsira ntchito Excel akudziwa kuti pali ntchito mu purosesa ya spreadsheet yomwe ingathandize kusintha njirayi. Tiyeni tiwone mwatsatanetsatane momwe mizere imapangidwira mu Excel.
Kusintha njira
Kupaka ma columns ndi mizere ku Excel kumatchedwa kusintha. Mukhoza kuchita izi mwa njira ziwiri: kupyolera muikapo wapadera ndikugwiritsa ntchito ntchito.
Njira 1: Kuyika kwapadera
Pezani momwe mungagwirizire tebulo ku Excel. Kutumiza ndi chithandizo cha padera yapadera ndi mtundu wosavuta komanso wotchuka kwambiri wopikisana ndi owerenga.
- Sankhani tebulo lonse ndi mouse phokoso. Dinani pa icho ndi batani lolondola. Mu menyu imene ikuwonekera, sankhani chinthucho "Kopani" kapena ingodinani pa kuphatikiza kwa mabulodi Ctrl + C.
- Timakhala chimodzimodzi kapena pa pepala lina pa selo lopanda kanthu, lomwe liyenera kukhala pamwamba pamzere selo la tebulo latsopano lokopedwa. Dinani pa ilo ndi batani lamanja la mouse. Mu menyu yachidule, dinani pa chinthucho "Kuika Mwapadera ...". Mu menyu ena omwe akuwonekera, sankhani chinthucho ndi dzina lomwelo.
- Zowonongeka zowonjezera zenera zimatsegula. Ikani chizindikiro chotsutsana ndi mtengo "Kutumiza". Timakanikiza batani "Chabwino".
Monga mukuonera, zitatha izi, tebulo lapachiyambi linakopitsidwira ku malo atsopano, koma ndi maselo osokonezedwa.
Ndiye, nkutheka kuti muchotse tebulo lapachiyambi, mukulisankha, mukusindikiza chithunzithunzi, ndikusankha chinthucho mu menu yowonekera "Chotsani ...". Koma simungathe kuchita izi ngati sikukuvutitsani pa pepala.
Njira 2: Gwiritsani ntchito ntchitoyi
Njira yachiwiri yobwerezera ku Excel ikuphatikizapo kugwiritsa ntchito ntchito yapadera TRANSPORT.
- Sankhani malo pa pepala lofanana ndi maselo ofanana ndi osakanikirana mu tebulo lapachiyambi. Dinani pazithunzi "Ikani ntchito"kumanzere kwa bar.
- Kutsegulidwa Mlaliki Wachipangizo. M'ndandanda wa zida zomwe tikuzifuna "TRANSPORT". Mukapezeka, sankhani ndi dinani pa batani "Chabwino".
- Fesholo yotsutsana ikutsegula. Ntchitoyi ili ndi kukangana kokha - "Mzere". Ikani malonda mu munda wake. Pambuyo pa izi, sankhani tebulo lonse limene tikufuna kutsegula. Pambuyo pa adiresi ya mndandanda wosankhidwayo, tawonani pa batani "Chabwino".
- Ikani khutulo pamapeto a bar. Pa khibhodi, yesani njirayo Ctrl + Shift + Lowani. Izi ndizofunikira kuti deta ikhale yosinthidwa bwino, popeza sitili ndi selo imodzi, koma ndi zonse.
- Pambuyo pake, pulogalamuyi imapanga ndondomeko yosinthidwa, ndiko kuti, amasintha mizati ndi mizere pa tebulo. Koma kusintha kumeneku kunapangidwa popanda kupanga.
- Pangani tebulo kuti ikhale yovomerezeka.
Choyimira cha njira iyi yopangidwira, mosiyana ndi chakale, ndikuti deta yapachiyambi silingakhoze kuchotsedwa, chifukwa ichi chichotsa mtundu wotchinga. Komanso, kusintha kulikonse mu deta yoyamba kudzachititsa kusintha komweku mu gome latsopano. Choncho, njirayi ndi yabwino kwambiri yogwira ntchito ndi matebulo ofanana. Pa nthawi yomweyo, ndilovuta kwambiri kuposa njira yoyamba. Kuonjezerapo, mukamagwiritsa ntchito njirayi, muyenera kusunga chitsime, chomwe sichiri njira yabwino yothetsera.
Tinawona momwe tingasinthire zipilala ndi mizere ku Excel. Pali njira ziwiri zowonjezera tebulo. Mmodzi mwa iwo omwe angagwiritse ntchito akudalira ngati mukufuna kupanga deta yolumikizana kapena ayi. Ngati malingaliro amenewa sakupezeka, ndiye kuti ndibwino kuti mugwiritse ntchito njira yoyamba yothetsera vutoli, mosavuta.
