-Drop-down list in Excel

Namhlanje computer kube yinxalenye ebalulekileyo yobomi bethu. Iinkqubo ezahlukeneyo bebesenjenjalo lula umsebenzi ukuba unako ukwenza ngaphandle kwabo, abangenamava makhwelo yomsebenzisi. Omnye wabo kwiprogram ye-Excel - elula, elula kakhulu ngempumelelo. Ngenxa iimpawu zayo ezininzi, oko zingasetyenziswa njenge computer ikhaya, kunye nomsebenzi ofisi. Kwabanye kuye nje ufunwayo.

Kakade ke, ukuze uqale ukusebenza ne-Excel kunzima kakhulu, kodwa ekuhambeni kwexesha, ukuqonda imisebenzi yalo, kube lula kakhulu. umsebenzisi makhwelo Kwaye ngamanye amaxesha kunzima ukuqonda zonke bokuqonda umsebenzi, ngoko ke nqaku liza uthethe ngomba othile, nto leyo umdla abaninzi: "Indlela yokwenza yotsalo-phantsi uluhlu e-Excel». Zama ukuqonda.

Kuqala kwinto zonke, simele siqonde ukuba le yotsalo-phantsi uluhlu in Excel. Lidla zomsebenzi Excel-amaxwebhu, abasebenzisi kufuneka into ebangela ukuba ufake iinkcukacha ezifanayo iiseli ezininzi. Ityala lenkathazo kunye engeyomfuneko. Ukwenzela ukuba ibe lula ngandlela ithile inkqubo, ukuba uyazi imisebenzi enjalo yesicelo, njengoko nezintlu drop-phantsi. Le nto Ukugunda kakhulu, kwaye benze uluhlu lwe ngeendlela ezahlukeneyo.

Ngenxa yoko, i- drop-phantsi uluhlu kwi Excel lungalungiselelwa ngokusebenzisa indlela esezantsi kwaye usebenzise ulawulo software. Ityala lokuqala ilungele kwabasaqalayo kwakunye nezenzo ezenziwa phindwe kuzo zonke iintlobo lweenkqubo zokusebenza. Okokuqala, khetha zonke iiseli ezinqwenelekayo kunye data, nekufuneka zenziwe kwi-drop-down list. Waza wenza umnyango ukuya menu, kwaye ulandelelwano ilandelayo yezenzo: "Faka" - "Igama" - "Beka".

Ngenisa igama nokukhetha ibanga (oko kusenokuba nawuphi, imeko engundoqo - kufuneka ingabi izithuba). Iintshukumo zingqinwa ngokucofa i "Kulungile". Ngoku kuyimfuneko ukuba uqaphele iseli apho kuluhlu iya kunyothulwa. Unga ukucacisa ngaphezulu kwesinye. Kwakhona ivula menu uze ukhethe umyalelo "Data" - "Khangela". Emva koko "Options" tab. Kuzo zonke olucetywayo iintlobo data "uLuhlu" kufuneka ekhethiweyo. Xa "Imvelaphi" kufakwe uphawu "zilingana" wathi ekuqaleni igama kuluhlu kungekho izithuba. Kwenziwe. Excel lahla phantsi uluhlu ukudala ngendlela eqhelekileyo.

Xa indima imithombo yedatha abanokusebenza dynamically igama uluhlu, umzekelo, naluphi na uluhlu lwamaxabiso. Ukuba ngaba ufuna ukongeza iinkcukacha ukuya uxwebhu oluphambili, ke wongezelela ngokuzenzekelayo kulahlo phantsi kuluhlu e-Excel. Kukho kwakhona umsebenzi kwezintlu ezinxulumene. Oku kuthetha ukuba, ukuba wena wenze utshintsho ukuya kwenye, ukuba zitshintshiwe ngokuzenzekela kwindawo enye.

Ityala lesibini iquka uyilo ukuwa-phantsi uluhlu ukuba usebenzise ulawulo. Xa uguqulelo Excel 2007-2010 kwi toolbar ukuvula i tab "Developer" (ukuba kukho inkqubo ezindala kuvula "Forms" tab). Apha, kwi izixhobo ngasentla, kuyimfuneko ukufumana icon imenyu yoluhlu, khetha uze uzobe uxande. Oku kuya kuba yotsalo-phantsi uluhlu ezayo Excel.

Sebenzisa i ekunene iqhosha le mouse, khetha "Format Object". Kwisiphumo ibhokisi yencoko yababini yisa umyalelo le imiyalelo ilandelayo: "ukudala uluhlu band" (khetha ezo iiseli ukuba kufuneka ibe kuluhlu), "link Cell" (uchaze iseli apho kuya kubhaliswa inombolo item), kwaye yokugqibela - " inani lemiqolo uluhlu "(faka inombolo oyifunayo imiqolo loluhlu elizayo). Yonke ukuqinisekisa isenzo ngokucofa i "Kulungile". I-drop-phantsi uluhlu idaliwe, ungaqalisa ukusebenza.

Indlela elula kakhulu ukudala drop-phantsi izintlu, nto leyo efanelekileyo nkqu abo ukuqonda elincinane iikhompyutha ngolu hlobo lulandelayo. amaxabiso amabini okanye amathathu wangena kulo kumhlathi (kangangoko kunokwenzeka). Kolunye kuzo hambisa isalathisi kwaye cinezela iqhosha indibanisela Alt yezitshixo + umkhonto ojonge phantsi okanye sebenzisa i ekunene iqhosha le mouse ukhetha i "Khetha kuluhlu dropdown."