Lapho usebenza kuMicrosoft Excel kumatafula wedatha ephindaphindwayo, kulula kakhulu ukusebenzisa uhlu olwehliswayo. Ngalo, ungamane ukhethe amapharamitha afunekayo kusuka kwimenyu ekhiqizwe. Ake sibheke ukuthi ungawenza kanjani uhlu olwehliswayo ngezindlela ezahlukahlukene.
Ukwakha uhlu olungeziwe
Okuhle kakhulu, futhi ngasikhathi sinye indlela esebenza kakhulu yokwakha uhlu olwehliswayo kuyindlela esekelwe ekwakheni uhlu lwedatha oluhlukile.
Okokuqala, senza itafula elingenalutho lapho sizosebenzisa khona imenyu eyehlayo, futhi senze nohlu oluhlukile lwedatha ngokuzayo luzovula le menyu. Le datha ingabekwa zombili ekhasini elifanayo ledokhumenti futhi ngakolunye uhlangothi, uma ungafuni ukuthi itafula lihlangene.
Silwa imininingwane esihlela ukuyisebenzisa ohlwini olwehliswayo. Sichofoza inkinobho yegundane kwesokudla, bese ukhetha igama elithi "Nikeza Igama ..." kumenyu yokuqukethwe.
Uhlobo lokudala igama liyavula. In the "Igama" field, jabulela noma yiliphi igama elifanele esizothola kulolu hlu. Kepha, leli gama kumele liqale ngencwadi. Ungafaka futhi inothi, kepha akudingekile. Chofoza inkinobho ethi "KULUNGILE".
Iya kuthebhu "Idatha" yezinhlelo ze-Microsoft Excel. Sigqamisa indawo yetafula lapho sizofaka khona uhlu olwehliswayo. Chofoza inkinobho ethi "Isheke Lesheke" elisethepheni.
Iwindi lokuqinisekisa livula okokufaka kwamanani. Kuthebhu "Parameters", enkundleni yohlobo lwedatha, khetha uhlu lwamapharamitha. Ensimini "umthombo" faka uphawu olulinganayo, futhi ngokushesha sibhala igama lohlu, olumfaka ngenhla. Chofoza inkinobho ethi "KULUNGILE".
Uhlu olwehliswayo lulungile. Manje, uma uqhafaza enkingeni, iseli ngalinye lebanga elicacisiwe lizovela uhlu lwamapharamitha, phakathi kwalo ungakhetha noma yikuphi ukwengeza esitokisini.
Ukwakha uhlu olwehliswayo usebenzisa amathuluzi onjiniyela
Indlela yesibili ifaka ukudala uhlu olwehliswayo kusetshenziswa amathuluzi wonjiniyela, okungukuthi usebenzisa i-Activex. Ngokuzenzakalelayo, awekho imisebenzi yamathuluzi kanjiniyela, ngakho-ke sizodinga kuqala ukubafake. Ukuze wenze lokhu, iya kuthebhu "yefayela" yohlelo lwe-Excel, bese uqhafaza ku-"Parameters" Okholwayo.
Ewindini elivula, iya esigatshaneni se-Ribbon Setup ", bese usetha ibhokisi lokuhlola elibhekene nenani elithi" lonjiniyela ". Chofoza inkinobho ethi "KULUNGILE".
Ngemuva kwalokho, ithebhu ivela ethepheni ngegama elithi "unjiniyela", lapho sihamba khona. Abansundu kuMicrosoft Excel, okufanele babe imenyu eyehlayo. Ngemuva kwalokho, chofoza kwithoni "Faka" isithonjana, futhi phakathi kwezinto ezivele eqenjini le-Activex element, khetha "inkambu ngohlu".
Chofoza endaweni lapho kufanele kube khona iseli nohlu. Njengoba ubona, kwavela ifomu yohlu.
Ngemuva kwalokho sithuthela kwi "Makhilokhi". Chofoza ku- "Properties of the Control" control ".
Iwindi lokulawula livula. Kugrafu "Uhlu lwe-Listfickranran" ngesandla, sibeka uhla lwamaseli wethebula ngokusebenzisa ikholoni, ezokwakha amaphuzu ohlwini olwehliswayo.
Okulandelayo, chofoza esitokisini, nakumenyu yokuqukethwe, silandela ngokulandelana kwento ethi "Combobox" futhi "Hlela".
Uhlu olwehliswayo ku-Microsoft Excel isilungile.
Ukuze wenze amanye amaseli ngohlu olwehliswayo, mane abe umphetho ongezansi kwesokudla weseli eliqediwe, cindezela inkinobho yegundane, bese welula phansi.
Uhlu Okuhlobene
Futhi, ohlelweni lwe-Excel ungakha uhlu oluhlobene nokwehla. Lezi zihlu ezinjalo lapho ukhetha inani elilodwa ohlwini, kwesinye ikholomu kuhlongozwa ukukhetha amapharamitha ahambisanayo. Isibonelo, lapho ukhetha ohlwini lwemikhiqizo yamazambane, kuhlongozwa ukuthi ukhethe njengekhilogremu namagremu isilinganiso sokulinganisa isilinganiso sokulinganisa, lapho kukhethwa uwoyela wemifino - ilitha namamilitha.
Okokuqala, silungiselela itafula lapho kuzotholakala khona uhlu olwehliswayo, futhi sizokwenza uhlu ngegama lemikhiqizo nezinyathelo zokulinganisa.
Sikwabela uhlu ngalunye lwezinhla ezihlangene, njengoba sesivele senze ngaphambili ngohlu olujwayelekile olwehliswayo.
Esitokisini sokuqala, sakha uhlu ngendlela efanayo njengoba lwenziwa ngaphambili, ngokuqinisekiswa kwedatha.
Esitokisini sesibili, futhi qalisa iwindi lokuqinisekisa idatha, kodwa emthonjeni "emthonjeni" wekholamu "sifaka umsebenzi" = DWARNS "kanye nekheli leseli lokuqala. Isibonelo, = DVSSL ($ B3).
Njengoba ubona, uhlu lwenziwe.
Manje, ukuze amaseli aphansi athole izakhiwo ezifanayo, njengasesikhathini esedlule, khetha amaseli aphezulu, kanye nokhiye wegundane "Phehlisa phansi" phansi.
Konke, itafula lenziwa.
Sicabange ukuthi singawenza kanjani uhlu olwehliswayo ku-Excel. Uhlelo lungadala uhlu olulula lokudonsa phansi futhi kuncike. Ngasikhathi sinye, ungasebenzisa izindlela ezahlukahlukene zokudala. Ukukhetha kuncike enhlosweni ethile yohlu, izinhloso zokudala kwayo, indawo yesicelo, njll.