Kupyolera mu mizere ndi zolemba zomwe zomwe zili mkati zimasindikizidwa pakusindikiza chikalata pamasamba osiyanasiyana pamalo omwewo. Ndikoyenera makamaka kugwiritsa ntchito chida ichi podzaza mayina a matebulo ndi makapu awo. Ikhoza kugwiritsidwanso ntchito pazinthu zina. Tiyeni tione m'mene tingakhalire zolemba zotere ku Microsoft Excel.
Pogwiritsa ntchito mizere yopita
Kuti mupange mzere womwe udzawonetsedwe pamasamba onse a chikalata, muyenera kuchita zinazake.
- Pitani ku tabu "Tsamba la Tsamba". Pa tepiyi mu chida cha zipangizo "Makhalidwe a Tsamba" dinani pa batani "Tsamba mutu".
- Fayilo lazitali likuyamba. Dinani tabu "Mapepala"ngati zenera latsegula mu tabu ina. Mu bokosi lokhalamo "Sinthani patsamba lililonse" ikani malonda mmunda "Kupyolera mumzere".
- Ingosankha mzere umodzi kapena zingapo pa pepala yomwe mukufuna kuigwiritsa ntchito. Zogwirizanitsa zawo ziyenera kuwonetsedwa m'munda pawindo la magawo. Dinani batani "Chabwino".
Chenjerani! Ngati panopa mukukonza selo, batani ili silikugwira ntchito. Choncho, tulukani kusinthika. Ndiponso, sizingakhale zogwira ntchito ngati wosindikiza sakuikidwa pa kompyuta.
Tsopano, deta yomwe inalowa m'deralo yosankhidwa idzawonetsedwa pamasamba ena mukasindikiza chikalata, chomwe chimapulumutsa nthawi poyerekeza ndi momwe mungalembere ndikuyika malo (zolemba) zofunikira pa pepala lililonse lazinthu pamanja.
Kuti muwone m'mene vesili liwonekera pamene mutumiza kwa osindikiza, pitani ku tabu "Foni" ndi kusamukira ku gawoli "Sakani". Kumalo oyenera awindo, kupyolera pansi pa pepalali, timayang'ana momwe ntchitoyo yatsirizidwira bwino, ndiko kuti, kaya mauthenga ochokera m'mitsinje yopondaponda amawonetsedwa pamasamba onse.
Mofananamo, simungathe kukhazikitsa mizere yokha, komanso mazenera. Pachifukwa ichi, makonzedwewa adzafunika kulowa mmunda "Kupyolera muzamu" muzenera zamasamba pa tsamba.
Izi zowonjezera zomwe zikuchitika zimagwiritsidwa ntchito kumasulira a Microsoft Excel 2007, 2010, 2013 ndi 2016. Njirayi ndi yofanana.
Monga momwe mukuonera, pulogalamu ya Excel imapereka mphamvu yokonzekera kudzera mzere m'buku. Izi zidzalola kuwonetsera maina olembedwa pamabuku osiyana a chilembo, kuzilemba kamodzi kokha, zomwe zimapulumutsa nthawi ndi khama.