Ungawenza kanjani uhlu lokudonsela phansi ku-Excel. Ngemenyu yokuqukethwe kanye namathuluzi kanjiniyela

Abasebenzisi abaningi be-Excel, abavame ukusebenzisa lolu hlelo, basebenza nedatha eningi ehlala idinga ukufakwa izikhathi eziningi. Uhlu oluya phansi luzosiza ukwenza lula umsebenzi, okuzoqeda isidingo sokufakwa njalo kwedatha.

Dala uhlu lokudonsela phansi usebenzisa imenyu yokuqukethwe

Le ndlela ilula futhi ngemva kokufunda imiyalelo izocaca ngisho nakumuntu oqalayo.

1. Okokuqala udinga ukwenza uhlu oluhlukile kunoma iyiphi indawo yeshidi uXNUMXbuXNUMXb. Noma, uma ungafuni ukulahla idokhumenti ukuze ukwazi ukuyihlela kamuva, dala uhlu eshidini elihlukile.
2. Ngemva kokunquma imingcele yethebula lesikhashana, sifaka uhlu lwamagama omkhiqizo kulo. Iseli ngalinye kufanele libe negama elilodwa kuphela. Ngenxa yalokho, kufanele uthole uhlu olwenziwe kukholomu.
3. Ngemva kokukhetha ithebula elisizayo, chofoza kwesokudla kulo. Kumenyu yokuqukethwe evulayo, shona phansi, thola into ethi “Yabela igama…” bese uchofoza kuyo.

4. Iwindi kufanele livele lapho, ngokuphambene nento ethi "Igama", kufanele ufake igama lohlu oludaliwe. Lapho igama selifakiwe, chofoza inkinobho ethi "OK".

Kubalulekile! Lapho udala igama lohlu, udinga ukucabangela inani lezidingo: igama kufanele liqale ngohlamvu (isikhala, uphawu noma inombolo ayivunyelwe); uma amagama amaningana esetshenziswa egameni, akufanele kube nezikhala phakathi kwabo (njengomthetho, kusetshenziswa i-underscore). Kwezinye izimo, ukuze kube lula ukusesha okulandelayo kohlu oludingekayo, abasebenzisi bashiya amanothi entweni ethi “Qaphela”.

5. Khetha uhlu ofuna ukuluhlela. Phezulu kwebha yamathuluzi esigabeni esithi “Sebenza ngedatha”, chofoza into ethi “Ukuqinisekisa Idatha”.
6. Kumenyu evulayo, entweni ethi “Uhlobo Lwedatha”, chofoza okuthi “Uhlu”. Sehla bese sifaka uphawu "=" kanye negama elinikezwe ngaphambili ohlwini lwethu olusizayo ("Umkhiqizo"). Ungavuma ngokuchofoza inkinobho ethi "KULUNGILE".

5. Umsebenzi ungabhekwa njengoqediwe. Ngemva kokuchofoza kuseli ngalinye, isithonjana esikhethekile kufanele sivele ngakwesobunxele ngonxantathu oshunyekiwe, ikhoneni elilodwa elibheke phansi. Lena inkinobho ethi interactive, okuthi uma ichofozwa, ivule uhlu lwezinto ezihlanganiswe ngaphambilini. Kusele kuphela ukuchofoza ukuze uvule uhlu bese ufaka igama kuseli.

Iseluleko sochwepheshe! Ngenxa yale ndlela, ungakha lonke uhlu lwezimpahla ezitholakala endaweni yokugcina izinto futhi uzigcine. Uma kudingekile, kusala kuphela ukudala ithebula elisha lapho uzodinga ukufaka khona amagama okwamanje okudingeka abalwe ngawo noma ahlelwe.

Ukwakha Uhlu Ngokusebenzisa Amathuluzi Kanjiniyela

Indlela echazwe ngenhla ikude kakhulu nokuphela kwendlela yokudala uhlu lokudonsela phansi. Futhi ungaphendukela kusizo lwamathuluzi kanjiniyela ukuze uqedele lo msebenzi. Ngokungafani neyangaphambili, le ndlela iyinkimbinkimbi kakhulu, yingakho ingathandwa kakhulu, nakuba kwezinye izimo ibhekwa njengosizo olubalulekile oluvela ku-accountant.

Ukuze udale uhlu ngale ndlela, udinga ukubhekana nesethi enkulu yamathuluzi futhi wenze imisebenzi eminingi. Nakuba umphumela umangalisa kakhulu: kungenzeka ukuhlela ukubukeka, ukudala inombolo edingekayo yamaseli futhi usebenzise ezinye izici eziwusizo. Ake siqale:

1. Okokuqala udinga ukuxhuma amathuluzi kanjiniyela, njengoba kungenzeka angasebenzi ngokuzenzakalela.
2. Ukuze wenze lokhu, vula "Ifayela" bese ukhetha "Izinketho".

3. Iwindi lizovuleka, lapho ohlwini olungakwesokunxele sibheka "Yenza ngokwezifiso Iribhoni". Chofoza bese uvule imenyu.
4. Kukholomu engakwesokudla, udinga ukuthola into ethi "Unjiniyela" bese ubeka uphawu lokuhlola phambi kwalo, uma bekungekho. Ngemva kwalokho, amathuluzi kufanele engezwe ngokuzenzakalelayo kuphaneli.

5. Ukuze ulondoloze izilungiselelo, chofoza inkinobho ethi "KULUNGILE".
6. Ngokufika kwethebhu entsha ku-Excel, kunezici eziningi ezintsha. Yonke eminye imisebenzi izokwenziwa kusetshenziswa leli thuluzi.
7. Okulandelayo, sakha uhlu olunohlu lwamagama emikhiqizo oluzovela uma udinga ukuhlela ithebula elisha bese ufaka idatha kulo.

8. Yenza kusebenze ithuluzi lonjiniyela. Thola "Izilawuli" bese uchofoza "Namathisela". Uhlu lwezithonjana luzovuleka, ukuhamba phezu kwazo kuzobonisa imisebenzi eziyenzayo. Sithola i- "Combo Box", itholakala ku-block "ActiveX Controls", bese uchofoza isithonjana. "Imodi Yokudizayina" kufanele ivuleke.

9. Ngemva kokukhetha iseli eliphezulu etafuleni elilungisiwe, lapho uhlu luzobekwa khona, silwenza lusebenze ngokuchofoza i-LMB. Misa imingcele yayo.
10. Uhlu olukhethiwe luvula “Imodi Yokuklama”. Eduze ungathola inkinobho ethi "Properties". Kufanele inikwe amandla ukuze uqhubeke nokwenza uhlu ngendlela oyifisayo.
11. Izinketho zizovuleka. Sithola umugqa othi “ListFillRange” bese ufaka ikheli lohlu olusizayo.
12. Chofoza i-RMB kuseli, kumenyu evulayo, yehlela ku-“ComboBox Object” bese ukhetha “Hlela”.

9. Inhloso ifeziwe.

Qaphela! Ukuze uhlu lubonise amaseli amaningana anohlu lokudonsela phansi, kuyadingeka ukuthi indawo eseduze konqenqema lwesokunxele, lapho umaka wokukhetha ukhona, ihlale ivuliwe. Kulokhu kuphela lapho kungenzeka khona ukubamba umaka.

Ukudala uhlu oluxhunyiwe

Ungakwazi futhi ukudala uhlu oluxhunyiwe ukuze wenze umsebenzi wakho ube lula ku-Excel. Ake sithole ukuthi kuyini nokuthi singazenza kanjani ngendlela elula.

1. Sakha itafula elinohlu lwamagama emikhiqizo namayunithi awo okulinganisa (izinketho ezimbili). Ukuze wenze lokhu, udinga ukwenza okungenani amakholomu angu-3.

2. Okulandelayo, udinga ukulondoloza uhlu namagama emikhiqizo bese ulunika igama. Ukuze wenze lokhu, ngemva kokukhetha ikholomu ethi “Amagama”, chofoza kwesokudla bese uchofoza okuthi “Yabela igama.” Esimeni sethu, kuzoba “Imikhiqizo_Yokudla”.
3. Ngokufanayo, udinga ukukhiqiza uhlu lwamayunithi okulinganisa egameni ngalinye lomkhiqizo ngamunye. Siqedela lonke uhlu.

4. Yenza kusebenze iseli eliphezulu lohlu oluzayo kukholamu ethi “Amagama”.
5. Ngokusebenza ngedatha, chofoza ukuqinisekiswa kwedatha. Ewindini lokudonsela phansi, khetha "Uhlu" futhi ngezansi sibhala igama elinikeziwe le "Igama".
6. Ngendlela efanayo, chofoza iseli eliphezulu kumayunithi wokulinganisa bese uvula “Hlola Amanani Wokufaka”. Esigabeni esithi "Umthombo" sibhala ifomula: =I-INDIRECT(A2).
7. Okulandelayo, udinga ukusebenzisa ithokheni yokuqedela ngokuzenzakalela.
8. Ilungile! Ungaqala ukugcwalisa ithebula.

Isiphetho

Uhlu olwehliswayo ku-Excel luyindlela enhle yokwenza ukusebenza ngedatha kube lula. Ukujwayelana kokuqala nezindlela zokwenza uhlu lokudonsela phansi kungase kuphakamise inkimbinkimbi yenqubo eyenziwayo, kodwa akunjalo. Lokhu kuwukukhohlisa nje okunqotshwa kalula ngemva kwezinsuku ezimbalwa zokuzilolonga ngokulandela imiyalelo engenhla.