Kulemba manambala pamasamba ndi chida chothandiza kwambiri ndipo kosavuta kuphatikiza zikalata posindikiza. Inde, ma sheet owerengeka ndiosavuta kukonza mwadongosolo. Ndipo ngati zingasakanike mwadzidzidzi mtsogolomu, mutha kuwonjezeranso mwachangu molingana ndi kuchuluka kwawo. Koma nthawi zina muyenera kuchotsa manambala pambuyo kuti aikidwapo. Tiyeni tiwone momwe izi zingachitikire.
Onaninso: Momwe mungachotsere manambala a masamba m'Mawu
Ziwerengero zochotsa manambala
Kukonzekera kwa njira yochotsera manambala ku Excel, choyambirira, zimatengera momwe adaikidwira ndi chifukwa chake adaikidwira. Pali magulu awiri akuluakulu. Yoyamba mwa iyo imawoneka pomwe chikwangwani chimasindikizidwa, chachiwiri chitha kuonedwa pokhapokha ngati tikugwiritsa ntchito tsamba lokhala ndi pulogalamu yowunikira. Malinga ndi izi, ziwerengero zimatsukidwanso m'njira zosiyanasiyana. Tiyeni tizingokhalira mwatsatanetsatane.
Njira 1: chotsani manambala azamba
Tiyeni tikhazikike nthawi yomweyo panjira yochotsa manambala akumbuyo, yomwe imawoneka pa chiwonetsero chokha. Izi ndi ziwerengero zamtundu wa "Page 1", "Tsamba 2", ndi zina zambiri, zomwe zimawonetsedwa mwachindunji pa pepala lokha mumawonekedwe. Njira yosavuta yochitira izi ndikungosinthira mawonekedwe ena onse. Pali njira ziwiri zochitira izi.
- Njira yosavuta yosinthira ku mtundu wina ndikudina pazizindikiro pa bar. Njira iyi imapezeka nthawi zonse, ndipo ndikongodina kamodzi, ziribe kanthu momwe muliri. Kuti muchite izi, dinani kumanzere pachizindikiro chilichonse chosinthaku, kupatula chizindikiro "Tsamba". Izi zisinthidwe zimapezeka mu bar yazolowera kumanzere kwa zotsatsira.
- Zitatha izi, zolemba zomwe zili ndi manambala sizidzawonekanso papepala lantchito.
Palinso njira yosinthira mitundu pogwiritsa ntchito zida pa tepi.
- Pitani ku tabu "Onani".
- Pa nthiti mumakonzedwe Mawonekedwe a Buku dinani batani "Zachizolowezi" kapena Masanjidwe Tsamba.
Pambuyo pake, mawonekedwe a tsamba adzatsekedwa, zomwe zikutanthauza kuti kuwerengera kwam'mbuyo kudzatha.
Phunziro: Momwe mungachotsere zolembedwa patsamba 1 mu Excel
Njira 2: yeretsani omvera komanso opita kumapazi
Pali zinthu zomwe zingasinthe pomwe, pogwira ntchito ndi tebulo ku Excel, manambala sawoneka, koma akuwoneka ngati chikalata chidasindikizidwa. Komanso, zitha kuwoneka pazenera loyang'ana chikalatacho. Kuti mupite kumeneko, muyenera kupita ku tabu Fayilokenako sankhani chinthucho mndandanda wamanzere wopita kumanzere "Sindikizani". Mu gawo loyenera la zenera lomwe limatseguka, malo oyang'ana chikalatacho apezeka. Ndipamene mutha kuwona ngati tsamba lomwe lisindikizidwe lidzawerengeredwa kapena ayi. Manambala akhoza kukhala pamwamba pa pepalalo, pansi kapena m'malo onsewo nthawi imodzi.
Kulemba manambala kwamtunduwu kumachitika pogwiritsa ntchito opita kumapazi. Awa ndi malo obisika momwe deta imawonekera pa kusindikiza. Amagwiritsidwa ntchito polemba manambala, kuyika zolemba zingapo, ndi zina zambiri. Nthawi yomweyo, kuti mupeze tsambalo, simufunikira kuyika manambala patsamba lililonse. Ndikokwanira patsamba limodzi, mukadali ochepetsa, kulemba mawu aliwonse ali m'minda itatu yapamwamba kapena itatu:
& [Tsamba]
Pambuyo pake, kuwerengera kosalekeza kwa masamba onse kudzachitika. Chifukwa chake, kuchotsa manambala awa, muyenera kungochotsa gawo kumapeto, ndikusunga chikalatacho.
- Choyamba, kuti tikwaniritse ntchito yathu tiyenera kusinthira ku mawonekedwe a footer. Izi zitha kuchitika ndi zosankha zingapo. Pitani ku tabu Ikani ndipo dinani batani "Omvera ndi oyendayenda"ili pa riboni m'bokosi la chida "Zolemba".
Kuphatikiza apo, mutha kuwona zakumutu ndi zotsitsa posinthira pamakonzedwe azosintha tsamba kudzera pa chithunzi chomwe timadziwa kale mu bar ya udindo. Kuti muchite izi, dinani pachizindikiro chapakati posinthira mawonedwe, omwe amatchedwa Masanjidwe Tsamba.
Njira ina ndikupita ku tabu "Onani". Dinani batani pamenepo. Masanjidwe Tsamba pa riboni m'gulu la zida Mitundu Yowonera.
- Njira iliyonse yomwe mungasankhe, mungaone zomwe zili pamutu komanso kumapeto. M'mbiri yathu, nambala yamasambayi ili mgawo lamanzere kumanzere kumanzere kumanzere.
- Ingoikani chidziwitso mu gawo loyenerera ndikudina batani Chotsani pa kiyibodi.
- Monga mukuwonera, zitatha izi, ziwerengero sizinangotuluka pakona yakumanzere ya tsamba pomwe wonyentayo adachotsedwa, komanso pazinthu zina zonse zomwe zalembedwa pamalo amodzi. Momwemonso, timachotsa zomwe zili pansi. Khazikitsani cholozera pamenepo ndikudina batani Chotsani.
- Tsopano kuti deta yonse yomwe ili kumapazi yachotsedwa, titha kusintha momwe tikugwirira ntchito. Kuti muchite izi, mwina tabu "Onani" dinani batani "Zachizolowezi", kapena mu bar yapa, dinani batani lokhala ndi dzina lomweli.
- Musaiwale kusindikiza chikalatacho. Kuti muchite izi, ingodinani chizindikiro, chomwe chimawoneka ngati diski ya Floppy ndipo ili pakona yakumanzere pazenera.
- Kuti tiwonetsetse kuti manambala achokeradi ndipo sapezeka pa chosindikizira, timapita ku tabu Fayilo.
- Pa zenera lomwe limatseguka, sinthani ku gawo "Sindikizani" kudzera pa mndandanda wokhotera kumanzere. Monga mukuwonera, m'dera lodziwika bwino lomwe, masamba omwe alembedwa akusowa. Izi zikutanthauza kuti ngati titayamba kusindikiza bukulo, kutulutsa kwake kudzakhala mapepala osawerengera, zomwe zinali zomwe timayenera kuchita.
Kuphatikiza apo, mutha kuyimitsa omvera onse.
- Pitani ku tabu Fayilo. Timasamukira ku gawo lina "Sindikizani". Makonda osindikizira ali mkati mwa zenera. Pamunsi pa block iyi, dinani zolemba Zikhazikiko Tsamba.
- Tsamba la zosankha zamasamba liyamba. M'minda Mutu ndi Phiri kuchokera mndandanda wotsika, sankhani "(ayi)". Pambuyo pake, dinani batani "Zabwino" pansi pazenera.
- Monga mukuwonera m'dera lachiwonetsero, ziwerengero zamatsamba zimasowa.
Phunziro: Momwe mungachotsere kumapeto anthu ku Excel
Monga mukuwonera, kusankha kwa njira yakulemetsera masamba kumatengera zimadalira momwe manambala amakondera. Ngati chikuwonetsedwa pachithunzithunzi chongowonera, ndiye kuti sinthani mawonekedwe. Ngati manambala asindikizidwa, ndiye kuti mwachita izi, muyenera kuchotsa zomwe zili pansi.
