Ke hana nei ʻoe ma Microsoft Excel i nā papa me ka hoʻokaʻawale kope, he mea maʻalahi loa ia e hoʻohana i ka papa inoa hāʻule i lalo. Me ia, hiki iā ʻoe ke koho wale i nā ʻāpana i makemake ʻia mai ka papa kuhikuhi. E ʻike kākou i pehea e hana ai i kahi papa inoa i kahi i lalo o nā ʻano like ʻole.
E hana i kahi papa inoa
ʻO kahi maʻalahi a ma ka manawa like i ke ala e hana ai e hana i kahi papa laka i lalo kahi kahi e kau ai i kahi papa inoa o kahi kaʻawale.
ʻO ka mea mua, hana mākou i ka papa ʻaina i kahi e hele ai mākou e hoʻohana i ka papa kuhikuhi i lalo, a hana pū i kahi papa inoa hoʻokaʻawale kahi o nā data e hoʻokomo pū ai mākou i kēia papa inoa i ka wā e hiki mai ana. Hiki ke kau ʻia i kēia ʻāpana ma ka pepa like o ka pepa, a ma kekahi, inā ʻaʻole ʻoe e makemake e hui pū ʻia nā papa ʻelua.
E koho i ka ʻikepili a mākou i hoʻolālā ai e hoʻohui i ka papa inoa hāʻule i lalo. Pākuʻi mākou-kaomi ʻākau, a ma ka ʻaoʻao pakuhi i koho i ka helu "Hāʻawi inoa ...".
E wehe ka puka palapala no ka hoʻokumu ʻana i kahi inoa. I ka mahina "Name", komo i kekahi inoa maʻalahi e hoʻomaopopo ai mākou i kēia papa inoa. Akā, pono e hoʻomaka kēia inoa me kahi leka. Hiki iā ʻoe ke komo pū i kahi leka, ʻaʻole pono kēia. Kaomi ma ka pihi "OK".
E hele i ka "Data" tab e pili ana iā Microsoft Excel. E koho i ka papa pākaukau kahi e hele ai mākou e hoʻohana ai i ka papa inoa hina. Kaomi ma ka pihi "Data Validation" e waiho ana ma ka Lona.
E wehe ka puka makani no ka nānā ʻana i nā waiwai helu komo. I ka pahu "Parameter", i loko o ka ʻaoʻao "Data type", koho i ka "List List". I ka mahina "Punawai", kau i kahi hōʻailona ma hope, a me nā manawa ʻole e kākau ka inoa o ka papa inoa i hāʻawi ʻia ma luna. Kaomi ma ka pihi "OK".
Ua mākaukau ka papa pākuhi. I kēia manawa, ke kaomi ʻana i ka pihi, e loaʻa ka papa inoa o nā ʻāpana i kēlā me kēia cell o ka palena i kuhikuhi ʻia, i hiki iā ʻoe ke koho i kekahi mea e hoʻohui i ka pūliki.
E hana i kahi papa kuhikuhi i lalo e hoʻohana ana i nā mea hana hoʻomohala
ʻO ke ʻano hana ʻelua e pili ana i ka hana ʻana i kahi papa kuhikuhi i lalo o ka hoʻohana ʻana i nā mea hana hoʻomohala, ʻo ia hoʻi ka hoʻohana ʻana iā ActiveX. Ma ka hoʻohālikelike, ʻaʻohe ona mea hana hana, no laila, pono mākou e kōkua mua iā lākou. No ka hana ʻana i kēia, e hele i ka "Kōnae" tab o Excel, a kaomi ma ka kaomi "Kōkua".
Ma ka puka aniani e wehe ai, e hele i ka "Customize Ribbon" helu, a kau i kahi helu hōʻoia ma hope o "Developer". Kaomi ma ka pihi "OK".
Ma hope o kēlā, e kau ʻia kahi papa ma ka pahu me ka inoa ʻo "Developer", kahi e neʻe ai mākou. Manaʻo mākou i loko o Microsoft Excel i kahi papa inoa e pono e lilo i ka papa hoʻokaʻawale. A laila, kaomi i ka "Hoʻomoʻa" ma ka Ribona, a me nā mea i kū i ka "ActiveX Element" hui, e koho i ka "Combo Box".
E kaomi mākou i kahi o ka cell me ka papa inoa. E like me kāu e ʻike ai, ua puka ʻia ke ʻano o ka papa inoa.
A laila neʻe mākou i ka "Hoʻo Hoʻoiho". Kaomi ma ka pihi "Control Properties".
E wehe ka puka makani i loko. I ka kolamu "ListFillRange" ma o ka pua, e kuhikuhi mākou i ka nui o nā pihi o ka papaʻaina, ka ʻikepili o ia mau mea e hoʻokau i nā mea ma ka papa inoa hāʻule.
Ma hope aʻe, ua kaomi mākou ma ke kelepona, a ma ka papa inoaʻāina i hele ai mākou ma nā mea "ComboBox Object" a me "Hoʻopuka".
Ua mākaukau ka papa inoa hāʻule i lalo ma Microsoft Excel.
E hana i nā kelepona ʻē aʻe me kahi papa inoa i kahi i kahakaha iho, kū wale ma ka ʻaoʻao o ka palena o ka kelepona i pau, kaomi i ka pihi i ka kaomi, a iho i lalo.
Nā Lika pili
Eia kekahi, i ka Excel, hiki iā ʻoe ke hana i nā papa inoa pili i lalo. ʻO ia nā papa inoa i ka manawa, i ke koho ʻana i hoʻokahi waiwai mai ka papa inoa, ua manaʻo ʻia e koho i nā mea pili i nā pahu ʻē aʻe i kekahi kolamu. No ka laʻana, i ke koho ʻana i nā huahana huaʻai mai ka papa inoa, ua manaʻo ʻia e koho i nā kilograms a me ka grika e like me ke ana, a i ke koho ʻana i nā aila ʻaila - lita a me nā millil.
ʻO ka mea mua, e hoʻomākaukau mākou i kahi papaʻa kahi e waiho ai nā papa inoa hāʻule, a hoʻokaʻawale i nā papa inoa me nā inoa o nā huahana a me nā ana.
Kuhi mākou i kahi inoa inoa inoa i kēlā me kēia papa inoa, e like me kā mākou hana ma nā papa inoa pākahi.
I ka pūlama mua, hana i kahi papa inoa i nā ala like e like me kā mākou i hana ai ma mua, ma o ka hōʻoia ʻikepili.
Ma ka lua o ka lua, ke hoʻolaha nei mākou i ka puka hōʻike hōʻoia data, akā i ka kolamu "Source" komo mākou i ka hana "= INDIRECT" a me ka kikoʻī o ka hana mua. No ke ano, = INDIRECT ($ B3).
E like me kāu e ʻike ai, hana ʻia ka papa inoa.
I kēia manawa, i ka loaʻa ʻana o nā mea i lalo loa i nā waiwai like me ka manawa ma mua, e koho i nā pū i luna, a i ka pihi ʻana o ka pihi o ka kiʻī, "e huki" i lalo.
Loaʻa nā mea āpau, hana ka papaʻaina.
Hoʻomaopopo mākou i pehea e hana ai i kahi papa inoa i lalo i lalo. Ma ka papahana, hiki iā ʻoe ke hana i nā papa inoa ʻelua a me nā papa inoa hilinaʻi. I kēia hihia, hiki iā ʻoe ke hoʻohana i nā ʻano hana like ʻole. Aia ka mea i koho ʻia i ke kumu kūikawā o ka papa inoa, nā pahuhopu o kona kūkulu ʻana, ke kūpaʻa, etc.
