Mu pulogalamu ya Microsoft Office, nthawi zina wogwiritsa ntchito amafunika kuika chitsimikizo kapena, monga izi zikutchulidwa, bokosi (checkbox). Izi zikhoza kuchitidwa pazinthu zosiyanasiyana: kungolemba chinthu, kuphatikiza zochitika zosiyanasiyana, ndi zina zotero. Tiyeni tione m'mene tingayankhire Excel.
Checkbox
Pali njira zingapo zowonjezera Excel. Kuti musankhe mwanjira inayake, muyenera kuika mwamsanga zomwe mukufunikira kuti muyang'ane bokosilo: kungolemba kapena kukonza njira zina ndi zolembedwa?
Phunziro: Momwe mungayankhire mu Microsoft Word
Njira 1: Lowani kudzera pa menyu "Chizindikiro"
Ngati mukufuna kuyika chongerezi kuti muwone zinthu zokhazokha, kuti mulembe chinthu, mutha kugwiritsa ntchito botani "Chizindikiro" chomwe chili pa riboni.
- Ikani chotsekeramo mu selo momwe chidziwitso chiyenera kupezeka. Pitani ku tabu "Ikani". Dinani pa batani "Chizindikiro"yomwe ili mu zida za zipangizo "Zizindikiro".
- Zenera likuyamba ndi mndandanda waukulu wa zinthu zosiyana. Musapite kulikonse, koma khalanibe mu tab "Zizindikiro". Kumunda "Mawu" Chilichonse cha ma fonti ofunikira angathe kufotokozedwa: Arial, Verdana, Nthawi yatsopano ya chibwenzi ndi zina. Kuti mwamsanga mupeze khalidwe lofunidwa m'munda "Khalani" ikani chizindikiro "Makalata amasintha malo". Tikuyang'ana chizindikiro "˅". Sankhani ndipo dinani pa batani. Sakanizani.
Pambuyo pake, chinthu chosankhidwa chidzawonekera mu selo yoyambirira.
Mofananamo, mukhoza kuikapo mbali yodziwika bwino ndi mbali zopanda malire kapena chitsimikizo mu bokosi la bokosi (bokosi laling'ono lomwe lapangidwa makamaka kuti liwone bokosi la cheke). Koma chifukwa cha ichi, mukufunikira kumunda "Mawu" onetsani mmalo mwawowonjezera mtundu wazithunzi wapadera Mapiko a mapiko. Ndiye muyenera kupita kumunsi mwa mndandanda wa malemba ndikusankha khalidwe lofunika. Pambuyo pake, dinani pa batani Sakanizani.
Munthu wosankhidwa waikidwa mu selo.
Njira 2: Zizindikiro Zobweretsera
Palinso ogwiritsa ntchito omwe sali ofanana kwenikweni. Kotero, mmalo moyika chizindikiro choyimira, ingolani khalidwelo kuchokera ku khibhodi "v" mu Chingerezi. Nthawi zina izi zimakhala zomveka, chifukwa njirayi imatenga nthawi yochepa. Ndipo kunja, kusinthika kumeneku kuli pafupi kusamvetseka.
Njira 3: Kuika chizindikiro pa bolodi
Koma kuti muyike kapena musamadziwe udindo wolemba, muyenera kugwira ntchito yovuta kwambiri. Choyamba, muyenera kukhazikitsa bolodi. Ili ndi bokosi laling'ono, komwe bokosi liwunika. Kuyika chinthu ichi, muyenera kutsegula mndandanda wamasewera, omwe amaletsedwa mwachinsinsi ku Excel.
- Kukhala mu tab "Foni", dinani pa chinthu "Zosankha"yomwe ili kumanzere kwawindo la tsopano.
- Fenje lazitali likuyambira. Pitani ku gawoli Kukonzekera kwa Ribbon. Pakati pazenera, yikani chizindikiro (izi ndi zomwe tikuyenera kuziyika pa pepala) moyang'anizana ndi parameter "Wotsambitsa". Pansi pawindo pindani pakani. "Chabwino". Pambuyo pake tabu idzawoneka pa nsalu. "Wotsambitsa".
- Pitani ku tabu yatsopanoyo. "Wotsambitsa". M'kati mwa zipangizo "Controls" pa tepicho dinani batani Sakanizani. Mndandanda umene umatsegulidwa pagulu Mawonekedwe a Fomu sankhani Checkbox.
- Pambuyo pake, chithunzithunzi chimatembenuka kukhala mtanda. Dinani iwo kumalo omwe ali pa pepala pomwe mukufuna kuyika fomu.
Bokosi loyang'ana lopanda kanthu likuwonekera.
- Kuti muike mbendera mmenemo, dinani pa chinthu ichi ndipo bokosi lidzasankhidwa.
- Kuti muchotse zolembazo, zomwe nthawi zambiri sizikufunika, dinani batani lamanzere pamasamba, sankhani zolembazo ndipo dinani pa batani Chotsani. Mmalo mwa lebulo lochotsedwa, mukhoza kuyika lina, kapena simungathe kuyika kanthu, kusiya bokosilo kuti lisatchulidwe. Izi ziri pamphamvu za wosuta.
- Ngati pali chosowa chokhazikitsa mabotolo angapo, ndiye kuti simungathe kupanga imodzi yosiyana pamzere uliwonse, koma lembani zomwe zatha kale, zomwe zimapulumutsa nthawi. Kuti muchite izi, nthawi yomweyo sankhani fomuyo podalira mbewa, kenako gwiritsani batani lakumanzere ndikukoka fomuyo ku selo lofunidwa. Popanda kutaya batani, timagwiritsa ntchito fungulo Ctrlndiyeno kumasula batani la mouse. Timachitanso opaleshoni yomweyo ndi maselo ena omwe muyenera kuikapo cheke.
Njira 4: Pangani bokosi kuti muzitsatira
Pamwamba, taphunzira momwe tingayankhire selo m'njira zosiyanasiyana. Koma nkhaniyi ingagwiritsidwe ntchito osati pokhapokha powonetsera maonekedwe, komanso kuthana ndi mavuto ena. Mungathe kukhazikitsa zosiyana ngati mutasintha bolo. Tidzawonanso momwe izi zimagwirira ntchito pachitsanzo chosintha mtundu wa selo.
- Pangani bokosi molingana ndi ndondomeko yowonongeka mu njira yapitayi, pogwiritsira ntchito tabu yothandizira.
- Dinani pa chinthucho ndi batani labwino la mouse. Mu menyu yachidule, sankhani chinthucho "Pangani chinthu ...".
- Zowonetsera zojambula zimatsegula. Pitani ku tabu "Control"ngati ilo linali lotseguka kwinakwake. Muzitsulo zamkati "Makhalidwe" dzikoli likuyenera kuwonetsedwa. Izi ndizakuti, ngati nkhupakupayi ikuyikidwa, makina ayenera kukhala pomwepo "Anayikidwa"ngati ayi - mu malo "Kutuluka". Udindo "Kusakanikirana" zosakondweretsedwa. Pambuyo pake dinani pazithunzi pafupi ndi munda "Link Link".
- Fenje lokhazikitsidwa limachepetsedwa, ndipo tifunika kusankha selo pa pepala limene bokosi lidzaphatikizidwa ndi cheke. Pambuyo pasankhidwayo, dinani pang'onopang'ono pa batani womwewo mwa mawonekedwe a chizindikiro, chomwe takambirana pamwambapa, kuti mubwerere ku zenera.
- Muzenera zojambulazo dinani pa batani. "Chabwino" kuti asunge kusintha.
Monga momwe mukuonera, mutatha kuchita izi mu selo yogwirizana, pamene bokosili likutsatidwa, mtengo "Zoona ". Ngati simukutsegula bokosi, mtengowo udzawonetsedwa. "ZINTHU". Kuti tikwaniritse ntchito yathu, kuti, kusintha mizere yodzaza, muyenera kusonkhanitsa mfundo izi mu selo ndikuchitapo kanthu.
- Sankhani selo yolumikizidwa ndikusakaniza ndi batani lamanja la mouse, mu menyu yotsegulidwa sankhani chinthucho "Sungani maselo ...".
- Zenera la mawonekedwe la selo limatsegula. Mu tab "Nambala" sankhani chinthu "Zopanga Zonse" mu chigawo cha parameter "Maofomu Owerengeka". Munda Lembani "yomwe ili pakatikati pawindo, timalemba mawu otsatirawa popanda ndemanga: ";;;". Timakanikiza batani "Chabwino" pansi pazenera. Zitatha izi, zolembedwa zooneka "WOONA" kuchokera mu selo yatha, koma phindu lidalipo.
- Sankhani selo yogwirizana ndikupita ku tabu. "Kunyumba". Timakanikiza batani "Mafomu Okhazikika"yomwe ili mu chida chogwiritsa ntchito "Masitala". M'ndandanda imene ikuwonekera dinani pa chinthucho "Pangani malamulo ...".
- Fenera yolenga chikhalidwe choyika maonekedwe chimatsegulidwa. Kumtunda kwake muyenera kusankha mtundu wa ulamuliro. Sankhani chinthu chotsiriza m'ndandanda: "Gwiritsani ntchito ndondomeko kuti mudziwe maselo opangidwa". Kumunda "Mafomu apangidwe omwe mayendedwe otsatirawa ndi oona" tchulani adiresi ya selo yogwirizana (izi zikhoza kuchitidwa mwadongosolo kapena mwasankha izo), ndipo zitatha mgwirizano zikupezeka mu mzere, ife tikuwonjezera mawu "= TRUE". Kuti muike mtundu wosankha, dinani pa batani. "Format ...".
- Zenera la mawonekedwe la selo limatsegula. Sankhani mtundu umene mungafune kuti mudzaze selo mukakankhira. Timakanikiza batani "Chabwino".
- Kubwerera ku ulamuliro kulenga zenera, dinani pa batani. "Chabwino".
Tsopano, pamene nkhupaku idafika, selo yothandizidwa idzajambula mu mtundu wosankhidwa.
Ngati chekeni chikuchotsedwa, selo lidzasanduka loyera.
Phunziro: Mafomu omvera mu Excel
Njira 5: Yambani kugwiritsa ntchito zida za ActiveX
Chongani chingathe kukhazikitsidwa pogwiritsa ntchito zida za ActiveX. Mbali iyi imapezeka pokhapokha kupyolera pamasewera omanga. Choncho, ngati tabu ilibe mphamvu, ndiye kuti iyenera kutsegulidwa, monga tafotokozera pamwambapa.
- Pitani ku tabu "Wotsambitsa". Dinani pa batani Sakanizaniyomwe imayikidwa mu gulu la zida "Controls". Muzenera lotseguka mu block "ActiveX Elements" sankhani chinthu Checkbox.
- Mofanana ndi nthawi yapitayi, thumbalo limatenga mawonekedwe apadera. Timasankha malo omwe fomuyi iyenera kuikidwa.
- Kuyika chongani mu bokosi loyenera kuti mulowetse katundu wa chinthu ichi. Timakanikiza ndi batani lamanja la mbewa ndipo mumasamba otsegulidwa sankhani chinthucho "Zolemba".
- Muzenera zenera zomwe zatsegula, yang'anani payeso. "Phindu". Icho chiri pansi. Mosiyana naye timasintha mtengo ndi "Zonyenga" on "Zoona". Timachita izi mwa kungolemba malemba kuchokera pa kambokosi. Pambuyo pa ntchitoyo, yang'anizani zenera podutsa pa batani loyandikira pafupi ndi mawonekedwe oyera a mtanda woyera mu khungu lofiira kumbali yakumanja yawindo.
Mutatha kuchita izi, bokosili lidzayang'aniridwa.
Kulemba pogwiritsa ntchito mphamvu za ActiveX ndizotheka kugwiritsa ntchito zida za VBA, ndiko kulemba macros. Zoonadi, izi ndi zovuta kwambiri kuposa kugwiritsa ntchito zipangizo zolemba zovomerezeka. Kuphunzira nkhaniyi ndi nkhani yaikulu yosiyana. Ma macros akhoza kulembedwa ntchito zenizeni kokha ndi ogwiritsa ntchito podziwa mapulogalamu komanso kukhala ndi luso logwira ntchito ku Excel kuposa apakati.
Kuti mupite ku mkonzi wa VBA, zomwe mungathe kulembera zambiri, muyenera kutsegula pa chinthucho, kwa ife, bokosi lokhala ndi batani lamanzere. Pambuyo pake, fayilo yowonjezera idzayambitsidwa kumene mungathe kulembera kalata ya ntchitoyo.
Phunziro: Momwe mungapangire macro ku Excel
Monga momwe mukuonera, pali njira zingapo zomwe mungayankhire pa Excel. Njira yomwe mungasankhe ikudalira makamaka cholinga cha kukhazikitsa. Ngati mukufuna kungolemba chinthu, ndiye kuti palibe chifukwa chochita ntchitoyo kudzera mumasewera osungirako zinthu, chifukwa zimatenga nthawi yambiri. Zimakhala zosavuta kugwiritsa ntchito chilembo kapena kutchula kalata yachingerezi "v" pa kibokosi mmalo mwa chitsimikizo. Ngati mukufuna kugwiritsa ntchito Chongerezi kuti mukonze zochitika zina pa pepala, ndiye kuti cholinga ichi chikhoza kuperekedwa kokha pothandizidwa ndi zipangizo zomangamanga.
