Izindlela ezilula zokufaka ibhokisi lokuhlola ku-Excel

Kulesi sifundo ungathola izinyathelo zokungeza noma zokufaka ibhokisi likaqhwishi ku-Excel, ukuze ukwazi ukudala imihlahlandlela yokusebenzisana, umbiko wokuhlola noma irekhodi okufanele ukwenze.

Faka ibhokisi lokuhlola ku-Excel

Njengoba usubonile kakade ezinhlotsheni eziku-inthanethi, ibhokisi lokuhlola elibizwa nangokuthi “Thikha Inkambu” liyisikwele esincane. field okusho ukuthi ungakhetha noma ungakhethi inketho ngokuchofoza kuyo.

Ngokuchofoza ibhokisi lokuhlola faka uphawu lokuhlola ebhokisini lokuhlola, okubonisa ukuthi inketho ikhethiwe.

Uma kwenzeka uchofoza ibhokisi lokuhlola ngephutha, chofoza ibhokisi lokuhlola elifanayo futhi futhi lizosusa ukukhetha futhi umaki wokuhlola kufanele ube kude nebhokisi lokuhlola.

Izindlela ezilula zokufaka ibhokisi lokuhlola ku-Excel

Nakuba ukufaka ibhokisi lokuhlola ku-Excel kulula, amakhasimende amaningi anesikhathi esinzima sokufuna ithebhu efanelekile noma ukukhetha ukufaka ibhokisi lokuhlola ku-Excel.

Lokhu kwenzeka, njengomphumela wenketho ethi Faka ibhokisi likaqhwishi, i-Radio Field nezinye izinsimbi ezisebenzisanayo kuhlala ngaphakathi kwethebhu kanjiniyela, enganikwa amandla ngokuzenzakalelayo ku-Excel.

Ngakho-ke, isinyathelo sokuqala singaba esokwengeza ithebhu kanjiniyela kumenyu yeribhoni ku-Excel.

1. Engeza Ithebhu Yonjiniyela kuMenu yeRibhoni ku-Excel

Indlela esheshayo yokwengeza ithebhu yonjiniyela kumenyu yeRibhoni ku-Excel ukuchofoza kwesokudla endlini engenalutho kumenyu yeribhoni bese uchofoza kunketho ethi Yenza ngokwezifiso iRibhoni….

Esibukweni esilandelayo, hlola insimu encane eseduze no -Developer bese uchofoza ku- Kulungile.

Uma lokhu kungasebenzi, ungalwela noma yimaphi amasu alandelayo afanele imodeli ye-Microsoft Excel oyisebenzisayo kukhompuyutha yakho ephathekayo.

1. I-Excel 2010 nakamuva: Chofoza ku- Ifayela > Ukuzikhethela > Iribhoni ngokwezifiso > hlola Ukukhetha konjiniyela bese uchofoza ku OK.
2. I-Excel 2007 nangaphambilini: Chofoza ku- Inkinobho Yendawo Yokusebenzela ye-Microsoft > Izinketho ze-Excel > Ngesitayela > Yethula Ithebhu Yonjiniyela ngaphakathi kweRibhoni.
3. I-Excel ivuliwe Mac: Chofoza kokuthi Yenza ngokwezifiso ibha yedivayisi Umcibisholo Ophansi Bese ukhetha Imiyalo Eyengeziwe. Esibonisini Semiyalelo Eyengeziwe, chofoza ku- Ribbon ithebhu bese uhlola i Unjiniyela ukukhetha.

2. Engeza ibhokisi lokuhlola kumaseli ku-Excel

Ngokushesha nje lapho ithebhu kanjiniyela isinikwe amandla ngaphakathi kwemenyu yeribhoni, usuyakwazi ukufaka amabhokisi okuhlola kunoma yimaphi Amaseli encwadini yakho yokusebenzela ye-Excel.

Ngaphambi kokufaka ibhokisi lokuhlola, qiniseka ukuthi uyahlanganisa futhi uphothula irekhodi lezinto ohlwini lwakho lokuhlola. Ngokushesha nje lapho uhlu lokuhlola selulungisiwe, ungakwazi ukubona izinyathelo Zokufaka Ibhokisi Lokuhlola ku-Excel.

1. Ukuze ufake ibhokisi lokuhlola ku-Excel, chofoza kuthebhu ethi Unjiniyela bese ukhetha inketho ethi Qinisekisa Insimu.

2. Ngemuva kwalokho, chofoza ku- Iseli lapho ufuna ukufaka khona ibhokisi lokuhlola. Uma kudingeka, ungahudula ibhokisi lokuhlola uye endaweni yalo oyifunayo usebenzisa imicibisholo enamachopho amane (Bheka isithombe ngezansi).

3. Uma nje ibhokisi lokuhlola selibekwe kahle kuseli yalo, chofoza kwesokudla ku- Checkbox > chofoza ku -Edit Textual content bese uthayipha isihloko sebhokisi lokuhlola.

3. Kopisha ibhokisi lokuhlola kumaseli ahlukene

Ngemva kokufaka ibhokisi lokuhlola ngaphakathi kweseli yokuqala, ungakwazi ukukopisha futhi unamathisele ibhokisi lokuhlola elifanayo kuwo wonke amaseli adingekayo.

1. Chofoza ngakwesokudla ku- Checkbox > khetha Kopisha kumenyu yokuqukethwe.

2. Khetha Amaseli ofuna ukufaka kuwo ibhokisi lokuhlola, chofoza kwesokudla kumaseli akhethiwe bese ukhetha ukukhetha okuthi Namathisela ngaphakathi kwemenyu yokuqukethwe ebonakala.

Le mfashini ibhokisi lokuhlola elifanayo kanye nesihloko salo lizonamathiselwa kumaseli akhethiwe futhi akufanele udlule ezinyathelweni zokufaka ibhokisi lokuhlola.

4. I-Hyperlink Checkbox to Cell in Excel

Nakuba amabhokisi okuhlola efakiwe futhi uzokwazi Ukuwaqinisekisa Nokuyekisa ukumaka, uthole ukuthi awukwazi ukuncika ezimpendulweni noma usebenzise izimpendulo zamabhokisi ngendlela ye-Excel.

Ukuze ube nekhono Lokuncika noma lokusebenzisa izimpendulo zebhokisi lokuhlola ngendlela ye-Excel, kufanele uxhumanise amabhokisi okuhlola kumaseli abo omuntu othile.

1. Chofoza ngakwesokudla ku- Checkbox eyinhloko bese uchofoza ku -Format Management.

2. Ngaphakathi kwesibonisi se-Format Management, chofoza kuthebhu ye-Management > insimu ye-Cell Hyperlink > bese uchofoza ku- Cell ofuna ukuyixhumanisa nebhokisi lokuhlola bese uchofoza ku- OK.

3. Phinda lezi zinyathelo ezingenhla kuwo wonke amabhokisi okuhlola asele. Ngokudabukisayo, kuzodingeka ukwenze lokho Ngamunye Ngamunye.

4. Ngemva kokuxhumanisa wonke amabhokisi okuhlola, chofoza ku- Amabhokisi Okuhlola axhunyiwe futhi uzobona ukuthi “Iqiniso” livela ezitsheni zokupakisha ezihloliwe kanye nokuthi “Amanga” kumabhokisi okuhlola asuliwe.

5. Lapho nje amabhokisi okuhlola exhunywe kumaseli, kungenzeka ukuthi uthembele ezimpendulweni bese uzisebenzisa kunoma yiziphi izingxenye ze-Excel.

Njengoba ungase ubone kulesi sithombe esingenhla, manje sesibale izinhlobonhlobo zabafundi basekolishi Abamanje Nabangekho sisebenzisa i-COUNTIF.

• Izindlela ezilula zokusebenzisa i-Concatenate Perform ku-Excel
• Izindlela ezilula zokwengeza isiqalo noma isijobelelo ku-Excel