Ungalifaka kanjani ibhokisi lokuhlola kusipredishithi se-Excel

Ku-Microsoft Office Excel, ungafaka ibhokisi lokuhlola kunoma iyiphi iseli yetafula. Lolu uphawu oluthile ngendlela yophawu lokuhlola, oluklanyelwe ukuhlobisa noma iyiphi ingxenye yombhalo, ukugqamisa izici ezibalulekile, nokuqalisa imibhalo. Lesi sihloko sizoxoxa ngezindlela zokusetha uphawu ku-Excel usebenzisa amathuluzi akhelwe ohlelweni.

Indlela yokuhlola ibhokisi

Ukuhlola ibhokisi ku-Excel kulula ngokwanele. Ngalesi sithonjana, ukubonakala nobuhle bedokhumenti kuzokhula. Okuningi ngakho kuzoxoxwa ngakho kamuva.

Indlela 1: Sebenzisa Izimpawu Ezijwayelekile ze-Microsoft Excel

I-Excel, njenge-Word, inomtapo wayo wezincwadi wezimpawu ezihlukahlukene ezingafakwa noma yikuphi ku-worksheet. Ukuze uthole isithonjana somaka bese usibeka kuseli, udinga ukulandela lezi zinyathelo:

• Khetha iseli lapho ofuna ukubeka khona ibhokisi lokuhlola.
• Hambisa engxenyeni ethi "Faka" phezulu kumenyu enkulu.
• Chofoza inkinobho ethi "Izimpawu" ekugcineni kohlu lwamathuluzi.
• Ewindini elivulayo, chofoza inketho ethi "Symbol" futhi. Kuzovuleka imenyu yezithonjana ezakhelwe ngaphakathi.

• Esigabeni esithi “Setha”, cacisa inketho ethi “Izinhlamvu zokushintsha izikhala”, thola uphawu lokuhlola ohlwini lwamapharamitha ethulwe, lukhethe nge-LMB bese uchofoza igama elithi “Faka” ezansi kwewindi.

• Qiniseka ukuthi ibhokisi lokuhlola lifakwe kuseli elilungile.

Nakani! Kunezinhlobo ezimbalwa zamabhokisi okuhlola kukhathalogi yezimpawu. Isithonjana sikhethwa ngokubona komsebenzisi.

Indlela 2. Ukushintsha izinhlamvu

Izinyathelo ezingenhla zingokuzithandela. Uphawu lwebhokisi lokuhlola lungafakwa ngesandla lusuka kukhibhodi yekhompuyutha ngokushintsha isakhiwo saso siye kumodi yesiNgisi bese ucindezela inkinobho ethi “V”.

Indlela 3. Ukuhlola ibhokisi ukuze uvule ibhokisi lokuhlola

Ngokumaka noma ngokungahloli ibhokisi lokuhlola ku-Excel, ungasebenzisa imibhalo ehlukahlukene. Okokuqala udinga ukubeka ibhokisi lokuhlola ekhasini lokusebenza ngokuvula imodi yonjiniyela. Ukuze ufake lesi sakhi, udinga ukwenza lokhu okulandelayo:

• Chofoza igama elithi “Ifayela” ekhoneni eliphezulu kwesokunxele kwesikrini.
• Yiya engxenyeni ethi “Izilungiselelo”.

• Ewindini elilandelayo, khetha isigatshana esithi "Iribhoni Ngokwezifiso" ngakwesokunxele kwesikrini.
• Kukholomu ethi “Amathebhu amakhulu” ohlwini, thola umugqa othi “Unjiniyela” bese uqoka ibhokisi eliseduze nale nketho, bese uchofoza okuthi “KULUNGILE” ukuze uvale iwindi.

• Manje, ohlwini lwamathuluzi phezulu kumenyu enkulu yohlelo, kuzovela ithebhu ethi “Unjiniyela”. Udinga ukungena kukho.
• Kubhulokhi yokusebenza yethuluzi, chofoza inkinobho ethi "Faka" futhi kukholamu ethi "Izilawuli" yefomu, chofoza isithonjana sebhokisi lokuhlola.

• Ngemva kokuqeda izinyathelo zangaphambilini, esikhundleni sekhesa yegundane evamile, isithonjana esisesimweni sesiphambano sizoboniswa. Kulesi sigaba, umsebenzisi udinga ukuchofoza i-LMB endaweni lapho ifomu lizofakwa khona.
• Qiniseka ukuthi isikwele esingenalutho siyavela kuseli ngemva kokuchofoza.
• Chofoza i-LMB kulesi sikwele, futhi kuzobekwa ifulegi kuso.

• Eduze kwebhokisi lokuhlola kuseli kuzoba nombhalo ojwayelekile. Uzodinga ukuyikhetha bese ucindezela inkinobho ethi "Susa" kukhibhodi ukuze uyisuse.

Kubalulekile! Umbhalo ojwayelekile obekwe eduze kophawu olufakiwe ungangenelwa esikhundleni nganoma yimuphi omunye ngokubona komsebenzisi.

Indlela 4. Ulenza kanjani ibhokisi lokuhlola ukuze kusetshenziswe imibhalo

Ibhokisi lokuhlola elisethwe kuseli lingasetshenziswa ukwenza isenzo. Labo. ekhasini lokusebenza, etafuleni, izinguquko zizokwenziwa ngemva kokuhlola noma ukungahloli ibhokisi. Ukuze wenze lokhu kwenzeke, udinga:

• Landela izinyathelo ezisesigabeni esidlule ukuze umake isithonjana kuseli.
• Chofoza i-LMB entweni efakiwe bese uya kumenyu ethi “Fometha Into”.

• Kuthebhu ethi “Lawula” kukholamu ethi “Value”, faka iswishi yokuguqula ephambene nomugqa obonisa isimo samanje sebhokisi lokuhlola. Labo. kungaba kunkambu ethi "Kufakiwe" noma kulayini "Kususiwe".
• Chofoza inkinobho ethi Isixhumanisi Seseli ezansi efasiteleni.

• Cacisa iseli lapho umsebenzisi ahlela ukusebenzisa khona izikripthi ngokuguqula ibhokisi lokuhlola bese ngokuchofoza isithonjana esifanayo futhi.

• Kumenyu Yento Yefomethi, chofoza okuthi KULUNGILE ukuze usebenzise izinguquko zakho.

• Manje, ngemva kokuhlola ibhokisi, igama elithi “TRUE” lizobhalwa esitokisini esikhethiwe, futhi ngemva kokukhipha inani elithi “FALSE”.

• Noma yisiphi isenzo singanamathiselwa kuleli seli, isibonelo, ukushintsha umbala.

Ulwazi Olwengeziwe! Ukuhlanganisa imibala kwenziwa kumenyu ethi “Fometha Amaseli” kuthebhu ethi “Gcwalisa”.

Indlela 5. Ukufaka ibhokisi lokuhlola usebenzisa amathuluzi e-ActiveX

Le ndlela ingasetshenziswa ngemva kokuvula imodi yonjiniyela. Ngokuvamile, i-algorithm yokwenza umsebenzi ingancishiswa ngale ndlela elandelayo:

• Yenza kusebenze imodi kanjiniyela njengoba kuchazwe ngenhla. Kwanikezwa iziqondiso ezinemininingwane lapho kucatshangelwa indlela yesithathu yokufaka ifulege. Akusizi ukuphinda.
• Chofoza kwesokudla kuseli elinesikwele esingenalutho kanye nombhalo ojwayelekile ozovela ngemva kokufaka imodi "Yonjiniyela".
• Khetha "Izakhiwo" kumenyu yokuqukethwe.

• Kuzovuleka iwindi elisha, ohlwini lwamapharamitha ozodinga ukuthola umugqa othi “Value” bese ufaka igama elithi “Qiniso” esikhundleni sokuthi “Amanga”.

• Vala iwindi bese uhlola umphumela. Umaki wokuhlola kufanele uvele ebhokisini.

Isiphetho

Ngakho, ku-Excel, ibhokisi lokuhlola lingasethwa ngezindlela ezihlukahlukene. Ukukhethwa kwendlela yokufaka kuncike ezinhlosweni ezilandelwa umsebenzisi. Ukumane umake lokhu noma leyo nto kuthebhulethi, kwanele ukusebenzisa indlela yokushintsha uphawu.