Maitiro ekumaka bhokisi muExcel

Kazhinji, kana uchishanda nemagwaro espredishiti, zvinova zvakafanira kuseta chiratidzo mune imwe nzvimbo munzvimbo yebasa. Iyi nzira inoitwa nekuda kwezvinangwa zvakasiyana: kusarudzwa kwechero ruzivo, kuiswa kwemamwe mabasa, zvichingodaro. Muchinyorwa tichakurukura zvakadzama nzira dzinoverengeka dzekuita ichi chiito.

Kuseta bhokisi rekutarisa mugwaro respredishiti

Pane nzira dzakawanda dzinokutendera kuti uise bhokisi rekutarisa mugwaro respredishiti. Usati waseta bhokisi rekutarisa pacharo, unofanirwa kusarudza kuti ndezvipi zvinangwa zvecheki zvichashandiswa.

Method One: Kuwedzera Checkmark Uchishandisa Symbol Tool

Kana mushandisi achida kushandisa bhokisi rekutarisa kumaka rumwe ruzivo, anogona kushandisa bhatani rekuti "Simbol" riri pamusoro pepepeti yespredishiti. Detailed mirairo inoita seizvi:

1. Fambisa chinongedzo kunzvimbo yaunoda uye tinya pairi nebhatani rekuruboshwe. Isu tinotamira kune "Insert" chikamu. Isu tinowana block yemirairo "Symbols" uye tinya pane chinhu "Symbol" LMB.

2. Hwindi rine zita rekuti "Simbol" rakaonekwa pachiratidziro. Heino runyoro rwezvishandiso zvakasiyana-siyana. Tinoda chikamu che "Symbol". Wedzera runyoro padivi pechinyorwa "Font:" uye sarudza iyo yakakodzera font. Wedzera runyoro padhuze nerunyoro "Set:" uye sarudza chinhu "Matsamba ekuchinja nzvimbo" uchishandisa bhatani rekuruboshwe. Pano tinowana chiratidzo chokuti “˅”. Tinosarudza chiratidzo ichi. Padanho rekupedzisira, tinya kuruboshwe bhatani rekuti "Isa" riri pazasi pehwindo re "Symbol".

3. Ready! Isu tawedzera cheki cheki kunzvimbo yakafanosarudzwa.

Nenzira yakafanana, iwe unogona kuita kuwedzera kwemamwe macheki ane akasiyana maumbirwo. Kutsvaga mamwe zvikwekwe kuri nyore kwazvo. Kuti uite izvi, vhura runyorwa padivi pechinyorwa "Font:" uye sarudza iyo Wingdings font. Mhando dzakasiyana-siyana dzezviratidzo zvichaonekwa pachiratidziri. Isu tinodzika kuzasi chaiko uye tinowana akati wandei akasiyana jackdaws. Sarudza chimwe chazvo, wobva wadzvanya bhatani rekuruboshwe mbeva "Namira".

Cheki cheki chakasarudzwa chawedzerwa panzvimbo yakasarudzwa kare.

Nzira yechipiri: kutsiva mavara mupepeti yespredishiti

Kune vamwe vashandisi, hazvina basa zvachose kuti gwaro rinoshandisa cheki chaiyo kana chiratidzo chakafanana nacho chinoshandiswa pachinzvimbo. Panzvimbo pekuwedzera daw nguva dzose kunzvimbo yekushanda, vanoisa tsamba "v", iri pamutauro weChirungu keyboard. Izvi zviri nyore kwazvo, sezvo nzira iyi yekuseta bhokisi inotora nguva shoma. Nechekunze, kuchinja kwakadaro kwechiratidzo kwakaoma kuona.

Yetatu Nzira: Kuwedzera Cheki bhokisi kune Checkbox

Kumhanyisa mamwe magwaro mugwaro respredishiti uchishandisa cheki, maitiro akaomarara anoshandiswa. Pakutanga, unofanira kuisa cheki bhokisi. Kuti uwedzere chinhu ichi, unofanirwa kumisa menyu yekuvandudza. Detailed mirairo inoita seizvi:

1. Enda kune "Faira" chinhu. Dzvanya pane "Settings" chinhu chiri pazasi kuruboshwe rwehwindo.

2. Hwindo rakaonekwa pachiratidziro chinonzi "Excel Option". Isu tinotamira kune chikamu che "Ribbon marongero" Kurudyi rwehwindo, isa cheki padivi pechinyorwa "Developer". Mushure mekupedza maitiro ese, tinya kuruboshwe mbeva bhatani pa "OK".
3. Ready! Paribhoni yezvishandiso, chikamu chinonzi "Developer" chakaitwa.

4. Isu tinotamira kune yakaonekwa chikamu "Developer". Muchivharo chemirairo "Controls" tinowana bhatani "Insert" uye tinya pairi nebhatani rekuruboshwe. Rondedzero diki yemifananidzo yaratidzwa. Isu tinowana block "Form Controls" uye sarudza chinhu chinonzi "Checkbox".

5. Yedu pointer yatora chimiro chediki plus chiratidzo chemumvuri wakasviba. Isu tinodzvanya iyi plus sign panzvimbo yepepa rebasa ratinoda kuwedzera fomu.

6. Bhokisi rekutarisa risina chinhu rakaonekwa panzvimbo yekushanda.

7. Kuti uise cheki mukati mebhokisi, unongoda kudzvanya bhatani rekuruboshwe pachinhu ichi.

8. Zvinoitika kuti mushandisi anoda kubvisa zvinyorwa zviri pedyo nebhokisi rekutarisa. Nekumisikidza, ichi chinyorwa chinotaridzika senge: "Mureza_mureza nhamba". Kuti uite kudzima, tinya-kuruboshwe pane chinhu, sarudza zvinyorwa zvisingakoshi, wobva wadzvanya "Delete". Panzvimbo pechinyorwa chakadzimwa, unogona kuwedzera chimwe kana kusiya nzvimbo ino isina chinhu.

9. Pane dzimwe nguva apo, kana uchishanda negwaro respredishiti, zvakakosha kuwedzera mabhokisi akawanda ekutarisa. Haufanire kuwedzera bhokisi rako rekutarisa pamutsetse wega wega. Sarudzo yakanakisa ndeyekukopa rakapedzwa cheki bhokisi. Isu tinosarudza bhokisi rekutarisa rakapedzwa, uyezve, tichishandisa bhatani rekuruboshwe, tinokwevera chinhu pasi kumunda waunoda. Pasina kusunungura bhatani rembeva, bata pasi "Ctrl", wobva wasunungura mbeva. Isu tinoshandisa maitiro akafanana nemamwe maseru atinoda kuwedzera cheki.

Yechina Nzira: Kuwedzera Bhokisi reKuongorora kuti Uite Script

Mabhokisi ekutarisa anogona kuwedzerwa kuti avhure akasiyana siyana. Detailed mirairo inoita seizvi:

1. Isu tinoshandisa kugadzira bhokisi rekutarisa tichishandisa mirairo iri pamusoro.
2. Isu tinodaidza menyu yemukati uye tinya pane chinhu "Format Object ...".

3. Muhwindo rinoonekwa, enda kune "Control" chikamu. Isu tinoisa chiratidzo padivi pechinyorwa "chakaiswa". Isu tinodzvanya LMB pane icon iri padivi pechinyorwa "Kubatana nesero."

4. Isu tinosarudza sero pane pepa rebasa ratinoronga kubatanidza bhokisi nebhokisi. Mushure mekuita sarudzo, tinya bhatani muchimiro chechiratidzo.

5. Muhwindo rinoonekwa, tinya pane "OK" chinhu.

6. Ready! Kana pane cheki mubhokisi, ipapo kukosha kwe "CHOKWADI" kunoratidzwa musero rakabatana. Kana bhokisi rekutarisa risina kuvharwa, ipapo kukosha kwe "FALSE" kucharatidzwa muchitokisi.

Yechishanu Nzira: Kushandisa ActiveX Zvishandiso

Detailed mirairo inoita seizvi:

1. Isu tinotamira kuchikamu che "Developer". Muchivharo chemirairo "Controls" tinowana bhatani "Insert" uye tinya pairi nebhatani rekuruboshwe. Rondedzero diki yemifananidzo yaratidzwa. Isu tinowana block "ActiveX Controls" uye sarudza chinhu chinonzi "Checkbox".

2. Yedu pointer yatora chimiro chediki plus chiratidzo chemumvuri wakasviba. Isu tinodzvanya iyi plus sign panzvimbo yepepa rebasa ratinoda kuwedzera fomu.

3. Dzvanya paRMB cheki bhokisi uye sarudza iyo "Properties" chinhu.

4. Isu tinowana iyo parameter "Value". Chinja chiratidzo "Nhema" kuita "Chokwadi". Dzvanya pamuchinjikwa kumusoro kwehwindo.

5. Ready! Bhokisi rekutarisa rawedzerwa kubhokisi rekutarisa.

mhedziso

Takaona kuti kune nzira dzakawanda dzekushandisa kuwedzera cheki kunzvimbo yekushanda yegwaro respredishiti. Mumwe nemumwe mushandisi achakwanisa kuzvisarudzira nzira iri nyore kwaari. Izvo zvese zvinoenderana nezvinangwa uye zvinangwa zvinotevedzwa nemushandisi kana uchishanda mupepeti yespredishiti.