Okuqukethwe
Ividiyo
Ubani onesikhathi esincane futhi odinga ukuqonda ngokushesha ingqikithi - buka ividiyo yokuqeqesha:
Obani abanesithakazelo emininingwaneni kanye nama-nuances azo zonke izindlela ezichazwe - ngokuqhubekayo phansi umbhalo.
Indlela 1. Eyakudala
Chofoza kwesokudla kanye kuseli elingenalutho ngaphansi kwekholomu enedatha, umyalo wemenyu yokuqukethwe Khetha ohlwini lokudonsela phansi (Khetha ohlwini oludonsela phansi) noma cindezela isinqamuleli sekhibhodi ALT+umcibisholo oya phansi. Indlela ayisebenzi uma okungenani umugqa owodwa ongenalutho uhlukanisa iseli nekholomu yedatha, noma uma udinga umkhiqizo ongakaze ufakwe ngenhla:
Indlela 2. Standard
- Khetha amaseli anedatha okufanele afakwe ohlwini lokudonsela phansi (isibonelo, amagama emikhiqizo).
- Uma une-Excel 2003 noma ngaphezulu, khetha kumenyu Faka – Igama – Yabela (Faka - Igama - Chaza), uma i-Excel 2007 noma entsha, vula ithebhu amafomula bese usebenzisa inkinobho Umphathi wegamaBese Dala. Faka igama (noma yiliphi igama lingenzeka, kodwa ngaphandle kwezikhala futhi uqale ngohlamvu!) kububanzi obukhethiwe (ngokwesibonelo Product). Chofoza ku- OK.
- Khetha amaseli (ungaba ambalwa ngesikhathi esisodwa) ofuna ukuthola kuwo uhlu lokudonsela phansi bese ukhetha kumenyu (kuthebhu) Idatha - Hlola (Idatha - Ukuqinisekisa). Kusuka ohlwini lokudonsela phansi Uhlobo Lwedatha (Vumela) khetha inketho Uhlu bese ungena emgqeni Umthombo ilingana negama lophawu nebanga (isb =Imikhiqizo).
Cindezela OK.
Konke! Jabulela!
I-nuance ebalulekile. Ububanzi obunegama eliguqukayo, njengohlu lwamanani, lungasebenza njengomthombo wedatha wohlu. Bese, lapho wengeza imikhiqizo emisha ohlwini lwamanani, izongezwa ngokuzenzakalelayo ohlwini lokudonsela phansi. Elinye iqhinga elivame ukusetshenziswa kuhlu olunjalo ukudala okwehliswayo okuxhumene (lapho okuqukethwe kohlu olulodwa kushintsha kuye ngokukhethwa kolunye).
Indlela yesi-3: Ukulawula
Le ndlela iwukufaka into entsha eshidini - isilawuli sebhokisi le-combo, bese uyibophezela ebangeni eshidini. Kwalokhu:
- Ku-Excel 2007/2010, vula ithebhu Unjiniyela. Ezinguqulweni zangaphambili, ibha yamathuluzi Amafomu ngokusebenzisa imenyu Buka – Amabha amathuluzi – Amafomu (Buka – Amabha amathuluzi – Amafomu). Uma le thebhu ingabonakali, chofoza inkinobho Ihhovisi - Izinketho ze-Excel - ibhokisi lokuhlola Bonisa Ithebhu Yonjiniyela ku-Ribbon (Inkinobho Yehhovisi - Izinketho ze-Excel - Bonisa Ithebhu Yonjiniyela ku-Ribbon)
- Bheka isithonjana sokudonsela phansi phakathi kwezilawuli zefomu (hhayi i-ActiveX!). Landela amacebo azivelelayo ibhokisi le-combo:
Chofoza isithonjana bese udweba unxande omncane ovundlile - uhlu oluzayo.
- Chofoza kwesokudla ohlwini oludwetshiwe bese ukhetha umyalo Ifomethi Yento (Ukulawula ifomethi). Ebhokisini lengxoxo elivelayo, setha
- Yakha uhlu ngobubanzi – khetha amaseli anamagama ezimpahla okufanele afakwe ohlwini
- Ukuxhumana kwamaselula – cacisa iseli lapho ofuna ukubonisa khona inombolo ye-serial yento ekhethwe ngumsebenzisi.
- Inombolo yemigqa yohlu - mingaki imigqa ezoboniswa ohlwini lokudonsela phansi. Okuzenzakalelayo kungu-8, kodwa okuningi kungenzeka, okuyinto indlela yangaphambilini engavumeli.
Ngemuva kokuchofoza OK list ingasetshenziswa.
Ukuze ubonise igama layo esikhundleni senombolo ye-serial ye-elementi, ungasebenzisa futhi umsebenzi ISIHLOKO (INDEX), engabonisa okuqukethwe kweseli elidingekayo kusukela kububanzi:
Indlela yesi-4: Ukulawula i-ActiveX
Le ndlela ngokwengxenye ifana neyangaphambili. Umehluko omkhulu ukuthi akusona isilawuli esingezwa eshidini, kodwa isilawuli se-ActiveX. "I-Combo Box" kusuka ebhokisini elidonsela phansi ngaphansi kwenkinobho Faka kusuka kuthebhu Unjiniyela:
Indlela yokwengeza iyafana - khetha into ohlwini bese uyidweba eshidini. Kodwa-ke umehluko omkhulu endleleni yangaphambilini uqala.
Okokuqala, uhlu lokudonsela phansi oludaliwe lwe-ActiveX lungaba ezifundeni ezimbili ezihlukene ngokuyisisekelo - imodi yokulungisa iphutha, lapho ungakwazi ukumisa amapharamitha nezakhiwo zalo, ulihambise eduze kweshidi bese ushintsha usayizi walo, kanye - nemodi yokufaka, lapho okuwukuphela kwento ongayenza. ukukhetha idatha kuyo. Ukushintsha phakathi kwalezi zindlela kwenziwa kusetshenziswa inkinobho. Imodi Yokuklama ithebhu Unjiniyela:
Uma le nkinobho icindezelwa, khona-ke singalungisa amapharamitha ohlu oludonsela phansi ngokucindezela inkinobho eseduze. Izakhiwo, elizovula iwindi elinohlu lwazo zonke izilungiselelo ezingaba khona zento ekhethiwe:
Izakhiwo ezidingeka kakhulu neziwusizo ezingase zilungiswe futhi okufanele zilungiswe:
- ListFillRange – ububanzi bamaseli lapho idatha yohlu ithathwa khona. Ngeke ikuvumele ukuthi ukhethe ibanga ngegundane, udinga nje ukulifaka ngezandla zakho usuka kukhibhodi (ngokwesibonelo, Ishidi2! A1: A5)
- I-LinkedCell – iseli elihlobene lapho into ekhethiwe ohlwini izovezwa khona
- ListRows – inombolo yemigqa ebonisiwe
- Ifonti - ifonti, usayizi, isitayela (ithalikhi, dwebela, njll. ngaphandle kombala)
- I-ForeColor и umbala ongemuva – umbala wombhalo nengemuva, ngokulandelana
I-plus enkulu namafutha yale ndlela yikhono lokugxumela ngokushesha entweni oyifunayo ohlwini lapho ufaka izinhlamvu zokuqala ezivela kukhibhodi (!), Engatholakali kuzo zonke ezinye izindlela. Iphuzu elihle, futhi, yikhono lokwenza ngokwezifiso isethulo esibukwayo (imibala, amafonti, njll.)
Uma usebenzisa le ndlela, kungenzeka futhi ukucacisa njenge ListFillRange hhayi kuphela ububanzi obunohlangothi olulodwa. Ungakwazi, ngokwesibonelo, ukusetha ububanzi bamakholomu amabili nemigqa eminingana, okubonisa ngaphezu kwalokho ukuthi udinga ukuveza amakholomu amabili (isakhiwo). IkholomuCount=2). Ngemuva kwalokho ungathola imiphumela ekhangayo ekhokha wonke umzamo osetshenziswe kuzilungiselelo ezengeziwe:
Ithebula lokugcina lokuqhathanisa lazo zonke izindlela
| Indlela 1. I-Primitive | Indlela 2. Standard | Indlela 3. Into yokulawula | Indlela 4. Ukulawula i-ActiveX | |
| kushuba | Phansi | isilinganiso | high | high |
| Ikhono lokwenza ifonti, umbala, njll. | cha | cha | cha | Yebo |
| Inombolo yemigqa ebonisiwe | njalo 8 | njalo 8 | iyiphi | iyiphi |
| Sesha ngokushesha into ngezinhlamvu zokuqala | cha | cha | cha | Yebo |
| Isidingo sokusebenzisa umsebenzi owengeziwe INDEX | cha | cha | Yebo | cha |
| Ikhono lokudala uhlu lokudonsela phansi oluxhunyiwe | cha | Yebo | cha | cha |
:
- Uhlu olwehliswayo olunedatha esuka kwelinye ifayela
- Ukudala Okwehliswayo Okuncike
- Ukudala okuzenzakalelayo kohlu olwehliswayo ngezengezo ze-PLEX
- Ukukhetha isithombe ohlwini olwehliswayo
- Ukususwa ngokuzenzakalelayo kwezinto esezisetshenzisiwe ohlwini lokudonsela phansi
- Uhlu olwehliswayo olunokwengezwa okuzenzakalelayo kwezinto ezintsha