Pamene mukugwira ntchito ku Excel ndi deta yaitali kwambiri yokhala ndi mizere yambiri, ndizosasangalatsa kukwera pamutu nthawi zonse kuti muone zomwe zimayendera pa maselo. Koma, mu Excel pali mwayi wokonza mzere wapamwamba. Pankhaniyi, ziribe kanthu kutalika kwake komwe mukupukuta deta pansi, mzere wapamwamba udzakhalabe pawindo. Tiyeni tione m'mene tingasinthire mzere wa pamwamba mu Microsoft Excel.
Lembani mzere wapamwamba
Ngakhale, tidzakambirana momwe tingakonzere ndondomeko ya deta pogwiritsa ntchito chitsanzo cha Microsoft Excel 2010, koma dongosolo lofotokozedwa ndi ife ndiloyenera kuchita izi mwazinthu zamakono zamakono.
Kuti mukonze mzere wapamwamba, pitani ku "Onani" tabu. Pa kachipangizo kamene kali mu "Window" chogwiritsira ntchito, dinani pa "Masewera otetezeka". Kuchokera pa menyu yomwe ikuwonekera, sankhani malo "Konzani mzere wapamwamba."
Pambuyo pake, ngakhale mutasankha kupita kumunsi kwa deta ndi mizere yambiri, mzere wapamwamba ndi dzina la deta lidzakhala patsogolo pa maso anu.
Koma, ngati mutu uli ndi mzere woposa umodzi, ndiye, mu njira iyi, njira yowongoka pamwambayi siigwira ntchito. Tidzachita opaleshoni pogwiritsa ntchito batani la "Fasten", yomwe idakambidwa kale pamwamba, koma nthawi yomweyo, osasankha chotsatira "Fasten mzere" m'malo mwake, koma "Malo a Fasten", atasankha selo lamanzere pansi pa malo amodzi.
Sakanizani mzere wapamwamba
Kupititsa patsogolo mzere ndikumphweka. Kachiwiri, dinani pa batani "Malo Otsatira", ndi mndandanda womwe ukuwonekera, sankhani malo "Chotsani madera osakanikirana".
Pambuyo pa izi, mzere wapamwamba udzasungidwa, ndipo deta ya deta idzatenga mawonekedwe omwe akuzolowezi.
Kukonzekera kapena kutsegula mzere wa pamwamba mu Microsoft Excel ndi kosavuta. Chovuta kwambiri kukonzekera mutu wa deta, wopangidwa ndi mizere ingapo, komanso siyimilira vuto lapadera.