Mukamagwira ntchito ndi ma Spreadsheets a Excel, nthawi zina muyenera kubisa malo ena papepala lothandizira. Nthawi zambiri zimachitika ngati, mwachitsanzo, zimakhala ndi njira. Tiyeni tiwone momwe mungabisire zipilala mu pulogalamuyi.
Bisani Algorithms
Pali njira zingapo zochitira njirayi. Tiyeni tiwone tanthauzo lawo.
Njira 1: kusintha kwa maselo
Njira yodziwika bwino kwambiri yomwe mungakwaniritse zomwe mukufuna ndizosintha kwa khungu. Kuti tichite izi, timadumphadumpha pamalo oyenerana ndi malire komwe kuli malire. Muvi wooneka mbali zonse ziwiri. Dinani kumanzere ndikokera m'malire a mzati umodzi kupita kumalire ena, mpaka izi zitha kuchitika.
Pambuyo pake, chinthu chimodzi chidzabisika kumbuyo kwina.
Njira 2: gwiritsani ntchito menyu
Ndikosavuta kugwiritsa ntchito menyu wazonse pazolinga izi. Poyamba, ndizosavuta kuposa malire osuntha, chachiwiri, mwanjira iyi, ndikotheka kukwaniritsa kubisala kwathunthu maselo, mosiyana ndi mtundu wapakale.
- Timadina pomwe kumadongosolo oyanjana ndi chilembo cha Chilatini, chomwe chikuwonetsa kuti mzerewo ukhale wobisika.
- Pazosankha zomwe zikuwoneka, dinani batani Bisani.
Pambuyo pake, mzere womwe ukunenedwayo udzakhala wobisika kwathunthu. Kuti mutsimikizire izi, onani momwe zipilala zalembedwera. Monga mukuwonera, kalata imodzi ikusowa motsatira ndondomeko.
Ubwino wa njirayi pamwambapa umagona poti momwemo mutha kubisala mzati zingapo motsatana nthawi imodzi. Kuti muchite izi, sankhani, ndipo menyu mukatundu, dinani chinthucho Bisani. Ngati mukufuna kuchita njirayi ndi zinthu zomwe sizili pafupi ndi mzake, koma zomwazikana paliponse, ndiye kuti kusankhaku kuyenera kuchitika ndi batani lomwe likakanikizidwa Ctrl pa kiyibodi.
Njira 3: gwiritsani ntchito zida za tepi
Kuphatikiza apo, mutha kuchita njirayi pogwiritsa ntchito mabatani amtundu wakutchinga "Maselo".
- Sankhani ma cell omwe ali m'mizati yomwe mukufuna kubisala. Kukhala mu tabu "Pofikira" dinani batani "Fomu", yomwe imayikidwa pa tepi mu chipangizo chothandizira "Maselo". Pazosankha zomwe zimawonekera mumagulu azokonda "Kuwoneka" dinani pachinthucho Bisani kapena onetsani. Mndandanda wina umayatsidwa, momwe muyenera kusankha chinthucho Bisani Zambiri.
- Zitatha izi, zipilala zibisika.
Monga momwe zinalili kale, mwanjira imeneyi mutha kubisala zinthu zingapo nthawi imodzi, kuziwonetsa, monga tafotokozera pamwambapa.
Phunziro: Momwe mungawonetse mzati wobisika mu Excel
Monga mukuwonera, pali njira zingapo zobisira mzati mu Excel. Njira yodziwikiratu ndiyo kusuntha maselo. Koma, tikulimbikitsidwa kuti mungagwiritse ntchito imodzi mwanjira ziwiri zotsatirazi (menyu wankhani kapena batani pa riboni), chifukwa akutsimikizira kuti maselo adzabisidwa kwathunthu. Kuphatikiza apo, zinthu zobisika mwanjira imeneyi zimakhala zosavuta kuziwonetsa ngati pangafunike.
