Zolemba ndi zoyambira ndi minda yomwe ili pamwamba ndi pansi pa pepala lapa Excel. Amalemba zolemba ndi zina mwa malingaliro a wogwiritsa ntchito. Nthawi yomweyo, zolembedwazo zitha kudutsidwa, ndiye kuti, zikajambulidwa patsamba limodzi, zidzawonetsedwa patsamba lina la chikalatacho pamalo omwewo. Koma, nthawi zina ogwiritsa ntchito amakumana ndi vuto pomwe sangathe kuzimitsa kapena kuchotseratu timitu totsala komanso oyambitsa. Izi zimachitika nthawi zambiri ngati anaphatikizidwa molakwika. Tiyeni tiwone momwe mungachotsere ma footer ku Excel.
Njira zochotsera kumapeto
Pali njira zingapo zochotsera kumapeto. Zitha kugawidwa m'magulu awiri: obisala obisalapo ndi kuchotsedwa kwathunthu.
Njira yoyamba: kubisa oyenda pansi
Pobisala, otsatsa ndi zomwe zili mu mawonekedwe a zolemba zimangokhala mu chikalatacho, koma sizowoneka kuchokera paziwonetsero. Nthawi zonse pamakhala mwayi wowatsegulira ngati pakufunika.
Kuti mubise anthu opita kumapazi, ndikokwanira kuti mulamu wasinthika kuti musinthane ndi Excel kuti isagwiritse ntchito masanjidwewo patsamba lililonse. Kuti muchite izi, dinani chizindikirocho mu bar "Zachizolowezi" kapena "Tsamba".
Pambuyo pake, otsata adzabisika.
Njira 2: kufufuta pamanja
Monga tafotokozera pamwambapa, mukamagwiritsa ntchito njira yam'mbuyomu, omwe amapita kumapazi samachotsedwa, koma chinsinsi chokha. Kuti muchotse kwathunthu mahedilesi ndi opita kumapeto ndi zolemba zonse zomwe zalembedwa pamenepo, muyenera kuchita mwanjira ina.
- Pitani ku tabu Ikani.
- Dinani batani "Omvera ndi oyendayenda", yomwe imayikidwa pa tepi mu chipangizo chothandizira "Zolemba".
- Chotsani zolemba zonse kumapeto patsamba lililonse la chikalata pogwiritsa ntchito batani Chotsani pa kiyibodi.
- Pambuyo pochotsa deta yonse, muzimitsa kuwonetsera kwa omvera komanso oyenda m'munsi momwe mulili kale.
Tiyenera kudziwa kuti zolemba zotsalazo motere ndi zoyambira zimachotsedwa kosatha, ndipo kungoyang'ana sizigwira ntchito. Muyenera kujambulanso.
Njira 3: amangozimitsa ochotsera
Ngati chikalatacho ndi chaching'ono, ndiye kuti njira yomwe ili pamwambayi yochotsa ma mutu ndi ma footer sichitenga nthawi yayitali. Koma chochita ngati bukulo lili ndi masamba ambiri, chifukwa pamenepa ngakhale maola athunthu amatha kuwongolera? Poterepa, ndizomveka kugwiritsa ntchito njira yomwe ingakuthandizeni kuti muzimitsa mutu ndi chotsitsa komanso zomwe zili pamasamba onse.
- Sankhani masamba omwe mukufuna kufafaniza kumapeto. Kenako, pitani ku tabu Kupita.
- Pa nthiti yomwe ili m'bokosi la chida Zikhazikiko Tsamba dinani chizindikiro chaching'ono monga muvi wopindika womwe uli pakona yakumbuyo kwa chipingachi.
- Pazenera lomwe limatsegulira, masanjidwe atsamba amapita ku tabu "Omvera ndi oyendayenda".
- M'magawo Mutu ndi Phiri timayitanitsa mndandanda wokhala mokhazikika. Pamndandanda, sankhani "(Ayi)". Dinani batani "Zabwino".
Monga mukuwonera, zitatha izi, zonse zolembedwa zomwe zapezeka patsamba losankhidwa zidatsimikizika. Tsopano, monga nthawi yotsiriza, muyenera kuletsa mitu yoyambira ndi yowongolera kudzera pazenera pazithunzi.
Tsopano mahedita ndi opita kumapeto amachotsedwa kwathunthu, ndiye kuti, siziwonetsedwa pachithunzipa, komanso kuti adzachotsedwa kukumbukira kukumbukira kwa fayilo.
Monga mukuwonera, ngati mukudziwa zina mwamavuto ogwirira ntchito ndi pulogalamu ya Excel, kuwachotsa omvera pamutuwu ndikuchita masewera olimbitsa thupi kwa nthawi yayitali kumatha kukhala njira yachangu. Komabe, ngati chikalatacho chili ndi masamba ochepa, ndiye kuti mutha kugwiritsa ntchito kufufutidwa. Chachikulu ndichakuti musankhe zomwe mukufuna kuchita: chotsani chotsani kapena kuti muwabisire kwakanthawi.
