Ungamaka kanjani ibhokisi ku-Excel

Ngokuvamile, lapho usebenza ngamadokhumenti espredishithi, kuba nesidingo sokusetha umaki endaweni ethile endaweni yokusebenza. Le nqubo yenziwa ngezinhloso ezehlukene: ukukhethwa kwanoma yiluphi ulwazi, ukufakwa kwemisebenzi eyengeziwe, nokunye. Esihlokweni sizocubungula ngokuningiliziwe izindlela ezimbalwa zokwenza lesi senzo.

Ukusetha ibhokisi lokuhlola kudokhumenti yesipredishithi

Ziningi izindlela ezikuvumela ukuthi usebenzise ukulungiselelwa kwebhokisi lokuhlola kudokhumenti yesipredishithi. Ngaphambi kokusetha ibhokisi lokuhlola ngokwalo, udinga ukunquma ukuthi yiziphi izinjongo uphawu lokuhlola luzosetshenziswa.

Indlela Yokuqala: Ukwengeza umaki wokuhlola Ukusebenzisa Ithuluzi Lophawu

Uma umsebenzisi efuna ukusebenzisa ibhokisi lokuthikha ukuze amake ulwazi oluthile, angasebenzisa inkinobho ethi “Symbol” etholakala phezulu kusihleli sespredishithi. Imiyalelo enemininingwane ibukeka kanje:

1. Hambisa isikhombisi endaweni oyifunayo bese uchofoza kuso ngenkinobho yegundane lesokunxele. Sithuthela esigatshaneni esithi "Faka". Sithola ibhulokhi yemiyalo ethi "Izimpawu" bese uchofoza into ethi "Symbol" LMB.

2. Iwindi elinegama elithi "Symbol" livele esibukweni. Nalu uhlu lwamathuluzi ahlukahlukene. Sidinga isigatshana esithi "Symbol". Nweba uhlu eduze nombhalo othi “Ifonti:” bese ukhetha ifonti efanelekile. Nweba uhlu eduze nombhalo othi “Setha:” bese ukhetha into ethi “Izinhlamvu zokushintsha izikhala” usebenzisa inkinobho yegundane engakwesokunxele. Lapha sithola uphawu “˅”. Sikhetha lolu phawu. Esigabeni sokugcina, chofoza kwesokunxele inkinobho ethi "Faka" etholakala ezansi kwewindi elithi "Symbol".

3. Ilungile! Sengeze umaki wokuhlola endaweni ekhethwe ngaphambilini.

Ngendlela efanayo, ungasebenzisa ukungezwa kwamanye ama-checkmark anezinhlobonhlobo zomumo. Ukuthola eminye imikhaza kulula kakhulu. Ukuze wenze lokhu, vula uhlu oluseduze nombhalo othi "Ifonti:" bese ukhetha ifonti yeWingdings. Izinhlobonhlobo zezimpawu zizovela esibukweni. Sehlela phansi kakhulu futhi sithola ukuhlukahluka okuningana kwama-jackdaw. Khetha eyodwa yazo, bese uchofoza inkinobho yegundane kwesokunxele "Namathisela".

Uphawu lokuhlola olukhethiwe lwengezwe endaweni ekhethwe kusengaphambili.

Indlela yesibili: ukushintsha izinhlamvu kusihleli sespredishithi

Kwabanye abasebenzisi, akunandaba ukuthi idokhumenti isebenzisa uphawu lokuhlola langempela noma uphawu olufana nalo luyasetshenziswa esikhundleni salokho. Esikhundleni sokwengeza i-daw evamile endaweni yokusebenza, bafaka uhlamvu "v", olutholakala kuhlelo lwekhibhodi yesiNgisi. Lokhu kulula kakhulu, njengoba le ndlela yokusetha ibhokisi lokuhlola ithatha isikhathi esincane. Ngaphandle, ukuguqulwa okunjalo kwesibonakaliso kunzima kakhulu ukukubona.

Indlela Yesithathu: Ukwengeza Ibhokisi Lokuhlola Ebhokisini Lokuhlola

Ukuze usebenzise imibhalo ethile kudokhumenti yesipredishithi usebenzisa uphawu lokuhlola, kusetshenziswa izinqubo eziyinkimbinkimbi. Ekuqaleni, udinga ukufaka ibhokisi lokuhlola. Ukuze wengeze le nto, kufanele wenze kusebenze imenyu kanjiniyela. Imiyalelo enemininingwane ibukeka kanje:

1. Hambisa entweni ethi “Ifayela”. Chofoza into ethi “Izilungiselelo” etholakala ngezansi kwesokunxele sewindi.

2. Iwindi livele esibukweni elibizwa ngokuthi "Inketho ye-Excel". Sithuthela esigatshaneni esithi "Izilungiselelo zeRibhoni" ngakwesokudla kwefasitela, faka uphawu lokuhlola eduze nombhalo othi "Unjiniyela". Ngemva kokuqeda zonke izinqubo, chofoza inkinobho yegundane kwesokunxele "KULUNGILE".
3. Ilungile! Kuribhoni yamathuluzi, isigaba esibizwa ngokuthi “Unjiniyela” senziwe sasebenza.

4. Sithuthela esigabeni esivele "Unjiniyela". Ebhokisini lemiyalo ethi "Izilawuli" sithola inkinobho ethi "Faka" bese uchofoza kuyo ngenkinobho yegundane kwesokunxele. Uhlu oluncane lwezithonjana lwembuliwe. Sithola i-block "Izilawuli Zefomu" bese ukhetha into ebizwa ngokuthi "Ibhokisi Lokuhlola".

5. Isikhombi sethu sithathe isimo sophawu oluncane lokuhlanganisa lomthunzi omnyama. Sicindezela lolu phawu lokuhlanganisa endaweni yephepha lokusebenza lapho sifuna ukwengeza khona ifomu.

6. Kuvele ibhokisi lokuhlola elingenalutho endaweni yokusebenza.

7. Ukuze usethe uphawu lokuhlola ngaphakathi kwebhokisi lokuhlola, udinga nje ukuchofoza inkinobho yegundane engakwesokunxele kule nto.

8. Kuyenzeka ukuthi umsebenzisi asuse umbhalo oseduze nebhokisi lokuhlola. Ngokuzenzakalelayo, lo mbhalo ubukeka kanjena: “Ifulegi_lefulegi inombolo”. Ukuze usebenzise ukususa, chofoza kwesokunxele entweni, khetha umbhalo ongadingekile, bese uchofoza "Susa". Esikhundleni sombhalo osusiwe, ungakwazi ukwengeza okunye noma ushiye le ndawo ingenalutho.

9. Kunezikhathi lapho, lapho usebenza ngedokhumenti yesipredishithi, kuyadingeka ukwengeza amabhokisi okuhlola amaningi. Awudingi ukwengeza ibhokisi lakho lokuthikha kumugqa ngamunye. Inketho engcono kakhulu ukukopisha ibhokisi lokuhlola eliqediwe. Sikhetha ibhokisi lokuhlola eliqediwe, bese, sisebenzisa inkinobho yegundane engakwesokunxele, sihudula isici siye endaweni oyifunayo. Ngaphandle kokukhulula inkinobho yegundane, cindezela u-“Ctrl”, bese ukhulula igundane. Senza inqubo efanayo nawo wonke amaseli lapho sifuna ukwengeza uphawu lokuhlola.

Indlela Yesine: Ukwengeza Ibhokisi Lokuhlola ukuze Usebenze Isikripthi

Amabhokisi okuhlola angangezwa ukuze kusebenze izimo ezihlukahlukene. Imiyalelo enemininingwane ibukeka kanje:

1. Senza ukwakhiwa kwebhokisi lokuhlola sisebenzisa imiyalo engenhla.
2. Sibiza imenyu yokuqukethwe bese uchofoza into ethi "Fometha Into ...".

3. Ewindini elivelayo, hambisa esigatshaneni esithi "Lawula". Sibeka uphawu eduze kombhalo othi "ufakiwe". Sichofoza i-LMB kusithonjana esiseduze nombhalo othi "Ukuxhumana neseli."

4. Sikhetha iseli ekhasini lokusebenza esihlela ukuxhuma ngalo ibhokisi lokuhlola nebhokisi lokuhlola. Ngemva kokwenza ukukhetha, chofoza inkinobho ngendlela yesithonjana.

5. Ewindini elivelayo, chofoza into ethi "OK".

6. Ilungile! Uma kunophawu lokuhlola ebhokisini lokuhlola, inani elithi “TRUE” liboniswa kuseli elihlobene. Uma ibhokisi lokuhlola lingahloliwe, inani elithi "FALSE" lizoboniswa kuseli.

Indlela Yesihlanu: Ukusebenzisa Amathuluzi e-ActiveX

Imiyalelo enemininingwane ibukeka kanje:

1. Sithuthela esigabeni esithi "Unjiniyela". Ebhokisini lemiyalo ethi "Izilawuli" sithola inkinobho ethi "Faka" bese uchofoza kuyo ngenkinobho yegundane kwesokunxele. Uhlu oluncane lwezithonjana lwembuliwe. Sithola block "ActiveX Controls" bese ukhetha into ebizwa ngokuthi "Checkbox".

2. Isikhombi sethu sithathe isimo sophawu oluncane lokuhlanganisa lomthunzi omnyama. Sicindezela lolu phawu lokuhlanganisa endaweni yephepha lokusebenza lapho sifuna ukwengeza khona ifomu.

3. Chofoza kubhokisi lokuhlola le-RMB bese ukhetha into ethi "Properties".

4. Sithola ipharamitha "Value". Shintsha inkomba ethi “Amanga” ibe “Iqiniso”. Chofoza esiphambanweni phezulu efasiteleni.

5. Ilungile! Ibhokisi likaqhwishi lengeziwe ebhokisini lokuhlola.

Isiphetho

Sithole ukuthi ziningi izindlela zokufaka uphawu lokuhlola endaweni yokusebenza yedokhumenti yesipredishithi. Umsebenzisi ngamunye uzokwazi ukukhetha indlela elula kakhulu kuye. Konke kuncike ezinhlosweni nasezimpokophelweni ezilandelwa umsebenzisi lapho esebenza kumhleli wespredishithi.