Mu pulogalamu ya Microsoft, wogwiritsa ntchito nthawi zina amafunika kuyika nkhupakupa kapena, monga ina imatchedwa chinthu, bokosi loyang'ana (˅). Izi zitha kuchitidwa pazolinga zosiyanasiyana: kungolemba chizindikiro cha chinthu china, kuphatikiza malo osiyanasiyana, etc. Tiyeni tiwone momwe mungakhazikitsireni fupa.
Kukhazikitsa mbendera
Pali njira zingapo zoyika nkhupakupa. Kuti mudziwe njira inayake, muyenera kukhazikitsa nthawi yomweyo, komwe muyenera kukhazikitsa bokosi la cheke: kungolembera kapena kulinganiza njira zina komanso zochitika zina?Phunziro: Momwe mungavalireni Mafunso mu Microsoft Mawu
Njira 1: Ikani kudzera mu menyu "
Ngati mukufuna kukhazikitsa zojambula pa zojambula zokha kuti mulembe chinthu china, mutha kugwiritsa ntchito batani la "chizindikiro" chomwe chili pa tepi.
- Ikani chotemberedwe m'chipinda chomwe chizindikiro chiyenera kupezeka. Pitani ku "kuyika" tabu. Dinani pa batani la "chizindikiro", chomwe chili mu "zizindikilo".
- Zenera limatseguka ndi mndandanda waukulu wa zinthu zosiyanasiyana. Sitipita kulikonse, koma khalanibe mu "zifaniziro". Mu gawo la Font, chilichonse cha mafayilo wamba chingafotokozeredwe: Arial, Verdana, nthawi yatsopano yachifumu, etc. Kuti mufufuze kaye chizindikiro chomwe mukufuna mu "seti" ya "Ikani" zilembo za kusintha kwa kusiyana ". Tikufuna chizindikiro "˅". Tikutsindika ndikudina batani la "phala".
Pambuyo pake, chinthu chosankhidwa chidzawonekera mu selo lotchulidwa.
Momwemonso, mutha kuyika chithunzi chodziwika bwino ndi mbali zosanja kapena chizindikiro cha chexbox (mtunda waung'ono, womwe umapangidwa mwapadera kuyika mbendera). Koma chifukwa cha izi, muyenera kutchula gawo la "Font" m'malo mwa njira zowerengera mapiko. Kenako muyenera kugwa pansi pamndandanda wa zilembo ndikusankha chizindikiro chomwe mukufuna. Pambuyo pake, timadina batani la "phala".
Chizindikiro chosankhidwa chimayikidwa mu khungu.
Njira 2:
Palinso ogwiritsa ntchito omwe sanatchulidwe ndi kufanana kwa anthu. Chifukwa chake, m'malo mokhazikitsa chizindikiro cha cheke, "v" mu kalembedwe kolankhula Chingerezi kumangosindikizidwa kuchokera pa kiyibodi. Nthawi zina zimakhala zomveka, chifukwa njirayi imatenga nthawi yochepa kwambiri. Kunja, izi sizowoneka.
Njira 3: Kukhazikitsa Kupukusa mu Chekbox
Koma pofuna kuti kukhazikitsa kapena kuchotsa nkhuni kumayambitsa zochitika zina, muyenera kuchita zovuta kwambiri. Choyamba, bokosi loyang'ana liyenera kukhazikitsidwa. Ichi ndi gawo laling'ono lotere pomwe bokosi la cheke limakhazikitsidwa. Kuti muike chinthu ichi, muyenera kuthandizira menyu wopanga maluso, omwe amayatsidwa ndi osakhazikika.
- Kukhala mu "Fayilo" tabu, dinani pa "magawo", omwe ali kumanzere kwa zenera lapano.
- Zenera la paramu limayamba. Pitani ku gawo la "tepi". Mu gawo loyenera la zenera, timakhazikitsa Mafunso (ndizotsimikizika kuti tikufunika kukhazikitsa papepala) moyang'anizana ndi "wopanga". Pansi pazenera Dinani pa batani la "Ok". Pambuyo pake, tabu yopanga mapulogalamu adzaonekera pa tepi.
- Pitani kwa tabu yatsopano yopanga "wopanga". Mu "zowongolera" chida pa nthiti yomwe timadina batani la "phala". Pa mndandanda womwe umatsegulira mbali za "Fomu Yoyang'anira Masewera", sankhani "Checkbox".
- Pambuyo pake, matembero amatembenukira pamtanda. Dinani iwo malo omwe ali pa pepala lomwe mungafune kuyika fomu.
Chekbox Boxbox imawonekera.
- Kukhazikitsa mkati mwake, muyenera kungodina chinthu ichi ndi bokosi lofufuzira liziikidwa.
- Pofuna kuchotsa zolembedwa muyezo, zomwe nthawi zambiri sizikufunika podina batani lakumanzere pa chinthucho, sankhani zolembedwazo ndikusindikiza batani la Delete. M'malo mwa zolembedwa zakutali, mutha kuyika wina, ndipo simungathe kuyika chilichonse, kusiya chekho popanda dzina. Izi zili mwakufuna kwa wogwiritsa ntchito.
- Ngati pali kufunika kopanga mabokosi angapo, ndiye kuti simungathe kupanga osiyana gawo lililonse, koma kuti mukonzekere kukonzekera, zomwe zimasunga nthawi. Kuti tichite izi, timamasula fomu yachikazi ya mbewa, kenako imachulukitsa batani lamanzere ndikukoka fomuyo ku khungu lomwe mukufuna. Osataya batani la mbewa, wepeni kiyi ya ctrl, kenako ndikumasula batani la mbewa. Tikukumana ndi zomwezi ndi maselo ena omwe muyenera kuyiyika.
Njira 4: Kupanga Chekbox kuti muchite zolemba
Pamwambapa taphunzira kuyika nkhuni mu khungu m'njira zosiyanasiyana. Koma izi sizingagwiritsidwe ntchito osati zongowoneka zowoneka, komanso kuthana ndi ntchito zina. Mutha kukhazikitsa zosankha zingapo posintha bokosi la chekbox. Tidzakambirana momwe zimagwirira ntchito posintha mtundu wa khungu.
- Pangani bokosi la cheke mu algorithm yofotokozedwa mu njira yapitayi pogwiritsa ntchito tabu ya wopanga.
- Dinani pa chinthu cholondola. Muzosankha zankhani, sankhani chinthu "cha chinthucho ...".
- Zenera lotseguka limatsegulidwa. Pitani ku "kuwongolera" tabu, ngati itatsegulidwa kwina. Mu "mtengo", dziko lapano liyenera kufotokozedwa. Ndiye kuti, ngati bokosi la chekeyo lakhazikitsidwa pano, kusinthana kuyenera kuyimilira pamalo a "seti", ngati sichoncho, pamalo oti "kuchotsedwa". Malo "osakanikirana" osavomerezeka. Pambuyo pake, timadina pachizindikiro pafupi ndi gawo la "Kulankhulana Ndi Cell".
- Windo losanjidwa limapindidwa, ndipo tiyenera kutsitsa khungu papepala lomwe lili ndi cheke ndi chizindikiro. Pambuyo kusankha kupangika, kukonzanso batani lomwelo ngati chithunzi, chomwe chinafotokozedwa pamwambapa kuti chibwerere ku zenera.
- Muzenera, dinani batani la "OK" kuti musunge zosintha.
Monga mukuwonera, nditatha kuchita izi mu cell yomwe ili ndi bokosilo pomwe bokosi la cheke, "chowonadi" chikuwonetsedwa. Ngati nkhupakupatulidwa, ndiye kuti phindu "lidzawonetsedwa. Kuti akwaniritse ntchito yathu, kusinthitsa mitundu ya kudzazidwa, mudzafunika kulumikiza mfundo izi mu cell yomwe ili ndi chochitika china.
- Timatsindika za cell ndikudina batani la mbewa kumanja, sankhani "Fomu Yachisoni ..." mu menyu wotseguka.
- Zenera lam'manja limatsegulidwa. Mu "nambala" tabu, timagawa "mafomu onse" mu "manambala a" magawo ". Munda "Mtundu", womwe uli gawo lalikulu la zenera, lolani izi popanda mawu: ";; Dinani batani la "Ok" pansi pazenera. Pambuyo pa izi, "chowonadi cholembedwa" cholembedwa "cha m'zilo zake chinasowa, koma mtengo wake udalibe.
- Timagawana khungu lolumikizidwa ndikupita ku tabu "kunyumba". Dinani pa batani la "Zolemba", zomwe zili mu "masitayilo" zida. Pamndandanda wodina pa chinthucho "Pangani lamulo ...".
- NJIRA YA DZIKO LAPANSI LOPHUNZITSIRA. Pamwamba muyenera kusankha mtundu wa ulamuliro. Sankhani mfundo zaposachedwa pamndandanda: "Gwiritsani ntchito njirayo kuti mudziwe maselo." Mu "mtundu womwe umakhala wotsatira" tchulani adilesi ya cell yolumikizidwa (izi zitha kuchitidwa ngati pamanja, ndikungogawika magwirizanowo, onjezerani mawuwo "= chowonadi" mkati mwake. Kukhazikitsa mtundu wosankha, dinani pa "mtundu ..." batani.
- Zenera lam'manja limatsegulidwa. Timasankha mtundu womwe ungakonde kutsanulira khungu pomwe nkhupakuka zimayatsidwa. Dinani pa batani la "OK".
- Kubwerera ku Pangani Malamulo a Pangani Malamulo, dinani pa batani la "Ok".
Tsopano, bokosi la chekeyo litayatsidwa, khungu lolumikizana lidzajambulidwa mu mtundu wosankhidwa.
Ngati bokosilo latsukidwa, khungu limakhalanso loyera.
Phunziro: Mawonekedwe oyenera ku Excel
Njira 5: Kuyika Mafunso Kugwiritsa Ntchito Zida Zakex
Mafunso amathanso kukhazikitsidwa pogwiritsa ntchito zida zothandizira. Izi zimapezeka pokhapokha kudzera mumenyu. Chifukwa chake, ngati tsambali silikuloledwa, liyenera kukhazikitsidwa, monga tafotokozera pamwambapa.
- Pitani ku tabu yopanga. Dinani pa batani la "Ikani", lomwe lalembedwa mu "zowongolera" chida. Pazenera lomwe limatsegulira muzomwe zimayambitsa, sankhani bokosilo.
- Monga kale, chotemberera chimatenga fomu yapadera. Timadina pa malo a pepalalo, komwe mawonekedwe ayenera kuyikidwapo.
- Kukhazikitsa chizindikiro cha chekbox, muyenera kulowa m'malo mwa chinthu ichi. Ndimadina pa batani la mbewa kumanja ndikusankha "katundu" mu menyu yotseguka.
- Pawindo lomwe limatseguka, njira yamtengo wapatali. Imayikidwa pansi. Moyang'anizana ndi kusintha mtengo ndi zabodza. Timachita, zizindikiro zongoyendetsedwa kuchokera pa kiyibodi. Ntchitoyo itatha, tsekani zenera lazinthu podina batani lotseka lotseka mu mawonekedwe oyera pamtunda wakona wam'mwamba pazenera.
Pambuyo pochita izi, bokosi la cheke mu bokosi la cheke liziikidwa.
Kuphedwa kwa zochitika pogwiritsa ntchito zinthu zothandizira kugwiritsidwa ntchito pogwiritsa ntchito zida za VBA, ndiye kuti, polemba macros. Zachidziwikire, ndizovuta kwambiri kuposa kugwiritsa ntchito zida zamakono. Kuphunzira za magaziniyi ndi mutu waukulu. Kulemba macros ku ntchito zapadera
Kupita ku mkonzi wa VBA, yemwe mungalembe macro, muyenera kudina chinthucho, monga bokosi la cheke, batani lakumanzere. Pambuyo pake, zenera la mkonzi lidzakhazikitsidwa, momwe mungalembere nambala ya ntchito yomwe ikuchitika.
Phunziro: Momwe Mungapangire Macro pa Excel
Monga mukuwonera, pali njira zingapo zokhazikitsira nkhuni. Ndi njira iti yomwe mungasankhire, yoyamba mwa zonse zimatengera zolinga za kuyika. Ngati mukufuna kungowerengera chinthu china, sichimamveka kuti muchite ntchito kudzera mumenyu ya preur, chifukwa zimatenga nthawi yambiri. Ndiosavuta kugwiritsa ntchito kulowetsa chizindikiro kapena zonse kungoyimba kalata ya Chingerezi "v" pa kiyibodi m'malo mwa nkhupakuya. Ngati mukufuna kulinganiza zolemba zina pogwiritsa ntchito chizindikiro, ndiye pankhaniyi yomwe cholinga ichi chitha kungogwiritsa ntchito zida zaluso.