Mutu ndi mapazi ndi malo omwe ali pamwamba ndi pansi pa pepala la Excel. Ndizolemba zolembedwa ndi deta ina pambali ya wogwiritsa ntchito. Panthawi imodzimodziyo, kulembedwa kudzadutsa, kupyolera pa pepala limodzi, kudzawonetsedwa pamasamba ena a chikalata pamalo omwewo. Koma, nthawi zina ogwiritsa ntchito amakumana ndi vuto pamene sangathe kuletsa kapena kuchotsa kwathunthu mutu ndi phazi. Makamaka izi zimachitika ngati ziphatikizidwa ndi zolakwika. Tiyeni tipeze momwe tingachotsere mutu ndi zikhomo ku Excel.
Njira zochotseratu mutu ndi mapazi
Pali njira zingapo zochotsera mitu ndi maulendo. Iwo akhoza kugawa m'magulu awiri: kubisala mapazi ndi kuchotsa kwathunthu.
Njira 1: Bisani Zolemba
Mukabisala nsanamira ndi zomwe zili mkati mwazolemba zomwe zimakhalabe m'kalembedwe, koma siziwoneka kuchokera pazenera. Nthawizonse n'zotheka kuwamasulira ngati kuli kofunikira.
Pofuna kubisa mutu ndi zikhomo, ndikwanira kusinthitsa Excel kuchoka pa tsamba lokhazikitsa mapepala kumalo ena aliwonse mu barreti yoyenera. Kuti muchite izi, dinani chizindikirochi mu barre ya udindo "Zachibadwa" kapena "Tsamba".
Pambuyo pake, mutu ndi nsanamira zidzabisika.
Njira 2: kuchotsa buku la mutu ndi zolemba
Monga tafotokozera pamwamba, pogwiritsa ntchito njira yapitayi, mutu ndi zidutswa sizichotsedwa, koma zimangobisika. Pochotseratu mutu ndi phazi lonse ndi zolemba zonse ndi zolemba zomwe zilipo, muyenera kuchita mwanjira ina.
- Pitani ku tabu "Ikani".
- Dinani pa batani "Zolemba"yomwe imayikidwa pa tepi mu zida za zipangizo "Malembo".
- Chotsani zolemba zonse pamutu ndi pamapepala pa tsamba lirilonse la chikalata pogwiritsa ntchito batani Chotsani pabokosi.
- Deta yonse ikachotsedwa, chotsani mawonedwe a mutu ndi zidule mu njira yomwe yanenedwa kale mu barre ya udindo.
Tiyenera kukumbukira kuti zolemba zomwe zafotokozedwa moterezi zidzasulidwa kosatha, ndipo sizidzatheka kutsegula mawonedwe awo. Muyenera kubwereranso zojambulazo.
Njira 3: Chotsani pamutu mitu ndi zojambula
Ngati chikalatacho ndi chaching'ono, ndiye kuti njira yofotokozera pamwambayi yochotsera mitu ndi mapazi sizitenga nthawi yochuluka. Koma choyenera kuchita ngati bukhuli liri ndi masamba ambiri, chifukwa panthawiyi, zingatenge nthawi kuti ziyeretsedwe? Pankhaniyi, ndizomveka kugwiritsa ntchito njira yomwe imakulolani kuti muchotse mutu ndi zolemba ndi zomwe zilipo kuchokera pamapepala onse.
- Sankhani masamba omwe mukufuna kuchotsa mitu ndi zigawo. Ndiye, pitani ku tabu "Kuyika".
- Pa tepiyi mu chida cha zipangizo "Makhalidwe a Tsamba" Dinani pa kanema kakang'ono ngati mawonekedwe oblique omwe ali kumbali ya kumanja kwa malowa.
- Mu tsamba lokhazikitsa tsamba lomwe limatsegulira, pita ku tab "Zolemba".
- Mu magawo "Mutu" ndi Zotsatira pembedzani mndandanda wotsika pansi. M'ndandanda, sankhani chinthucho "Ayi". Dinani pa batani "Chabwino".
Monga mukuonera, patapita izi, zolembera zonse m'mapepala a masamba omwe anasankhidwa anamasulidwa. Tsopano, mofanana ndi nthawi yotsiriza, muyenera kuchotsa mawonekedwe a phazi pamsana pazithunzi pazenera.
Tsopano mitu ndi mapepala amachotsedwa kwathunthu, ndiko kuti, sichidzawonetsedwa kokha pazenera, koma adzatulutsanso kuchokera pa fayilo.
Monga momwe mukuonera, ngati mukudziwa zina mwa machitidwe okhudzana ndi pulogalamu ya Excel, kuchotsa mapazi kuchokera ku ntchito yayitali ndi yachizolowezi kungasinthe mwamsanga. Komabe, ngati chikalatacho chili ndi masamba angapo, ndiye kuti mukhoza kugwiritsa ntchito kuchotsa buku. Chinthu chachikulu ndikusankha zomwe mukufuna kuchita: kuchotsani maulendo onse kapena kuchotsa kanthawi kochepa.
