Nthawi zina, pamene mukugwira ntchito ndi Excel, kulembedwa pa pepala lililonse la bukhu limayamba kuonekera. "Tsamba 1", "Tsamba 2" ndi zina zotero Wophunzira wosadziwa nthawi zambiri amadabwa choti achite ndi momwe angachotsere. Ndipotu, funsoli limathetsedwa mosavuta. Tiyeni tione momwe tingachotsere zolembedwerazo kuchokera ku chilembacho.
Khutsani mawonedwe owonetsera mawerengedwe
Zomwe zili ndi tsamba lowonetsera kusindikiza likuchitika pamene wogwiritsa ntchito mwakufuna kapena mwadzidzidzi anasunthira kuchoka kuntchito yogwiritsidwa ntchito kapena njira yoponderezera ku tsamba loyang'ana tsamba. Choncho, kuti mulephere kuwerengera zithunzi, muyenera kusinthana ndi mtundu wina. Izi zikhoza kuchitika m'njira ziwiri, zomwe zidzakambidwe pansipa.
Nthawi yomweyo tiyenera kukumbukira kuti kulepheretsa kusindikiza kwa tsamba kukhazikitsa ndi nthawi yomweyo kukhala pa tsamba mode sikugwira ntchito. Ndiyeneranso kunena kuti ngati wogwiritsa ntchito ayamba kusindikiza mapepala, ndiye kuti zosindikizidwa sizikhala ndi zizindikiro izi, chifukwa zimangowoneka kuchokera pazenera.
Njira 1: Makhalidwe Abwino
Njira yosavuta yosinthitsa mawonedwe owonetsera a pepala la Excel ndi kugwiritsa ntchito zizindikiro zomwe zili pa barreti yoyenera pansi pazenera.
Chithunzi chojambula pa tsamba ndilo loyamba pa zitatu kusintha maimidwe kumanja. Kuti muwonetse mawonedwe owonetsera maulendo a tsamba, dinani pazithunzi ziwiri zotsalira: "Zachibadwa" kapena "Tsamba la Tsamba". Pa ntchito zambiri, ndizosavuta kugwira ntchito yoyamba.
Pambuyo pawotchiyo, kuwerengera manambala pambuyo kwa pepalayo kunatheratu.
Njira 2: batani pa ndodo
Kulepheretsa kuwonetseratu malemba akudutsanso kungagwiritsidwe ntchito pogwiritsa ntchito batani kuti musinthe mawonekedwe pa tepi.
- Pitani ku tabu "Onani".
- Pa tepi ife tikuyang'ana chidutswa cha zipangizo. "Zojambula Zamabuku". Pezani izi zidzakhala zophweka, monga zili pamzere kumanzere kwa tepi. Dinani pa chimodzi mwa mabatani omwe ali mu gulu ili - "Zachibadwa" kapena "Tsamba la Tsamba".
Pambuyo pazimenezi, tsamba loyang'ana tsamba lidzakhumudwa, zomwe zikutanthauza kuti kulembera kumbuyo kudzatha.
Monga mukuonera, ndi zophweka kuchotsa malemba a m'mbuyo ndi tsamba lolemba ku Excel. Zokwanira kusintha malingaliro okha, zomwe zingatheke m'njira ziwiri. Pa nthawi yomweyi, ngati wina ayesa kupeza njira yothetsera malemba awa, koma akufuna kukhala pa tsamba, ndiye kuti ziyenera kunena kuti kufufuza kwake kudzakhala kopanda phindu, popeza kuti palibe njirayi. Koma, musanatseke mawuwo, wogwiritsa ntchito ayenera kuganiza mozama, ndipo ngati amalepheretsa kwambiri kuchita zimenezi kapena angathe kuthandizira kupyolera mukulemba. Makamaka pamene zolemba zam'mbuyo sizidzawonekera pamasindikizidwe.
