Nthawi zina mukamagwira ntchito ndi Excel, papepala lililonse, cholembedwa "Tsamba 1", "Tsamba 2" etc. Wogwiritsa ntchito wosadziwa zambiri amakonda kufunsa zoyenera kuchita ndi momwe angazime. M'malo mwake, nkhaniyo imathetsedwa mosavuta. Tiyeni tiwone momwe tingachotsere zolembedwazi.
Zimitsani chiwonetsero chazowonera manambala
Zomwe zikuwonekera ndikuwonetsa kukopa kosindikizira kumachitika pamene wogwiritsa ntchito asintha mwadala kapena mosazindikira mwanjira yokhayo yokhazikitsira kapena mawonekedwe akakhala pa tsamba lolemba. Chifukwa chake, kuti musimitse manambala owoneka, muyenera kusinthira ku mtundu wina wowonetsera. Pali njira ziwiri zochitira izi, zomwe tikambirana pansipa.
Zidziwike nthawi yomweyo kuti simungathe kuzimitsa mawonekedwe achikunja ndikukhalabe pamndandanda wamasamba. M'pofunikanso kutchulanso kuti ngati wogwiritsa ntchito ma sheet adasindikiza, ndiye kuti zolembedwazo sizikhala ndi zolemba izi, chifukwa zimangopangidwira kuwonerera pawonekera.
Njira yoyamba: Bar
Njira yosavuta yosinthira mawonekedwe a chikalata cha Excel ndikugwiritsa ntchito zithunzi zomwe zili patsamba loyang'ana kumunsi kwa zenera.
Chizindikiro cha tsamba lamasamba ndichizindikiro choyamba pamitundu itatu kudzanja lamanja. Kuti muzimitsa kuwonekera kwa manambala a masamba, ingodinani zithunzi zilizonse zotsala: "Zachizolowezi" kapena Masanjidwe Tsamba. Kuchita ntchito zambiri, ndikosavuta kugwira ntchito yoyamba.
Kusinthaku kukapangidwa, ziwerengero zotsatizana kumbuyo kwa pepala zidasowa.
Njira 2: Chingwe cha Ribbon
Mutha kuyimitsanso kuwonetsedwa kwa zilembo zakumaso pogwiritsa ntchito batani kuti musinthe chiwonetsero chanu pa riboni.
- Pitani ku tabu "Onani".
- Pa tepi tikuyang'ana chida chothandizira Mitundu Yowonera. Zikhala zosavuta kuchipeza, chifukwa chili kumanzere kwenikweni kwa tepi. Timadina chimodzi mwa mabatani omwe ali mgululi - "Zachizolowezi" kapena Masanjidwe Tsamba.
Pambuyo pa izi, mawonekedwe akawonedwe adzatsekeredwa, zomwe zikutanthauza kuti kuwerengera kwam'mbuyo kudzawonekanso.
Monga mukuwonera, kuchotsa zilembo zakumbuyo ndi chikunja ku Excel ndikosavuta. Ingosinthani mawonekedwe, omwe angachitike m'njira ziwiri. Nthawi yomweyo, ngati wina akufuna kupeza njira yolembetsera izi, koma nthawi yomweyo akufuna kukhala mumasamba, ziyenera kunenedwa kuti kusaka kwake sikudzakhala kopanda pake, popeza njira yotereyi palibe. Koma, asanalembetse zolembedwazo, wogwiritsa ntchito amafunika kuganizira zambiri ngati zimamuvutitsa kapena mwina, m'malo mwake, zimathandizira kukhazikitsa chikalatacho. Kuphatikiza apo, zilembo zakumbuyo sizimawonekanso pa kusindikiza.
