Fomu Zolowetsera Ma data mu Microsoft Excel

Kuthandizira kulowetsa deta mu tebulo ku Excel, mutha kugwiritsa ntchito mafomu apadera kuti muthandizire kufulumira njira yodzaza mndandanda wazambiri ndi zidziwitso. Excel ili ndi chida chomangidwa chomwe chimakulolani kuti mudzaze ndi njira yofananira. Wogwiritsa ntchitoyo atha kupanga mtundu wake wa fomu, yomwe idzasinthidwe kwambiri ndi zosowa zake, pogwiritsa ntchito macro pa izi. Tiyeni tiwone kugwiritsidwa ntchito kosiyanasiyana kwa zida zofunikira izi zodzaza mu Excel.

Kugwiritsa ntchito zida zodzaza

Fomu yodzaza ndi chinthu chomwe minda yomwe mayina awo amafanana ndi mayina a mizati ya gome kuti mudzaze. Muyenera kuyika zambiri m'magawo awa ndipo aziwonjezedwa pomwepo ndi mzere watsopano pamtundu wa tebulo. Fomuyi imatha kukhala ngati chida chosiyidwa ndi Excel, kapena chizikhazikitsidwa mwachindunji papepala momwe mulili, ngati zidapangidwa ndi wogwiritsa ntchito.

Tsopano tiyeni tiwone momwe mungagwiritsire ntchito zida ziwiri izi.

Njira 1: chinthu chomangiramo zolemba za Excel

Choyamba, tiyeni tisanthule momwe mungagwiritsire ntchito mawonekedwe omwe adalowetsedwa kuti mulowetse data ya Excel.

1. Tiyenera kudziwa kuti pokhapokha chizindikiro chomwe chimayambitsa chimakhala chobisika ndipo chimayenera kuyambitsa. Kuti muchite izi, pitani ku tabu Fayilokenako dinani chinthucho "Zosankha".



2. Pa zenera lotsegulidwa la Excel, pitani ku gawo Chida Chofikira Mwachangu. Yambiri ya zenera imakhala ndi gawo lalikulu la zoikamo. Kumanzere kuli zida zomwe zingathe kuwonjezeredwa pagawo lofikira mwachangu, ndipo kumanja - kulipo kale.

   M'munda "Sankhani magulu ku" mtengo wokhazikitsidwa "Matimu osakhala pa tepi". Chotsatira, kuchokera mndandanda wamalamulo motengera zilembo, timapeza ndi kusankha malamulowo "Fomu ...". Kenako dinani batani Onjezani.



3. Pambuyo pake, chida chomwe tikufuna chikuwonetsedwa kudzanja lamanja la zenera. Dinani batani "Zabwino".



4. Tsopano chida ichi chili pawindo la Excel pazenera lofulumira, ndipo titha kuchigwiritsa ntchito. Idzakhalapo mukatsegula buku lililonse la ntchito ndi iyi Excel.



5. Tsopano, kuti chida chimveke bwino chomwe chikufunika kudzazitsa, muyenera kudzaza mutu wa tebulo ndikulemba mtengo uliwonse uli momwemo. Lolani gome lathu likhale ndi ife pazikhala ndi mizati inayi yomwe ili ndi mayina "Zogulitsa", "Kuchuluka", "Mtengo" ndi "Ndalama". Lowetsani dzina lakalembedwe mozungulira.



6. Komanso, kuti pulogalamuyo imvetsetse komwe ikufunika kugwirira ntchito, muyenera kuyika mulingo uli wonse mzere woyamba wa mndandanda.



7. Pambuyo pake, sankhani khungu lililonse la tebulo lopanda kanthu ndikudina chizindikirocho patsamba lofikira mwachangu "Fomu ..."zomwe tidazichita kale.



8. Chifukwa chake, zenera la chida cholankhuliracho likutseguka. Monga mukuwonera, chinthu ichi chili ndi malo omwe amafanana ndi mayina ammagulu a mndandanda wathu. Komanso, gawo loyamba ladzazidwa kale ndi mtengo, popeza tidalowetsa pamanja.



9. Lowetsani zomwe tikuwona kuti ndizofunikira m'magawo otsalawo, kenako dinani batani Onjezani.



10. Zitatha izi, monga mukuwonera, zoyikidwazo zidasinthidwa zokha kumka mzere woyamba wa tebulo, ndipo mawonekedwewo amasinthidwa kupita kumalire ena, omwe akufanana ndi mzere wachiwiri wa mindandanda yazambiri.



11. Dzazani zenera ndi zida zomwe tikufuna kuwona mzere wachiwiri wa tebulo, ndikudina batani kachiwiri Onjezani.



12. Monga mukuwonera, zofunikira za mzere wachiwiri zidawonjezedwanso, ndipo sitidafunanso kukonza chiwonetsero cha tebulo palokha.



13. Chifukwa chake, timadzaza zidutswa za tebulo ndi zofunikira zonse zomwe tikufuna kulowamo.



14. Kuphatikiza apo, ngati mukufuna, mutha kuyendayenda pazomwe mudalowetsa kale pogwiritsa ntchito mabatani "Kubwerera" ndi "Kenako" kapena mpukutu wa mpukutu wokhazikika.



15. Ngati ndi kotheka, mutha kusintha mawonekedwe aliwonse mwamndandanda patebulo mwa kusintha mawonekedwe. Kuti musinthe zomwe zikuwoneka patsamba, mutapanga iwo mu chipangizo chofananira, dinani batani Onjezani.



16. Monga mukuwonera, kusinthaku kunachitika nthawi yomweyo patebulo.



17. Ngati tikufunika kuchotsa mzere, ndiye kuti timabatani toyenda kapena pa bar ya scrollbar tikupita koyenera kofananira ndi mawonekedwe. Pambuyo pake, dinani batani Chotsani pazenera.



18. Kukambirana machenjezo kumatseguka, kukudziwitsani kuti mzerewo uchotsedwa. Ngati mukukhulupirira zochita zanu, dinani batani "Zabwino".



19. Monga mukuwonera, mzerewu udachotsedwa pamtundu wa tebulo. Mukadzaza ndikusintha kumalizidwa, mutha kutuluka pazenera la zida podina batani Tsekani.



20. Pambuyo pake, kuti gome likhale ndi mawonekedwe owoneka bwino, mawonekedwe amatha kuchitika.

Njira 2: pangani mawonekedwe

Kuphatikiza apo, mothandizidwa ndi macro ndi zida zina zingapo, ndizotheka kupanga mawonekedwe anu enieni kuti mudzaze tebulo. Idapangidwa mwachindunji papepala, ndikuyimira mawonekedwe ake. Pogwiritsa ntchito chida ichi, wogwiritsa ntchitoyo athe kuzindikira mipata yomwe akuwona kuti ndi yofunika. Ponena za magwiridwe antchito, sizingakhale zocheperapo kuposa momwe zimakhazikitsidwa mu Excel analogue, ndipo m'njira zina zitha kukhala zazikulupo. Chojambula chokha ndichakuti pagome lililonse muyenera kupanga mawonekedwe osiyana, osagwiritsa ntchito template yomweyo, momwe mungathere pogwiritsa ntchito mtundu wanthawi zonse.

1. Monga momwe munachitira kale, choyambirira, muyenera kupanga mutu wa tebulo lamtsogolo pa pepalalo. Lizikhala ndi maselo asanu okhala ndi mayina: "Ayi.", "Zogulitsa", "Kuchuluka", "Mtengo", "Ndalama".



2. Chotsatira, tifunika kupanga zomwe amati "zanzeru" patebulo lathu, ndikutha kuwonjezera mizere podzaza mizere yoyandikana kapena maselo ndi deta. Kuti muchite izi, sankhani wamutu ndipo, kukhala tabu "Pofikira"dinani batani "Fomati ngati tebulo" mu bokosi la zida Masitaelo. Izi zimatsegula mndandanda wazosankha zomwe zilipo kale. Kusankhidwa kwa imodzi mwanjira sikungawononge magwiridwe antchito mwanjira iliyonse, chifukwa chake timangosankha zosankha zomwe tikuwona kuti ndizoyenera.



3. Kenako zenera laling'ono lokonza tebulo likutsegulidwa. Zimawonetsa mtundu womwe tidagawa kale, ndiye mtundu wamutu. Monga lamulo, mu gawo ili zonse zimakwaniritsidwa molondola. Koma tiyenera kuwunika bokosi pafupi ndi paramalo Mutu wa Mitu. Pambuyo pake, dinani batani "Zabwino".



4. Chifukwa chake, mitundu yathu imapangidwa ngati tebulo la "anzeru", monga zikuwonekeranso ndi kusintha kowonekera. Monga mukuwonera, pakati pazinthu zina, zithunzi za zosefera zimawonekera pafupi ndi dzina lililonse la mutu. Ayenera kukhala olumala. Kuti muchite izi, sankhani khungu lililonse la "smart" tebulo ndikupita pa tabu "Zambiri". Pamenepo pa riboni m'bokosi la chida Sanjani ndi Fyuluta dinani pachizindikiro "Zosefera".

   

   Palinso njira ina yolepheretsa fyuluta. Poterepa, sizingakhale zofunikira kusintha pa tabu ina, yotsalira pa tabu "Pofikira". Mukasankha maselo a malo a tebulo pa riboni m'mazenera "Kusintha" dinani pachizindikiro Sanjani ndi Fyuluta. Pamndandanda womwe umawonekera, sankhani mawonekedwe "Zosefera".



5. Monga mukuwonera, izi zitachitika, zithunzi zosefera zidasowa pamutu pa tebulo, monga zimafunikira.



6. Kenako tiyenera kupanga mawonekedwe olowetsera data yomwe. Idzakhalanso mtundu wa mitundu yosanja ya tebulo. Mayina amtundu wa chinthu ichi adzafanana ndi mayina amtundu wa tebulo lalikulu. Chosiyana ndi mzati "Ayi." ndi "Ndalama". Adzakhala palibe. Yoyamba imawerengeredwa pogwiritsa ntchito macro, ndipo yachiwiriyo imawerengeredwa polemba mafomu ochulukitsa kuchuluka kwake pamtengo.

   Kholamu yachiwiri ya chinthu cholowetsedwayo yasiyidwa pano. Malingaliro amtsogolo adzalowetsedwamo kuti mudzaze mizere ya mndandanda waukulu.



7. Pambuyo pake timapanga tebulo limodzi lina laling'ono. Idzakhala ndi gawo limodzi ndipo ili ndi mndandanda wazinthu zomwe tiziwonetsa patsamba lachiwiri la tebulo lalikulu. Mwachidziwitso, khungu lomwe lili ndi mutu wa mndandandandawo ("Mndandanda wazogulitsa") itha kukhala yodzaza ndi utoto.



8. Kenako sankhani selo yoyamba yopanda kanthu. Pitani ku tabu "Zambiri". Dinani pachizindikiro Chitsimikiziro cha datayomwe imayikidwa pachifuwa "Gwirani ntchito ndi deta".



9. Zenera lochitira zotsimikizira likuyamba. Dinani pamunda "Mtundu wa deta"zomwe zimatsutsana ndi "Mtengo uliwonse".



10. Kuchokera pazomwe zidatsegulidwa, sankhani malo Mndandanda.



11. Monga mukuwonera, zitatha izi, zenera lofufuza zamomwe linasinthira linasintha pang'ono kasinthidwe kake. Gawo lowonjezera lawonekera "Gwero". Timadina pachizindikiro kumanja kwake ndi batani lakumanzere.



12. Kenako zenera loyang'ana limachepetsedwa. Sankhani mndandanda wazidziwitso zomwe zimayikidwa pa pepala m'malo ena owonjezera ndi cholozera pomwe muli ndi batani lakumanzere "Mndandanda wazogulitsa". Zitatha izi, dinaninso chizindikiro kumanja kwa dilesi pomwe adilesi yanuyo yasankhidwa.



13. Izi zimabwereranso ku bokosi loyendera kuti mulowetse zofunika. Monga mukuwonera, zogwirizanitsa zamagulu osankhidwa mmenemo zikuwonetsedwa kale m'munda "Gwero". Dinani batani "Zabwino" pansi pazenera.



14. Tsopano, kumanja kwa selo lopanda kanthu la chinthu cholowetsa chidziwitso, chithunzi cha makona atatu chawonekera. Mukadina pa izo, mndandanda wotsika pansi umatsegulidwa, wokhala ndi mayina omwe amachotsedwa pamndandanda wazomwe zimayikidwa patebulo "Mndandanda wazogulitsa". Tsopano ndikosatheka kuyika zosankha zotsutsana mu foni yomwe mwayang'aniridwa, koma mutha kusankha malo omwe mukufuna pazndandanda zomwe zaperekedwa. Sankhani chinthu m'ndandanda wotsika.



15. Monga mukuwonera, malo omwe adasankhidwa adawonetsedwa nthawi yomweyo m'munda "Zogulitsa".



16. Chotsatira, tidzafunika kupatsa mayina kumaselo atatu a fomuyo momwe tidzaikemo. Sankhani foni yoyamba, pomwe dzinalo laikidwa kale kwa ife "Mbatata". Kenako, pitani kumunda wamagulu osiyanasiyana. Ili kumanzere kwa zenera la Excel pamlingo womwewo. Lowetsani dzina lotsutsana pamenepo. Itha kukhala dzina lililonse m'Chilatini, momwe mulibe malo, koma ndi bwino kugwiritsa ntchito mayina omwe ali pafupi ndi zomwe zimathetsedwa ndi chinthuchi. Chifukwa chake, khungu loyamba, lomwe lili ndi dzina la malonda, limatchedwa "Dzinalo". Timalemba dzinali m'munda ndikusindikiza fungulo Lowani pa kiyibodi.



17. Mwanjira yomweyo timapereka dzina ku foni momwe tidzalembe kuchuluka "Volum".



18. Ndipo khungu limodzi ndi mtengo - "Mtengo".



19. Zitatha izi, ndendende momwe timapatsira mayina kuzonse za maselo atatu omwe ali pamwambapa. Choyamba, sankhani, kenako ndikupatseni dzinali mundawo yapadera. Likhale dzina "Diapason".



20. Pambuyo pomaliza kuchita, tiyenera kusunga chikalatacho kuti mayina omwe tidatipatsa awoneke ndi ma macro omwe tidapanga mtsogolo. Kuti musunge, pitani ku tabu Fayilo ndipo dinani pachinthucho "Sungani Monga ...".



21. Pazenera lopulumutsa lomwe limatseguka, m'munda Mtundu wa Fayilo sankhani mtengo "Buku la Excel Macro Lothandizidwa (.xlsm)". Kenako, dinani batani Sungani.



22. Kenako muyenera kuyambitsa ma macros mumtundu wanu wa Excel ndikuwathandiza tabu "Wopanga"ngati mulibe. Chowonadi ndi chakuti ntchito zonsezi zimayimitsidwa pokhapokha mu pulogalamuyi, ndipo kuyambitsa kwawo kuyenera kuchitidwa mwamphamvu pazenera la Excel.
23. Mukamaliza kuchita izi, pitani ku tabu "Wopanga". Dinani pa chithunzi chachikulu "Zowoneka Zachikulu"ili pa riboni m'bokosi la chida "Code".



24. Chochita chomaliza chimapangitsa mkonzi wa VBA macro kuyamba. M'deralo "Ntchito", yomwe ili kumtunda chakumanzere kwa zenera, sankhani dzina la pepalalo lomwe matebulo athu ali. Pankhaniyi, zili "Mapepala 1".



25. Pambuyo pake, pitani kumunsi kumanzere kwa zenera lotchedwa "Katundu". Nawo makonda a pepala losankhidwa. M'munda "(Dzinalo)" Dzina la Czechillic liyenera kusinthidwa ("Sheet1") mu dzina lolemba m'Chilatini. Mutha kupereka dzina lililonse lomwe limakusangalatsani, chachikulu ndichakuti lilinso ndi zilembo za chi Latin kapena manambala osakhala ndi zizindikilo zina kapena malo. Ndili ndi dzina ili kuti macro adzagwira ntchito. Tiloleni dzina lathu kukhala "Wopanga", ngakhale mutha kusankha ina iliyonse yomwe ikugwirizana ndi zomwe tafotokozazi.

    M'munda "Dzinalo" Mutha kubwezeretsanso dzinalo ndi lina labwino koposa. Koma izi sizofunikira. Pankhaniyi, kugwiritsa ntchito malo, Cyrillic ndi zilembo zina zilizonse amaloledwa. Mosiyana ndi gawo lakale, lomwe limayika dzina la pepalalo, pulogalamuyi imapatsa dzina pepalalo lomwe likuwoneka kwa wogwiritsa ntchito njira yachidule.

    Monga mukuwonera, zitatha dzinalo lizisintha lokha Mapepala 1 m'munda "Ntchito", kwa amene tangokhazikitsa zoikamo.



26. Kenako pitani pakatikati pazenera. Apa ndipomwe tidzafunikira kulemba zikuluzikulu zazikulu zokha. Ngati gawo la cholembera yoyera pamalo omwe awonetsedwa silikuwonetsedwa, monga ife, ndiye dinani batani la ntchito F7 ndipo zidzaonekera.



27. Tsopano pachitsanzo chathu, tifunika kulemba zotsatirazi code iyi m'munda:

    
Sub DataEntryForm ()
Chepetsa mzere wotsatira
NextRow = Producty.Cell (Producty.Rows.Count, 2) .End (xlUp) .Kutulutsa (1, 0) .Row
Ndi zopangidwa
Ngati .Range ("A2"). Mtengo = "" Ndipo .Range ("B2"). Mtengo = "" Kenako
NextRow = nextRow - 1
Mapeto ngati
Producty.Range ("Dzina"). Copy
.Amasewera (nextRow, 2) .PasteSpecial Set: = xlPasteValues
.Cell (nextRow, 3) .Value = Producty.Range ("Volum").
.Cell (nextRow, 4) .Value = Producty.Range ("Mtengo"). Mtengo
.Cell (nextRow, 5) .Value = Producty.Range ("Volum"). Thamani * Producty.Range ("Mtengo").
.Range ("A2") formula = "= IF (ISBLANK (B2)," "", COUNTA ($ B $ 2: B2)) "
Ngati lotsatira> 2 Ndiye
Range ("A2"). Sankhani
Kusankha.AutoFill Kufikira: = Osanja ("A2: A" & nextRow)
Range ("A2: A" & nextRow) .Select
Mapeto ngati
.Range ("Diapason")
Mapeto ndi
Mapeto sub

    Koma manambala awa sikuti ali konsekonse, ndiye kuti, sanasinthe kungoyenera ife. Ngati mukufuna kuzisintha kuzosowa zanu, ndiye kuti ziyenera kusinthidwa moyenerera. Kuti muthe kuzichita nokha, tiyeni tiwone zomwe code iyi ili, zomwe ziyenera kusinthidwa, ndi zomwe siziyenera kusinthidwa.

    Ndiye mzere woyamba:

    Sub DataEntryForm ()

    "DataEntryForm" dzina la macro lokha. Mutha kuzisiyira momwe ziliri, kapena mutha kuzisintha ndi zina zilizonse zomwe zimakwaniritsa malamulo opanga ma macro ambiri (opanda malo, ingogwiritsa zilembo za zilembo za Chilatini, ndi zina). Kusintha dzinalo sikukhudza chilichonse.

    Kulikonse kumene mawuwo amapezeka patsamba "Wopanga" uyenera kuyikapo ndi dzina lomwe mudapereka kwa pepala lanu m'munda "(Dzinalo)" madera a "Katundu" mkonzi wamkulu. Mwachilengedwe, izi zikuyenera kuchitika pokhapokha mutatchula pepalalo mwanjira ina.

    

    Tsopano taganizirani izi:

    NextRow = Producty.Cell (Producty.Rows.Count, 2) .End (xlUp) .Kutulutsa (1, 0) .Row

    Digit "2" mzere uwu ukutanthauza gawo lachiwiri la pepalalo. Mzerewu ndi mzati "Zogulitsa". Pa iwo tiwerenga kuchuluka kwa mizere. Chifukwa chake, ngati mwa inu gawo lofananira lili ndi dongosolo losiyana muakaunti, ndiye kuti muyenera kuyika nambala yolingana. Mtengo "Mapeto (xlUp) .Offset (1, 0) .Row" Mulimonsemo, musasinthe.

    

    Kenako, lingalirani za mzere

    Ngati .Range ("A2"). Mtengo = "" Ndipo .Range ("B2"). Mtengo = "" Kenako

    "A2" awa ndi ma membala a khungu loyamba momwe manambala adzawonetsedwa. "B2" - awa ndi ma membala a khungu loyamba lomwe deta imatulutsidwa ("Zogulitsa") Ngati zingasiyane, ikani data yanu m'malo mwa izi.

    

    Pitani ku mzere

    Producty.Range ("Dzina"). Copy

    Ili ndi gawo "Dzinalo" amatanthauza dzina lomwe tidapereka kumunda "Zogulitsa" mu mawonekedwe.

    

    M'mizere

    
.Amasewera (nextRow, 2) .PasteSpecial Set: = xlPasteValues
.Cell (nextRow, 3) .Value = Producty.Range ("Volum").
.Cell (nextRow, 4) .Value = Producty.Range ("Mtengo"). Mtengo
.Cell (nextRow, 5) .Value = Producty.Range ("Volum"). Thamani * Producty.Range ("Mtengo").

    mayina "Volum" ndi "Mtengo" amatanthauza mayina omwe tidapereka kuminda "Kuchuluka" ndi "Mtengo" mu mawonekedwe omwewo.

    

    M'mizere yomweyi yomwe tinafotokozera pamwambapa, ziwerengero "2", "3", "4", "5" amatanthauza manambala azigawo patsamba la Excel lolingana ndi mzati "Zogulitsa", "Kuchuluka", "Mtengo" ndi "Ndalama". Chifukwa chake, ngati kwanuko tebulo lisunthidwa, muyenera kutchula nambala yolumikizana. Ngati pali mizati yambiri, ndiye kuti ndi fanizo muyenera kuwonjezera mizere yake kuzowongolera, ngati kuli kochepa - ndiye kuti chotsani zowonjezera.

    

    Mzerewu umachulukitsa kuchuluka kwa katundu ndi mtengo wake:

    .Cell (nextRow, 5) .Value = Producty.Range ("Volum"). Thamani * Producty.Range ("Mtengo").

    Zotsatira zake, monga momwe tikuwonera kuchokera pazophatikizira zojambulidwa, ziwonetsedwa mzere wachisanu wa pepala lothandizira la Excel.

    

    Mawuwa amachita manambala owerengera okha:

    
Ngati lotsatira> 2 Ndiye
Range ("A2"). Sankhani
Kusankha.AutoFill Kufikira: = Osanja ("A2: A" & nextRow)
Range ("A2: A" & nextRow) .Select
Mapeto ngati

    Mfundo zonse "A2" tanthauza adilesi ya foni yoyamba pomwe kuwerenga manambala kudzachitika, ndikugwirizanitsa "" - Adilesi ya mzere wonsewo ndi manambala. Chongani kuti ndendende kuchuluka komwe kudzawonetsedwe patebulo lanu ndikusintha magwirizanowu mu code, ngati kuli kofunikira.

    

    Mzerewu umayeretsa mitundu yonse ya mafomu olowera patatha izi kuchokera pomwe zasinthidwa ku tebulo:

    .Range ("Diapason")

    Sikovuta kunena kuti ("Diapason") amatanthauza dzina la mtundu womwe tidagawire m'magawo olowa ndi data. Ngati mudawapatsa dzina lina, ndiye kuti mzerewu uyenera kuyikidwadi.

    

    Gawo lina la code ndi ponseponse ndipo nthawi zonse lidzayambitsidwa popanda kusintha.

    Mutatha kujambula nambala yazipamwamba pazenera la mkonzi, dinani pazithunzi zosungira monga gawo la diskette kumanzere kwa zenera. Kenako mutha kutseka ndikudina batani loyenera kutseka mawindo pakona yakumanja yakumanja.



28. Pambuyo pake, timabwereranso ku pepala la Excel. Tsopano tikuyenera kuyika batani lomwe lingayambitse macro opangidwa. Kuti muchite izi, pitani ku tabu "Wopanga". Mu makatani "Olamulira" pa riboni, dinani batani Ikani. Mndandanda wazida umatsegulidwa. Mu gulu lazida "Zolamulira Fomu" sankhani woyamba - Batani.



29. Kenako, ndikudina batani lakumanzere ndikanikizidwa, jambulani cholozera pamalopo pomwe tikufuna kuyika batani loyambitsitsa, lomwe lidzasamutse data kuchokera pafomu kupita pagome.



30. Malowo atazunguliridwa, masulani batani la mbewa. Kenako, zenera lambiri la chinthucho limayamba lokha. Ngati ma macros angapo agwiritsidwa ntchito m'buku lanu, sankhani dzina la yemwe tidapanga pamwambapa. Timachitcha "DataEntryForm". Koma pankhaniyi, ma macro ndi amodzi, kotero ingosankha ndikudina batani "Zabwino" pansi pazenera.



31. Pambuyo pake, mutha kusinthanso batani momwe mungafunire, pongowunikira dzina lapakale.

    

    Mwachitsanzo, kwa ife, zingakhale zomveka kuti amupatse dzina Onjezani. Tchulani dzina lake ndikudina foni yaulere iliyonse patsamba



32. Chifukwa chake, mawonekedwe athu ndi okonzeka kwathunthu. Tiyeni tiwone momwe imagwirira ntchito. Lowetsani zofunikira m'minda yake ndikudina batani Onjezani.



33. Monga mukuwonera, zomwe zimasunthidwa zimasunthidwa pa tebulo, mzere umangopatsidwa nambala, kuchuluka kumawerengeredwa, magawo amafomu amayeretsedwa.



34. Lembani fomu ndikudina batani Onjezani.



35. Monga mukuwonera, mzere wachiwiri umawonjezedwanso patsamba lambiri. Izi zikutanthauza kuti chida chikugwira ntchito.

Werengani komanso:
Momwe mungapangire zazikulu mu Excel
Momwe mungapangire batani ku Excel

Ku Excel, pali njira ziwiri zogwiritsira ntchito fomu yodzazira deta: yomanga-ndi yogwiritsa ntchito. Kugwiritsa ntchito njira yomangidwira pamafunika kuyesetsa kochepa kuchokera kwa wogwiritsa ntchito. Mutha kuyambitsa nthawi zonse ndikuwonjezera chithunzi cholingana ndi chida chofikira mwachangu. Muyenera kupanga nokha mawonekedwe, koma ngati muli ndi luso la VBA, mutha kupanga chida ichi kukhala chosinthika komanso choyenera pa zosowa zanu momwe mungathere.