Microsoft Excel: Jerin saukarwa

Pin
Send
Share
Send

Lokacin aiki a Microsoft Excel a cikin tebur tare da bayanan kwafi, yana da matukar dacewa don amfani da jerin zaɓi. Tare da shi, zaka iya zaɓar sigogi da ake so daga menu ɗin da aka ƙera. Bari mu gano yadda ake yin jerin abubuwan saukar da bayanai ta hanyoyi daban-daban.

Anirƙiri ƙarin jerin

Mafi dacewa kuma a lokaci guda hanya mafi aiki don ƙirƙirar jerin abubuwanda aka saukar shine wata hanyar da ta dogara akan gina jerin bayanan daban.

Da farko, muna yin teburin sayo kaya inda zamuyi amfani da menu na ƙasa, kuma muna yin jerin bayanan daban da zamu haɗa a cikin wannan menu anan gaba. Za'a iya sanya waɗannan bayanan akan takaddun takarda iri ɗaya, kuma a wani, idan baku son allunan biyu za su kasance a gani tare.

Zaɓi bayanan da muke shirin ƙarawa cikin jerin zaɓi. Mun danna-dama, kuma a cikin mahallin menu zaɓi abu "Sanya sunan ...".

Hanyar ƙirƙirar suna yana buɗe. A filin “Suna”, shigar da kowane sunan da ya dace wanda za mu san wannan jerin. Amma, wannan sunan dole ne ya fara da harafi. Hakanan zaka iya shigar da bayanin kula, amma ba a buƙatar wannan. Latsa maɓallin "Ok".

Je zuwa shafin "Data" na Microsoft Excel. Zaɓi yankin tebur inda za mu yi amfani da jerin dropayan. Latsa maɓallin "Tabbatar da Bayanai" wanda ke kan Ribbon.

Tagan don duba ƙimar shigarwar yana buɗe. A cikin shafin "Sigogi", a cikin filin "Data type", zabi sigar "Jerin". A filin "Source", sanya alamar daidai, kuma nan da nan ba tare da sarari ba rubuta sunan jerin waɗanda aka sanya a sama. Latsa maɓallin "Ok".

Jerin jerin zaɓuka yana shirye. Yanzu, lokacin da ka danna maballin, jerin sigogi za su bayyana a cikin kowace tantanin halitta da aka ƙayyade, a cikin abin da za ka iya zaɓar kowane don ƙarawa cikin tantanin.

Irƙiri jerin abubuwanda aka aika ta amfani da kayan aikin haɓaka

Hanya ta biyu ta ƙunshi ƙirƙirar jerin abubuwan saukarwa ta amfani da kayan aikin haɓakawa, wato amfani da ActiveX. Ta hanyar tsoho, babu ayyukan kayan aikin haɓakawa, saboda haka za mu buƙaci farko da kunna su. Don yin wannan, je zuwa shafin "Fayiloli" na Excel, sannan danna kan rubutun "Zaɓuɓɓuka".

A cikin taga da ke buɗe, je zuwa sashin "Zaɓin Ribbon", saika sanya alamar bincike kusa da "Mai haɓaka". Latsa maɓallin "Ok".

Bayan haka, shafin ya bayyana a kan kintinkiri tare da sunan "Mai Haɓakawa", inda muke motsawa. Mun zana a Microsoft Excel jerin wanda yakamata ya zama menu na kasa. Bayan haka, danna kan "Saka" gunkin kan Ribbon, kuma daga cikin abubuwan da suka bayyana a kungiyar "ActiveX Element", zabi "Combo Box".

Mun danna kan wurin da tantanin da yakamata yakamata ya kasance. Kamar yadda kake gani, tsarin jerin ya bayyana.

Sannan mun matsa zuwa "Tsarin Tsara". Latsa maɓallin "Abubuwan Kulawa".

Taga ikon sarrafawa yana buɗewa. A cikin shafi "ListFillRange" da hannu ta hanyar hancin, mun ƙayyade kewayon sel na teburin, bayanan abin da zai samar da abubuwan a cikin jerin zaɓi.

Bayan haka, mun danna kan tantanin, kuma a cikin menu na mahallin zamu shiga cikin abubuwan "ComboBox Object" da "Shirya".

Jerin masu saukarwa cikin Microsoft Excel ya shirya.

Don yin sauran sel tare da jerin abubuwan saukarwa, kawai a tsaye a ƙasan dama na farin ƙwayar da aka gama, danna maɓallin linzamin kwamfuta, sai a ja ƙasa.

Lissafi masu dangantaka

Hakanan, a cikin Excel, zaku iya ƙirƙirar jerin jerin abubuwa masu dangantaka. Waɗannan su ne irin waɗannan jerin lokacin, lokacin zabar ƙimar ɗaya daga cikin jerin, ana ba da shawara don zaɓar sigogi masu dacewa a cikin wani shafi. Misali, lokacin zabar kayan dankalin turawa daga jeri, ana ba da shawarar zabi kilo da gram a matsayin matakan, kuma lokacin zabar mai kayan lambu - lita da milliliters.

Da farko, za mu shirya tebur inda jerin jerin abubuwan da aka saƙa, za a keɓance su, tare da yin samfuran abubuwa daban-daban tare da sunayen samfuran da matakan.

Mun sanya kewayon mai suna zuwa kowane ɗayan jerin, kamar yadda muka yi tare da jerin abubuwanda aka saba.

A cikin tantanin farko, ƙirƙirar jerin daidai yadda muka yi a baya, ta hanyar tabbatar da bayanai.

A cikin sel na biyu, mun kuma kaddamar da taga tabbaci na bayanai, amma a cikin shafi "Source" mun shigar da aikin "= INNDIRECT" da adireshin tantanin farko. Misali, = INDIRECT ($ B3).

Kamar yadda kake gani, an ƙirƙiri jerin.

Yanzu, saboda ƙananan ƙwayoyin sun sami kaddarorin iri ɗaya kamar lokacin da ya gabata, zaɓi ƙwayoyin babba, kuma idan an matsa maɓallin linzamin kwamfuta, "ja" ƙasa.

Komai, tebur aka kirkira.

Mun gano yadda ake yin jerin abubuwan saukarwa cikin Excel. A cikin shirin, zaku iya ƙirƙirar duka abubuwa masu sauƙi biyu da kuma dogaro. A wannan yanayin, zaku iya amfani da hanyoyi daban-daban na halitta. Zabi ya dogara da takamaiman dalilin jerin abubuwan, manufofin kirkirar sa, ikon yinsa, da dai sauransu.

Pin
Send
Share
Send