Pamene mukugwira ntchito ku Microsoft Excel m'matawuni ndi deta yosawerengeka, ndizotheka kugwiritsa ntchito mndandanda wotsika. Ndicho, mungathe kusankha mwapadera magawo omwe mumapanga. Tiyeni tipeze momwe tingapangire mndandanda wotsika pansi m'njira zosiyanasiyana.
Kupanga mndandanda wowonjezera
Chophweka kwambiri, ndipo panthawi yomweyi njira yabwino kwambiri yopangira ndondomeko yosiyidwa pansi, ndiyo njira yokha yopanga deta yosiyana ya deta.
Choyamba, timapanga tebulo-losalekeza, komwe titi tigwiritse ntchito menyu yotsitsa, komanso kupanga mndandanda wa deta yomwe idzaphatikizidwa mndandandawu mtsogolomu. Detayi ikhonza kuikidwa pa tsamba limodzi, ndi zina, ngati simukufuna kuti magome onse awiri awonedwe pamodzi.
Sankhani deta yomwe tikukonzekera kuwonjezera pa mndandanda wotsika. Dinani botani lamanja la mouse, ndipo m'ndandanda wamasewero musankhe chinthucho "Lembani dzina ...".
Dzina la chilengedwe limatsegulidwa. M'munda "Dzina" lolowani dzina lililonse lokongola lomwe tidzatha kuzindikira mndandandawu. Koma, dzina ili liyenera kuyamba ndi kalata. Mukhozanso kulembera, koma izi siziri zofunikira. Dinani pa batani "OK".
Pitani ku tab "Data" ya Microsoft Excel. Sankhani malo a tebulo komwe tikuti tilembe mndandanda wazitsulo. Dinani pa batani la "Verification Data" yomwe ili pa Ribbon.
Fayilo loyang'ana zowonjezera limatsegula. Mu tabu ya "Parameters" mu gawo la "Dongosolo la Data", sankhani "List" parameter. Mu gawo la "Chitsime" timaika chizindikiro chofanana, ndipo nthawi yomweyo popanda malo omwe timalembera dzina la mndandanda, umene tapatsidwa pamwambapa. Dinani pa batani "OK".
Mndandanda wotsika ndi wokonzeka. Tsopano, mukasindikiza pa batani, selo iliyonse yachindunjiyo idzawonetsera mndandanda wa magawo, pakati pa omwe mungasankhe aliyense kuwonjezera pa selo.
Kupanga mndandanda wotsika pansi pogwiritsira ntchito zipangizo zamakono
Njira yachiwiri ikuphatikizapo kukhazikitsa mndandanda wotsika pansi pogwiritsira ntchito zipangizo zamakono, monga kugwiritsa ntchito ActiveX. Mwachizolowezi, ntchito za osintha zomangamanga sizilipo, kotero ife tifunika kumawawathandiza. Kuti muchite izi, pitani ku "Fayilo" tab ya Excel, ndiyeno dinani pamutu wakuti "Parameters".
Pawindo lomwe limatsegulira, pitani ku gawo la "Ribbon Settings", ndipo fufuzani bokosi pafupi ndi mtengo "Womanga". Dinani pa batani "OK".
Pambuyo pake, tabu yotchedwa "Mlengi" ikuwoneka pa ndodo, kumene tikusunthira. Lembani mndandanda wa Microsoft Excel, womwe uyenera kukhala mndandanda wotsika. Kenaka, dinani pa Ribbon pazithunzi "Insert", ndipo pakati pa zinthu zomwe zinawonekera mu gulu la "ActiveX Element", sankhani "Bokosi la Combo".
Timadula pamalo pomwe pali selo ndi mndandanda. Monga mukuonera, mawonekedwe a mndandanda wawonekera.
Kenako timasamukira ku "Design Mode". Dinani pa batani "Zosungirako katundu".
Zowona zazenera zimatsegula. M'ndandanda ya "ListFillRange", pamanja, pambuyo pa koloni, yongani maselo a tebulo, zomwe zidzatuluke zinthu zolemba pansi.
Kenaka, dinani selo, ndi mndandanda wa zolemba, pang'onopang'ono pa zinthu "ComboBox Object" ndi "Edit".
Mndandanda wotsika wa Microsoft Excel uli wokonzeka.
Kuti ma selo ena ali ndi mndandanda wotsika pansi, ingoyima pamunsi kumbali yakumunsi ya selo lotsirizidwa, yesani phokoso la mbewa, ndipo yesani pansi.
Zotsatira Zogwirizana
Ndiponso, mu Excel, mukhoza kupanga mndandanda wazomwe umatsitsa. Izi ndizondandanda pamene, posankha mtengo umodzi kuchokera mndandanda, m'ndandanda ina umakonzedwa kuti musankhe magawo ofanana. Mwachitsanzo, posankha mndandanda wa mankhwala a mbatata, akufunikanso kusankha makilogalamu ndi magalamu monga njira, komanso posankha mafuta a malita ndi milliliters.
Choyamba, tidzakonzekera tebulo pomwe mndandanda wazitsulo udzakhazikitsidwa, ndipo padera padzakhala mndandanda ndi mayina a malonda ndi miyeso.
Timapereka mndandanda wa mayina omwe atchulidwa, monga momwe takhala tikuchitira kale ndi ndondomeko zowonongeka.
Mu selo yoyamba, timapanga mndandanda chimodzimodzi monga momwe tinkachitira kale, kudzera muzitsimikizidwe za deta.
Mu selo yachiwiri, timayambanso kutsegula zowonjezera deta, koma mu column "Source", timalowa ntchito "= DSSB" ndi adiresi ya selo yoyamba. Mwachitsanzo, = FALSE ($ B3).
Monga momwe mukuonera, mndandanda umalengedwa.
Tsopano, kuti maselo apansi akhale ndi zinthu zomwezo monga nthawi yakale, sankhani maselo apamwamba, ndipo phokoso la mbewa likugwedezeka, kukokera pansi.
Chilichonse, tebulo yakhazikitsidwa.
Tinazindikira momwe tingapangire mndandanda wochotsera pansi pa Excel. Pulogalamuyi ikhoza kupanga pulogalamu yosavuta yochepetsedwa ndi anthu odalira. Pankhaniyi, mungagwiritse ntchito njira zosiyanasiyana zolenga. Kusankha kumadalira pa cholinga chenicheni cha mndandanda, cholinga cha chilengedwe chake, kukula kwake, ndi zina zotero.
