Pogwira ntchito ndi kuchuluka kwa chidziwitso papepala ku Microsoft Excel, muyenera kuyang'ananso magawo ena. Koma, ngati alipo ambiri, ndipo dera lawo limadutsa malire a nsalu yotchinga, kusuntha mpukutu wonse ndiwosavomerezeka. Madera otukula Excel adangosamalira zosavuta za ogwiritsa ntchito pobweretsa mwayi wokonza madera mu pulogalamuyi. Tiyeni tiwone momwe kukhina malowo kukhala pepala mu Microsoft Excel.
Malo ozizira
Tiona momwe tingakonzere madera papepala pogwiritsa ntchito Microsoft Excel 2010. Koma, popanda kupambana pang'ono, algorithm yomwe ili pansipa ingagwiritsidwe ntchito ku Excel 2007, 2013, ndi 2016.
Kuti muyambe kukonza malowa, muyenera kupita ku "View" tabu. Kenako, sankhani khungu, lomwe lili pansipa ndi kumanja kwa malo okhazikika. Ndiye kuti, dera lonse lomwe lidzakhale pamwamba komanso kumanzere kwa foniyi ndizokhazikika.
Pambuyo pake, dinani batani la "Freeze libakeng", lomwe lili kumbali ya gulu la zida za "Window". Pamndandanda wotsitsa womwe umawonekeranso, sankhani chinthu "Lock libakeng".
Pambuyo pake, malo omwe ali pamwamba ndi kumanzere kwa selo yosankhidwa adzakhazikika.
Ngati mungasankhe khungu loyamba lamanzere, ndiye kuti maselo onse omwe ali pamwambawo adzakhazikika.
Izi ndizothandiza makamaka muzochitika pomwe mutu wa tebulo umakhala ndi mizere ingapo, chifukwa njira yokhazikitsira mzere wapamwamba sigwira ntchito.
Momwemonso, ngati muyika pini, kusankha khungu lapamwamba kwambiri, ndiye kuti dera lonse kumanzere kwake lidzakonzedwa.
Madera othamangitsa
Kuti mupeze madera okhazikika, simuyenera kusankha maselo. Ndikokwanira kuti dinani batani "Sinthani madera" omwe ali pachifuwa, ndikusankha chinthu "Malo osapinikira".
Pambuyo pake, magulu onse okhazikika omwe ali patsamba lino sadzakhala opanda maziko.
Monga mukuwonera, kachitidwe kakukonzanso ndikutchingira madera ku Microsoft Excel ndikosavuta, ndipo mutha kunena kuti ndikopeka. Chovuta kwambiri ndikupeza pulogalamu yoyenera pulogalamu, momwe zida zothetsera mavutozi zimapezekera. Koma, tafotokoza mwatsatanetsatane njira yofikira ndi kukonza madera mu mkonzi wamasamba ano. Ichi ndi gawo lothandiza kwambiri, chifukwa kugwiritsa ntchito kukonza malo, mutha kuwonjezera phindu la Microsoft Excel, ndikusunga nthawi yanu.
