Mizere yotsirizira ndi zolembedwa zomwe zomwe zimawonetsedwa zikasindikizidwa pamapepala osiyanasiyana malo amodzi. Ndikofunikira kwambiri kugwiritsa ntchito chida ichi polemba mayina a matebulo ndi mitu yawo. Itha kugwiritsidwanso ntchito pazinthu zina. Tiyeni tiwone momwe mungapangire zolemba izi mu Microsoft Excel.
Gwiritsani ntchito mizere yotsirizira
Kuti mupange mzere womwe udawonetsedwa patsamba lililonse la chikalatachi, muyenera kuchita zolemba zina.
- Pitani ku tabu Masanjidwe Tsamba. Pa nthiti yomwe ili m'bokosi la chida Zikhazikiko Tsamba dinani batani Sindikizani Mutu.
- Zenera lotsegulira limatsegulidwa. Pitani ku tabu Mapepalangati zenera linatsegulidwa mu tabu lina. Mu makatani "Sindikizani patsamba lililonse" ikani otemberera m'munda Mizere yotsirizira.
- Ingosankha chingwe chimodzi kapena zingapo papepala zomwe mukufuna kumaliza. Othandizira awo akuyenera kuwonetsedwa m'munda pazenera la parameter. Dinani batani "Zabwino".
Yang'anani! Ngati mukusintha khungu, batani ili silikugwira ntchito. Chifukwa chake, tulukani njira yosinthira. Komanso, singagwire ntchito ngati chosindikizira sichidakhazikitsidwa pa kompyuta.
Tsopano zomwe zalowetsedwa m'malo osankhidwa ziziwonetsedwanso patsamba lina mukasindikiza chikalata, chomwe chingasunge nthawi yochulukirapo poyerekeza ndi momwe mungalembe ndikukhazikitsa (ndikuyika) mbiri yoyenera patsamba lililonse la zinthu zosindikizidwa pamanja.
Kuti muwone momwe chikalatacho chidzawonekera mutatumizidwa ku chosindikizira, pitani ku tabu Fayilo ndi kusunthira ku gawo "Sindikizani". Mu gawo loyenera la zenera, ndikuyang'ana chikalatacho, tikuwona momwe ntchitoyi idamalizidwa bwino, ndiye kuti, kaya zambiri kuchokera kumapeto mpaka kumapeto zikuwonekera patsamba lililonse.
Mofananamo, mutha kukhazikitsa osati mizere, komanso mizati. Kungotengera izi, ogwirizanitsa adzafunika alowetse kumunda Kudzera pazipilara pazenera la masamba.
Izi zotsogola zikugwiranso ntchito pa mitundu ya Microsoft Excel 2007, 2010, 2013 ndi 2016. Njira mwa iwo ndizofanana.
Monga mukuwonera, pulogalamu ya Excel imapereka luso lotha kungolinganiza zomaliza kumapeto kwa buku. Izi zikuthandizani kuti muwonetse maudindo obwerezabwereza pamasamba osiyanasiyana a chikalatacho, kuzilemba kamodzi, zomwe zingapulumutse nthawi ndi kuyesetsa.
