Tsambali la tsamba la Excel ndilo chida chothandizira kwambiri chimene mungathe kuona momwe zinthu zidzakhalire pa tsamba pamene zimasindikizidwa ndi kuzilemba nthawi yomweyo. Kuwonjezera apo, mu njirayi, mukhoza kuona mutu ndi zolemba - mapepala apadera pamasamba apamwamba ndi pansi pamasamba omwe sakuwoneka muzochitika zachikhalidwe. Koma, mofananamo, nthawizonse ntchito muzochitika zotero kwa ogwiritsa ntchito onse ndi ofunikira. Komanso, munthu wogwiritsa ntchito atasintha ntchito yake, adzazindikira kuti ngakhale mizere yomwe ili ndi mapepala omwe amasonyeza malire a tsamba adzakhalabe owonekera.
Chotsani zolemba
Tiyeni tipeze momwe tingatsetse gawo la tsamba lamasamba ndikuchotsani maonekedwe a malire pa pepala.
Njira 1: Thandizani kusindikiza tsamba pa bar
Njira yosavuta yochotsera kachitidwe ka tsamba ndikumasintha kudzera pazithunzi pa barreti yavota.
Mabatani atatu omwe ali ngati mafano kuti asinthe mawonekedwe awonedwe ali kumbali yakumanja ya chikhomo kumbali yakumanzere ya zojambulazo. Kugwiritsa ntchito, mungathe kukhazikitsa njira zotsatirazi:
- wamba;
- tsamba;
- tsamba lamasamba.
Mu njira ziwiri zomaliza, pepala iligawidwa m'magulu. Kuchotsa chigawo ichi, ingoyani pazithunzi. "Zachibadwa". Njira imasinthidwa.
Njirayi ndi yabwino chifukwa ikhoza kugwiritsidwa ntchito pang'onopang'ono, pokhala pa tepi iliyonse ya pulogalamuyi.
Njira 2: Onani tabu
Mukhozanso kusinthanso machitidwe opita ku Excel kupyolera mu mabatani omwe ali pa kabati "Onani".
- Pitani ku tabu "Onani". Pa tepiyi mu chida cha zipangizo "Zojambula Zamabuku" dinani pa batani "Zachibadwa".
- Pambuyo pake, pulogalamuyo idzasinthidwa kuchoka pazimene zimagwira ntchito pazomwe zikupangidwira.
Njira iyi, mosiyana ndi yomwe yapitayo, imaphatikizapo zina zowonjezera zomwe zimagwirizanitsidwa ndi kusinthasintha kwa tabu ina, koma, komabe, ena ogwiritsa ntchito amakonda kusankha.
Njira 3: Chotsani mzere wamdima
Koma, ngakhale mutasintha kuchokera pa tsamba kapena tsamba lamasamba kukhala lachilendo, mzere wokhala ndi timapepala ndi kupasula kwakanthaŵi, kuswa pepala mu zigawo, kudzakhalabebe. Kumbali imodzi, zimathandiza kuyenda ngati zomwe zili mu fayilo zikugwirizana ndi pepala. Komabe, si aliyense amene angakonde pepala ili logawanika, likhoza kumusokoneza. Komanso, sizinthu zonse zomwe zimapangidwa kuti zithe kusindikizidwa, zomwe zikutanthauza kuti ntchitoyi imakhala yopanda phindu.
Nthawi yomweyo tiyenera kukumbukira kuti njira yokhayo yochotsera mizere yochepayi ndiyo kuyambanso mafayilo.
- Musanatseke zenera, musaiwale kusunga zotsatira za kusintha mwa kudindira pa chithunzicho ngati mawonekedwe a diskette kumtunda wakumanzere kumanzere.
- Pambuyo pake, dinani pa chithunzicho ngati mawonekedwe oyera a mzere wofiira m'mphepete mwa kumanja kwawindo, ndiko kuti, dinani pa batani omaliza. Sikofunika kutseka mawindo onse a Excel ngati muli ndi mafayilo angapo omwe akuyenda panthawi imodzimodzi, popeza ndikwanira kukwaniritsa ntchitoyi m'ndandanda umene muli mzere wokhalapo.
- Chipepalacho chidzatsekedwa, ndipo pamene chiyambanso, sipadzakhala mizere yaying'ono yophatikizapo yomwe imaphwanya pepala.
Njira 4: Chotsani Tsambalo Tsamba
Kuphatikiza apo, pepala la Excel likhoza kukhazikitsidwa ndi mizere yaitali. Kulemba uku kumatchedwa kuswa kwa tsamba. Ikhoza kuthandizidwa pokhapokha, kotero kuti ikulepheretseni muyenera kuchita zina mwadongosolo. Mipata yotereyi ikuphatikizapo ngati mukufuna kusindikiza mbali zina za chigawocho mosiyana ndi thupi lathunthu. Koma, zosowa zimenezi sizilipo nthawi zonse, kupatulapo, ntchitoyi ingasinthidwe mosasamala, ndipo mosiyana ndi tsamba losavuta lokha, lokhalo likuwoneka pazenera zowonongeka, mipata iyi idzathetseratu chikalatacho pokhapokha atasindikizidwa, omwe nthawi zambiri sichivomerezeka . Ndiye izo zimakhala zofunikira kuti zilepheretse mbali iyi.
- Pitani ku tabu "Kuyika". Pa tepiyi mu chida cha zipangizo "Makhalidwe a Tsamba" dinani pa batani "Kuswa". Menyu yotsitsa imatsegulidwa. Pitani kupyolera mu chinthucho "Bwezeretsani kuswa kwa tsamba". Ngati inu mutsegula pa chinthu "Chotsani kuswa kwa tsamba", chinthu chimodzi chokhacho chidzachotsedwa, ndipo ena onse adzakhala pa pepala.
- Pambuyo pake, mipata mwa mawonekedwe a mizere yayitali idzachotsedwa. Koma padzakhala mizere yochepa yolemba mizere. Iwo, ngati mukuwona kuti ndi kofunika, akhoza kuchotsedwa, monga momwe tafotokozera mu njira yapitayi.
Monga momwe mukuonera, kulepheretsa kachitidwe ka tsamba ndi kosavuta. Kuti muchite izi, muyenera kungosintha pogwiritsa ntchito batani yoyenera mu mawonekedwe a pulojekiti. Kuti muchotseko kamtengo kakang'ono, ngati kakulepheretsa munthu wogwiritsa ntchito, muyenera kuyamba pulogalamuyi. Kuchotsa mapepala mumzere wa mizere ndi mzere wautali wotha kungathe kuchitidwa kupyolera mu batani pa tepi. Choncho, pali njira yamakono yochotsera zosiyana siyana zomwe zilipo.
