Mndandanda wotsikira mu cell

Video

 Ndani ali ndi nthawi yocheperako ndipo akufunika kumvetsetsa tanthauzo lake - onerani kanema wophunzitsira:

Amene ali ndi chidwi ndi tsatanetsatane ndi ma nuances a njira zonse zomwe zafotokozedwa - kupitirira pansi malembawo.

Njira 1. Zakale

Dinani kumanja kumodzi pa cell yopanda kanthu pansi pa mzere wokhala ndi data, lamulo la menyu yankhani Sankhani kuchokera dontho pansi mndandanda (Sankhani kuchokera pamndandanda wotsikira pansi) kapena dinani njira yachidule ya kiyibodi ALT + muvi wapansi. Njirayi siigwira ntchito ngati mzere umodzi wopanda kanthu umalekanitsa selo ndi mzere wa data, kapena ngati mukufuna chinthu chomwe sichinalowepo pamwambapa:

Njira 2. Standard

1. Sankhani ma cell omwe ali ndi data yomwe ikuyenera kuphatikizidwa pamndandanda wotsikira pansi (mwachitsanzo, mayina azinthu).
2. Ngati muli ndi Excel 2003 kapena kuposerapo, sankhani kuchokera pa menyu Ikani - Dzina - Perekani (Lowetsani - Dzina - Tanthauzirani), ngati Excel 2007 kapena yatsopano, tsegulani tabu Mafomu ndi kugwiritsa ntchito batani Woyang'anira DzinaNdiye Pangani. Lowetsani dzina (dzina lililonse lingatheke, koma popanda mipata ndikuyamba ndi chilembo!) pamtundu wosankhidwa (mwachitsanzo. mankhwala). Dinani pa OK.
3. Sankhani ma cell (mutha kukhala nawo angapo nthawi imodzi) momwe mukufuna kupeza mndandanda wotsitsa ndikusankha kuchokera pamenyu (pa tabu) Deta - Chongani (Deta - Kutsimikizika). Kuchokera pamndandanda wotsitsa Mtundu wa Data (Lolani) sankhani njira List ndi kulowa mu mzere gwero dzina lofanana ndi chizindikiro ndi mtundu (ie =Zogulitsa).

Press OK.

Zonse! Sangalalani!

Nuance yofunika. Gulu losinthika, monga mndandanda wamitengo, litha kukhalanso ngati gwero la data pamndandanda. Kenako, powonjezera zinthu zatsopano pamndandanda wamitengo, zidzawonjezedwa pamndandanda wotsitsa. Chinyengo china chomwe chimagwiritsidwa ntchito kwambiri pamindandanda yotere ndikupanga madontho olumikizidwa (pomwe zomwe zili pamndandanda umodzi zimasintha malinga ndi zomwe zasankhidwa zina).

Njira 3: Kuwongolera

Njirayi ndikuyika chinthu chatsopano pa pepala - chowongolera bokosi la combo, ndikuchimanga pamizere ya pepala. Za ichi:

1. Mu Excel 2007/2010, tsegulani tabu mapulogalamu. M'mabaibulo akale, toolbar mitundu kudzera menyu Onani - Zida - Mafomu (Mawonekedwe - Zida - Mafomu). Ngati tsamba ili silikuwoneka, dinani batani Office - Excel Zosankha - bokosi lofufuzira Onetsani Tabu Yamadivelopa mu Riboni (Batani la Office - Zosankha za Excel - Onetsani Tabu ya Madivelopa mu Riboni)
2. Yang'anani chizindikiro chotsitsa pakati pa zowongolera mawonekedwe (osati ActiveX!). Tsatirani malangizo a pop-up bokosi la combo:

   Dinani pa chithunzi ndikujambula kakona kakang'ono kopingasa - mndandanda wamtsogolo.

3. Dinani kumanja pamndandanda wokokedwa ndikusankha lamulo Mtundu wa chinthu (Kuwongolera mawonekedwe). Mu bokosi la zokambirana lomwe likuwonekera, sungani

• Pangani mndandanda malinga ndi mtundu - sankhani ma cell omwe ali ndi mayina azinthu zomwe ziyenera kuphatikizidwa pamndandanda
• Kulankhulana ndi ma cell - tchulani selo lomwe mukufuna kuwonetsa nambala yachinsinsi ya chinthu chosankhidwa ndi wogwiritsa ntchito.
• Chiwerengero cha mizere - ndi mizere ingati yoti muwonetse pamndandanda wotsitsa. Zosasintha ndi 8, koma zambiri ndizotheka, zomwe njira yapitayi siyilola.

Pambuyo pang'anani OK list angagwiritsidwe ntchito.

Kuti muwonetse dzina lake m'malo mwa nambala ya serial ya chinthucho, mutha kugwiritsanso ntchito ntchitoyi INDEX (INDEX), yomwe imatha kuwonetsa zomwe zili mu cell yofunikira kuchokera pamndandanda:

Njira 4: Kuwongolera kwa ActiveX

Njirayi ikufanana pang'ono ndi yoyamba. Kusiyana kwakukulu ndikuti sikuwongolera komwe kumawonjezeredwa papepala, koma kuwongolera kwa ActiveX. "Combo Box" kuchokera m'bokosi lotsitsa pansi pa batani Ikani kuchokera ku tabu mapulogalamu:

Njira yowonjezera ndiyofanana - sankhani chinthu kuchokera pamndandanda ndikujambula pa pepala. Koma kusiyana kwakukulu ndi njira yapitayi kumayamba.

Choyamba, mndandanda wotsitsa wa ActiveX wopangidwa ukhoza kukhala m'magawo awiri osiyana - kukonza zolakwika, mukatha kukonza magawo ake ndi katundu wake, kusuntha mozungulira pepala ndikulisinthanso, ndi - kulowa, mukangopanga chinthu chokhacho. ndi kusankha deta kuchokera izo. Kusintha pakati pa mitundu iyi kumachitika pogwiritsa ntchito batani. Kapangidwe mumalowedwe tsamba mapulogalamu:

Ngati batani ili likanikizidwa, ndiye kuti titha kusintha magawo a mndandanda wotsitsa podina batani loyandikana nalo. Zida, yomwe idzatsegula zenera ndi mndandanda wa zosintha zonse zomwe zingatheke pa chinthu chosankhidwa:

Zinthu zofunika kwambiri komanso zothandiza zomwe zitha kukhazikitsidwa:

• ListFillRange - kuchuluka kwa maselo komwe deta ya mndandanda imatengedwa. Sichidzakulolani kuti musankhe mitundu ndi mbewa, muyenera kungolowetsamo ndi manja anu kuchokera pa kiyibodi (mwachitsanzo, Sheet2! A1: A5)
• LinkedCell - cell yolumikizana pomwe chinthu chomwe chasankhidwa pamndandanda chidzawonetsedwa
• ListRows - kuchuluka kwa mizere yowonetsedwa
• Zilembo - font, kukula, mawonekedwe (italic, underline, etc. kupatula mtundu)
• ForeColor и mtundu wakumbuyo - zolemba ndi mtundu wakumbuyo, motsatana

Kuphatikizika kwakukulu ndi mafuta kwa njirayi ndikutha kulumphira mwachangu ku chinthu chomwe mukufuna pamndandanda mukalowa zilembo zoyambirira kuchokera ku kiyibodi (!), Zomwe sizipezeka mwanjira zina zonse. Mfundo yabwino, komanso, ndikutha kusintha mawonekedwe (mitundu, mafonti, ndi zina).

Mukamagwiritsa ntchito njirayi, ndizothekanso kufotokoza ngati ListFillRange osati milingo ya mbali imodzi yokha. Mwachitsanzo, mutha kukhazikitsa mizere iwiri ndi mizere ingapo, kuwonetsanso kuti muyenera kuwonetsa mizati iwiri (katundu). ColumnCount= 2). Kenako mutha kupeza zotsatira zowoneka bwino zomwe zimalipira kuyesayesa konse komwe mumagwiritsa ntchito pazowonjezera zina:

Kuyerekeza komaliza kwa njira zonse

:

• Mndandanda wotsitsa wokhala ndi data kuchokera ku fayilo ina
• Kupanga Zotsitsa Zodalira
• Kupanga zokha mindandanda yotsitsa ndi chowonjezera cha PLEX
• Kusankha chithunzi kuchokera pamndandanda wotsitsa
• Kuchotsa zinthu zomwe zagwiritsidwa kale ntchito pamndandanda wotsitsa
• Mndandanda wotsikira ndi kuwonjezera zinthu zatsopano