Uma usebenza ku-Microsoft Excel kumathebula nge-duplicate data, kulula kakhulu ukusebenzisa uhlu lokudonsa phansi. Ngalo, ungamane ukhethe imingcele oyifunayo kwimenyu eyenziwe. Ake sithole indlela yokwenza uhlu lokudonsa ngezindlela ezehlukene.
Ukwakha uhlu olungeziwe
I-elula kakhulu, futhi ngesikhathi esifanayo indlela esebenzayo kakhulu yokwakha uhlu oludonsa phansi, indlela esekelwe ekwakheni uhlu oluhlukile lwemininingwane.
Okokuqala, senza itafula-elingenalutho, lapho sizosebenzisa imenyu yokudonsa, futhi wenze uhlu oluhlukile lwedatha oluzofakwa kulo menyu esikhathini esizayo. Le datha ingafakwa kokubili ephepheni elifanayo lwedokhumenti, futhi ngakolunye uhlangothi, uma ungafuni ukuthi amatafula womabili abekwa ngokubukeka ndawonye.
Khetha idatha esilungiselela ukungeza ohlwini lokudonsa phansi. Chofoza inkinobho yesokudla yegundane, futhi kwimenyu yokuqukethwe khetha into "Yika igama ...".
Ifomu lokudala igama livuleka. Emkhakheni "Igama" faka noma yiliphi igama elihle esizokwazi ngalo lolu hlu. Kodwa, leli gama kumele liqale ngencwadi. Ungafaka futhi inothi, kodwa lokhu akudingekile. Chofoza inkinobho ethi "Kulungile".
Yiya kuthebhu ethi "Idatha" ye-Microsoft Excel. Khetha indawo yetafula lapho sizosebenzisa khona uhlu lokudonsa. Chofoza inkinobho ethi "Ukuqinisekiswa Kwemininingwane" ekhonini.
Iwindi lokuhlola lokubaluleka kokufaka livula. Kwithebhu ye "Parameters" kufaka "Uhlobo Lwaziswa", khetha i-parameter "List". Emkhakheni we "Umthombo" sifaka uphawu olulinganayo, futhi ngokushesha ngaphandle kwezikhala esizibhalile igama lohlu, esilinikeze ngenhla. Chofoza inkinobho ethi "Kulungile".
Uhlu lokudonsa lukulungele. Manje, uma uchofoza inkinobho, iseli ngalinye lebanga elicacisiwe lizobonisa uhlu lwemingcele, phakathi kokuthi ungakhetha noma ubani ongene esitokisini.
Ukwakha uhlu oludonsa phansi usebenzisa amathuluzi kanjiniyela
Indlela yesibili ihilela ukwakha uhlu lokudonsa phansi usebenzisa amathuluzi wonjiniyela, okuwukuthi usebenzisa i-ActiveX. Ngokuzenzakalelayo, imisebenzi yamathuluzi yonjiniyela ayengekho, ngakho-ke sizoqala ukuwasiza. Ukuze wenze lokhu, iya kuthebhu ethi "Ifayela" ye-Excel, bese uchofoza kumagama-ncazo "I-Parameters".
Ewindini evulekayo, iya esigatshaneni esithi "Izilungiselelo zeRibbon", bese uhlola ibhokisi eceleni kwenani "Developer". Chofoza inkinobho ethi "Kulungile".
Emva kwalokho, ithebhu okuthiwa "uMthuthukisi" ibonakala ku-ribbon, lapho sihamba khona. Dweba ohlwini lwe-Microsoft Excel, okufanele lube imenyu yokudonsa. Bese uchofoza kwiRibon esithombeni se- "Faka", futhi phakathi kwezinto ezivela eqenjini elithi "ActiveX Element", khetha "Ibhokisi le-Combo".
Sichofoza endaweni lapho kufanele kube khona iseli nohlu. Njengoba ungabona, ifomu lohlu livele.
Ngemva kwalokho sithuthela ku "Imodi Yokwakha". Chofoza inkinobho ethi "Proper Proper Control".
Ifasitela yezindawo zokulawula zivula. Kukholomu ye- "ListFillRange", ngesandla, ngemuva kwekhaloni, usethe ububanzi bamaseli etafula, idatha ezokwenza izinto zohlu lwehliswa phansi.
Okulandelayo, chofoza kuseli, futhi kumenyu yokuqukethwe, iya ezintweni "Into Ye-ComboBox" ne "Hlela".
Uhla lokuhlahla kwe-Microsoft Excel lungile.
Ukuze wenze amanye amaseli ngenhla ehlahlisayo, mane umane onqenqemeni ongakwesokudla weseli eliphelile, cindezela inkinobho yegundane, bese uyihudula phansi.
Izinhlu ezihlobene
Futhi, ku-Excel, ungadala uhlu oluhlobene nokuhlaselwa okuhlobene. Lezi izinhlu ezinjalo lapho, uma ukhetha inani elilodwa ohlwini, kwenye ikholomu kuphakanyiswa ukuba ukhethe imingcele ehambelanayo. Isibonelo, uma ukhetha ohlwini lwezimveliso zamazambane, kuhlongozwa ukuthi ukhethe ama-kilogram namagremu njengezinyathelo, futhi uma ukhetha amafutha emifino - amalitha nama-milliliters.
Okokuqala, sizobe silungiselela itafula lapho kuzobe khona khona uhlu lokudonsa phansi, futhi ngokwehlukana wenze uhlu lwamagama nemikhiqizo yokulinganisa.
Sinikeza uhla olukhethiwe kulolu hlu ngalunye, njengoba senze ngaphambilini ngezinhlu ezijwayelekile zokuhlaselwa.
Esitokisini sokuqala, sidala uhlu ngendlela efanayo nangaphambili, ngokuqinisekisa idatha.
Esitokisini sesibili, siphinde siqalise iwindi lokuqinisekisa idatha, kodwa kukholomu "Umthombo", sifaka umsebenzi "= DSSB" nekheli leseli lokuqala. Isibonelo, = = FALSE ($ B3).
Njengoba ungabona, uhlu ludalwe.
Manje, ukuze amangqamuzana aphansi athole izakhiwo ezifanayo njengesikhathi esidlule, khetha amangqamuzana angenhla, futhi inkinobho yegundane igxiliwe, yihudula phansi.
Konke, itafula lidalwa.
Sithole ukuthi singenza kanjani uhlu lokudonsa phansi ku-Excel. Lolu hlelo lungadala kokubili uhlu olulula lokudonsa nalabo abaxhomekile. Kulokhu, ungasebenzisa izindlela ezihlukahlukene zokudala. Ukuzikhethela kuxhomeke enjongweni ethile yalolu hlu, inhloso yendalo yakhe, ububanzi, njll.
