Kulemba tsamba ndizothandiza kwambiri zomwe zimakhala zosavuta kukonza chikalata pamene mukusindikiza. Zoonadi, mapepala owerengeka ndi osavuta kuwonongeka. Ndipo ngakhale atasokonezeka mwadzidzidzi m'tsogolomu, mungathe mwamsanga kumangirira molingana ndi chiwerengero chawo. Koma nthawi zina pamafunika kuchotsa chiwerengerochi mutatha kulembedwa. Tiyeni tiwone momwe izi zingakhalire.
Onaninso: Kodi mungachotsedwe bwanji mu Mawu?
Zosankha pofuna kuchotsa chiwerengero
Makhalidwe a chiwerengero cha kuchotsa chiwerengero ku Excel, choyamba, zimadalira momwe adayikidwira komanso zomwe adaziyika. Pali magulu akulu awiri owerengera. Yoyamba mwa iyo imawonekera pamene akusindikiza chikalata, ndipo yachiwiri ikhoza kuwonetsedwa pokhapokha akugwira ntchito ndi spreadsheet pa chowunika. Mogwirizana ndi izi, zipinda zimachotsedwanso m'njira zosiyana. Tiyeni tiyang'ane pa iwo mwatsatanetsatane.
Njira 1: Chotsani Mawerengedwe a Tsamba
Tiyeni tiyang'ane mwatsatanetsatane za njira yakuchotseramo chiwerengero cha tsamba la kumbuyo, chomwe chikuwonekera pokha pulogalamu yowonekera. Izi zawerengedwa mwa mtundu "Page 1", "Page 2", ndi zina zotero, zomwe zikuwonetsedwa mwachindunji pa pepala palokha pa tsamba lopatulira. Njira yosavuta yothetsera vutoli ndiyo kungosintha njira ina iliyonse. Pali njira ziwiri zochitira izi.
- Njira yosavuta yosinthana ndi mtundu wina ndikutsegula pazithunzi pa barreti yoyenera. Njirayi imapezeka nthawi zonse, ndipo ndi kokha kokha, ziribe kanthu tabu ili pati. Kuti muchite izi, dinani pang'onopang'ono pamasewero awiri osinthasintha, kupatula chizindikiro "Tsamba". Kusintha kumeneku kuli muzenera zadongosolo kumanzere kwa zojambulazo.
- Pambuyo pake, chiwerengero sichidzawonekanso pa tsamba la ntchito.
Palinso mwayi wosintha mawonekedwe pogwiritsa ntchito zipangizo pa tepi.
- Pitani ku tabu "Onani".
- Pa kachipangizo kamene kali mkati mwake "View View Mode" dinani pa batani "Zachibadwa" kapena "Tsamba la Tsamba".
Pambuyo pake, tsambalo la tsamba lidzakhala lolephereka, zomwe zikutanthauza kuti kulembera kumbuyo kudzatha.
PHUNZIRO: Mmene mungachotsere zolembazo Page 1 mu Excel
Njira 2: Chotsani Mutu ndi Zolemba
Palinso zochitika zotsutsana pamene mukugwira ntchito ndi tebulo ku Excel, kuwerengetsa sikuwonekera, koma kumawoneka pamene akusindikiza chikalata. Ndiponso, izo zimawoneka muzenera zowonetsera zolemba. Kuti mupite kumeneko, muyenera kusamukira ku tabu "Foni"ndiyeno kumanzere akumanzere akusankha malo "Sakani". Pakati pawindo lawindo lomwe likutsegulidwa, malo owonetserako a chilembetsero adzapezeka. Ndiko komwe mungathe kuwona ngati tsambalo lidzawerengedwa kapena kusindikizidwa. Nambala ikhoza kukhala pamwamba pa pepala, pansi kapena malo onse awiri panthawi yomweyo.
Kuwerengera kotereku kumachitidwa pogwiritsa ntchito mutu ndi zolemba. Izi ndizo malo obisika, deta yomwe imawonekera pa kusindikiza. Zimagwiritsidwa ntchito powerenga, kulembedwa kwa zolemba zosiyanasiyana, ndi zina zotero. Pa nthawi yomweyo, kuti muwerenge tsamba, sikofunika kulemba nambala pazomwe zili patsamba. Zokwanira pa tsamba limodzi, pokhala mowirikiza, kulemba mawuwa mulimonse la magawo atatu apamwamba kapena atatu apansi:
& [Tsamba]
Pambuyo pake, kuwerengera kwa masamba onse kudzapitirira. Choncho, kuchotsa chiwerengero ichi, mukufunikira kuchotsa gawo lazomwe zili m'munsiyi, ndi kusunga chikalatacho.
- Choyamba, kuti tichite ntchito yathu, muyenera kupita kumamutu ndi kumbuyo. Izi zingatheke ndi njira zingapo. Pitani ku tabu "Ikani" ndipo dinani pa batani "Zolemba"yomwe ili pa tepiyi mu zida za zipangizo "Malembo".
Kuphatikizanso, mukhoza kuona mutu ndi zolemba popita kumalo osungira tsamba, kupyolera mu chithunzi chomwe tachizoloŵera kale mu bar. Kuti muchite izi, dinani chizindikiro cha pakati kuti musinthe mawonekedwe a zithunzi, omwe amatchedwa "Tsamba la Tsamba".
Njira ina ndi kupita ku tabu "Onani". Kumeneko muyenera kudina pa batani "Tsamba la Tsamba" pa tepi mu gulu la zida "Zojambula Zamabuku".
- Mulimonse momwe mungasankhire, mudzawona zomwe zili pamutu ndi phazi. Kwa ife, nambala ya tsamba ili kumbali ya kumanzere kumtunda ndi kumanzere.
- Ingoyikani mtolowo mu munda womwewo ndipo dinani pa batani. Chotsani pabokosi.
- Monga mukuonera, zitatha izi nambalayo idatayika kokha kumtunda wakumanzere kwa tsamba limene phazi linachotsedwa, komanso pazinthu zina zonse za chilembacho pamalo omwewo. Mofananamo, chotsani zomwe zili m'munsimu. Ikani cholozera pamenepo ndipo dinani pa batani. Chotsani.
- Tsopano kuti deta yonse ndi mutu wapamwamba wathetsedwa, tikhoza kusintha kuntchito yoyenera. Pachifukwachi, mwina mu tab "Onani" dinani pa batani "Zachibadwa", kapena mu barre ya udindo, dinani pa batani ndi dzina lomwelo.
- Musaiwale kuti mulembenso chikalatacho. Kuti muchite izi, ingomani pa chithunzi, chomwe chiri ndi mawonekedwe a floppy disk ndipo chiri pa ngodya yapamwamba kumanzere pawindo.
- Kuti muwonetsetse kuti nambalayi yawonongeka kwenikweni ndipo siidzawonekera pa kusindikiza, pita ku tabu "Foni".
- Pawindo lomwe limatsegulira, pita ku gawolo "Sakani" kudzera m'menyu yowonekera kumanzere. Monga momwe mukuonera, kusinkhasinkha pamalopo sikupezeka kumalo owonetserako kale omwe akutidziŵika kale. Izi zikutanthauza kuti ngati tayamba kusindikizira buku, ndiye kuti titulutsa mapepala osawerengera, zomwe ndi zomwe ziyenera kuchitidwa.
Kuwonjezera apo, mungathe kulepheretsa mutu ndi zidutswa zonse.
- Pitani ku tabu "Foni". Pitani ku gawolo "Sakani". Pakatikati pazenera ndizosindikiza. Pansi pa chithunzichi, dinani pazolembazo "Makhalidwe a Tsamba".
- Tsamba loyang'ana tsamba likuyamba. M'minda "Mutu" ndi Zotsatira kuchokera m'ndandanda wotsika pansi, sankhani kusankha "(ayi)". Pambuyo pake, dinani pa batani "Chabwino" pansi pazenera.
- Monga momwe mukuwonera m'dera lawonetserako, pepala lolembapo likusoweka.
PHUNZIRO: Mmene mungatulutsire mutu ndi zitsulo mu Excel
Monga momwe mukuonera, kusankha momwe mungaletsere kusamba kwa tsamba kumadalira makamaka momwe chiwerengerochi chikugwiritsidwira ntchito. Ngati izo ziwonetsedwa kokha pa pulogalamu yowunikira, zangokwanira kusintha mawonekedwe owonetsera. Ngati chiwerengerocho chimasindikizidwa, ndiye pakali pano ndikofunikira kuchotsa zomwe zili pamutu ndi phazi.
