Yadda za a ƙirƙirar Sauke List a cikin Excel

Aikace-aikacen bayanan bayanai na Excel sun haɗa da ƙirƙirar jerin layi da ke ƙayyade bayanan da za a iya shigar da shi a cikin wani takamaiman ƙira zuwa jerin jerin shigarwa.

Lokacin da aka ƙara lissafin layi zuwa wayar, an nuna arrow a kusa da shi. Danna kan arrow zai buɗe lissafin kuma yale ka ka zaba ɗaya daga cikin jerin abubuwa don shiga cikin tantanin halitta.

Bayanin da aka yi amfani dashi a cikin lissafin za'a iya kasancewa:

• a kan wannan takardar aiki kamar jerin
• a kan daban-daban takarda a cikin littafin
• a cikin wani takarda

Koyarwa: Amfani da Bayanin da aka Ajiye a Ɗabi'ar Ɗabi'a dabam dabam

A cikin wannan koyo, za mu kirkiro jerin layi tare da yin amfani da jerin abubuwan da aka shigar a cikin wani littafi daban-daban.

Amfani da yin amfani da jerin shigarwar da ke cikin wani littafi daban-daban sun hada da rarraba jerin jerin bayanai idan masu amfani da yawa ke amfani dashi kuma suna kare bayanan daga canji ko kuma canji.

Lura: Lokacin da aka adana bayanan lissafi a cikin takardun aiki daban-daban dole ne a bude littattafan aiki domin domin jerin suyi aiki.

Biye da matakai a cikin darussan koyawa da ke ƙasa ke tafiya ta hanyar ƙirƙirar, ta amfani da, da kuma sauya jerin layi da aka kwatanta da wanda aka gani a cikin hoto a sama.

Wadannan umarnin koyawa, duk da haka, ba su haɗa da matakan tsarawa don takardun aiki ba.

Wannan ba zai dame shi ba tare da kammala tutorial. Kayan aikinku zai bambanta da misali a shafi na 1, amma jerin da aka sauke za su ba ku sakamakon wannan.

Tutorial Topics

• Ana buɗewa fayiloli da Ajiye Bayanan Tutorial
• Ƙirƙirar Ranaye Biyu
• Ana buɗe akwatin maganganun Bayanan Bayanan
• Shigar da Bayanin Bayanin Bayanai da Ƙaddamar da Lissafin Lissafi
• Canza Abubuwan Lissafin
• Zaɓuɓɓuka don Kare Tsararren List

01 na 06

Shigar da Bayanan Tutorial

Ana buɗe takardun littattafai guda biyu

Kamar yadda aka ambata, don wannan koyaswar bayanai don jerin abubuwan da aka sauke za a kasance a cikin wani littafi daban-daban daga jerin abubuwan da aka sauke.

Don wannan koyawa bi wadannan matakai:

1. Bude takardun aiki na Excel guda biyu
2. Ajiye ɗayan littafi tare da sunan data-source.xlsx - wannan littafi zai ƙunshi bayanai don jerin abubuwan da aka sauke
3. Ajiye littafi na biyu tare da sunan drop-down-list.xlsx - wannan littafi zai ƙunshi jerin abubuwan da aka sauke
4. Ka bar takardun aiki biyu bayan an ceto.

Shigar da Bayanan Tutorial

1. Shigar da bayanan da ke ƙasa zuwa cikin sassan A1 zuwa A4 na aikin littafi na bayanai-source.xlsx kamar yadda aka gani a hoton da ke sama.
2. A1 - Gingerbread A2 - Lemon A3 - Oatmeal Rabi A4 - Chip Chocolate
3. Ajiye littafin jarrabawa kuma ya bar ta bude
4. Shigar da bayanan da ke ƙasa zuwa cikin sassan B1 na lissafin drop-down-list.xlsx .
5. B1 - Kukis Irin:
6. Ajiye littafin jarrabawa kuma ya bar ta bude
7. Za a kara jerin sunayen saukewa zuwa cell C1 na wannan littafi

02 na 06

Ƙirƙirar Ranaye Biyu

Ƙirƙirar Ranaye Biyu

Ƙididdiga mai suna yana ba ka damar komawa ga wasu kewayo a cikin takarda na Excel.

Jirgin da ake kira suna da amfani da yawa a Excel ciki har da yin amfani da su a cikin tsari da kuma lokacin da aka tsara sigogi.

A duk lokuta, ana amfani da layi mai suna a madadin kewayon tantancewar sel wanda ya nuna wurin samo bayanai a cikin takardun aiki.

Idan aka yi amfani da shi a jerin jerin saukewa a cikin wani littafi daban, dole a yi amfani da jeri biyu masu suna.

• An halicci ɗaya don abubuwan lissafi a cikin ɗakin littattafai inda aka samo bayanai
• An halicci na biyu a cikin ɗawainiyar inda aka samo jerin sunayen saukewa. Wannan na biyu mai suna suna haɗe zuwa haɗin mai suna a littafin farko

Tutorial Steps

Da farko da aka sanya Range

1. Zaɓi Kwayoyin A1 - A4 na littafin littattafan bayanai-source.xlsx don haskaka su
2. Danna kan Akwatin Akwatin da ke saman shafi na A
3. Rubuta "Kukis" (ba a faɗi) a cikin Akwatin Sunan ba
4. Danna maballin ENTER akan keyboard
5. Sel na A1 zuwa A4 na littafin labarun data-source.xlsx yanzu suna da sunan mahaɗin Kukis
6. Ajiye littafin

Sanya na Biyu wanda aka sanya

Wannan jeri na biyu mai suna ba ya amfani da bayanan salula daga jerin littattafan drop-down-list.xlsx .

Maimakon haka, za a, kamar yadda aka ambata, a haɗa zuwa sunan sunan Kukis a cikin littafin littafin data-source.xlsx .

Wannan yana da muhimmanci saboda Excel ba zai yarda da nassoshi na cell ba daga wani littafi daban-daban don layi mai suna. Zaiyi, duk da haka, sai dai wani sunan mahaifa.

Don haka, ƙirƙirar na biyu mai suna, saboda haka, ba a yi amfani da Akwatin Akwati ba amma ta amfani da zaɓi na Sunan mai suna located a kan Formulas tab na rubutun.

1. Danna kan tantanin halitta C1 a cikin littafi na drop-down-list.xlsx
2. Latsa Formulas> Manajan Sunan Rubuta don buɗe Gidan Rubutun Mai suna Manager
3. Danna maɓallin New don bude sabon akwatin maganganun New
4. A cikin Sunan layi: Data
5. A cikin Sakamakon zuwa layi irin: = 'data-source.xlsx'! Kukis
6. Danna Ya yi don kammala yanki mai suna kuma komawa cikin akwatin maganganun Name Manager
7. Danna Rufe don rufe adireshin mai suna Name Manager
8. Ajiye littafin

03 na 06

Ana buɗe akwatin maganganun Bayanan Bayanan

Ana buɗe akwatin maganganun Bayanan Bayanan

Duk zaɓuka ingantattun bayanan bayanai a Excel, ciki har da lissafin layi, an saita ta amfani da akwatin maganganu na tabbatar da bayanai.

Bugu da ƙari don ƙara jerin jerin sauƙaƙe zuwa takardar aiki, ana iya amfani da bayanan da ke cikin Excel don sarrafawa ko iyakance irin bayanai da za a iya shiga cikin ƙananan kwayoyin a cikin takardun aiki.

Tutorial Steps

1. Danna kan tantanin halitta C1 na lissafin drop-down-list.xlsx don sa shi tantanin halitta mai aiki - wannan shi ne inda za a ajiye lissafin saukewa
2. Danna kan Data shafin na ribbon menu sama da takardun aiki
3. Danna kan icon ɗin Shaidar Data akan rubutun don buɗe menu da aka sauke
4. Danna kan Zaɓin Bayanan Bayanan a cikin menu don bude akwatin maganganun Bayanin Bayanan
5. Ka bar akwatin maganganu don buɗe mataki na gaba a cikin koyawa

04 na 06

Amfani da Lissafi don Bayanin Bayanin Bayanai

Zabi Jerin Shaidar Bayanan

Kamar yadda aka ambata akwai adadin zaɓuɓɓuka don tabbatar da bayanai a Excel baya ga jerin saukewa.

A cikin wannan mataki za mu zaɓi zaɓi na Lissafi azaman nau'in bayanan bayanai don amfani da tantanin halitta D1 na takardar aiki.

Tutorial Steps

1. Danna kan Saituna shafin a cikin akwatin maganganu
2. Danna kan maɓallin ƙasa a ƙarshen Rabin layin don buɗe jerin menu da aka sauke
3. Latsa Lissafi don zaɓar jerin saukewa don tabbatar da bayanai a cikin ƙwayar C1 kuma don kunna tushen Layin cikin maganganu

Shigar da Bayanin Bayanin Bayanai da Ƙaddamar da Lissafin Lissafi

Tun lokacin da aka samo asusun bayanai don jerin abubuwan da aka sauke a kan wani littafi daban-daban, za a shigar da na biyu mai suna da aka tsara a baya a cikin Maɓallin tushen cikin akwatin maganganu.

Tutorial Steps

1. Danna maɓallin Yanayin
2. Rubuta "= Bayanan" (ba a samo asali) a cikin layin Lissafi ba
3. Danna Ya yi don kammala jerin jerin saukewa kuma rufe akwatin maganganun Bayanin Bayanan
4. Ƙaramin arrow icon wanda yake a gefen dama na cell C1
5. Danna kan arrow ya kamata ya buɗe jerin jerin saukewa da sunaye sunaye sun shiga cikin sassan A1 zuwa A4 na littafin littattafan data-source.xlsx.
6. Danna kan daya daga cikin sunaye ya shigar da wannan sunan zuwa cell C1

05 na 06

Canza Canjin Rage ƙasa

Canza Abubuwan Lissafin

Don ci gaba da lissafin sauƙaƙe har zuwa yau tare da canje-canje a cikin bayananmu, yana iya zama dole ya canza canjin lokaci cikin jerin.

Tun da mun yi amfani da sunan mai suna azaman tushen abubuwan da muke lissafin maimakon sunayen ainihin sunayen, canza sunayen kuki a cikin jerin suna da ke cikin sassan A1 zuwa A4 na littafin aiki na data-source.xlsx nan da nan ya canza sunaye a cikin saukewa jerin.

Idan an shigar da bayanai a cikin akwatin maganganu, yin canje-canje a cikin jerin sun hada da komawa cikin akwatin maganganu kuma shirya layin layi.

A wannan mataki za mu canza Lemon zuwa Shortbread a cikin jerin saukewa ta hanyar canza bayanan a cikin cell A2 na mahaɗin suna a cikin littafi na bayanai-source.xlsx .

Tutorial Steps

1. Danna kan A2 a cikin littafin littattafan data-source.xlsx (Lemon) don sa shi tantanin halitta mai aiki
2. Rubuta Shortbread a cikin cell A2 kuma latsa maɓallin Shigar da ke keyboard
3. Danna kan maɓallin ƙasa don jerin jerin saukewa a cikin cell C1 na lissafin drop-down-list.xlsx don bude jerin
4. Mataki na 2 a lissafi ya kamata a karanta Littafin rubutu a maimakon Lemon

06 na 06

Zaɓuɓɓuka don Kare Tsararren List

Zaɓuɓɓuka don Kare Tsararren List

Tun da bayanan mu a kan wani nau'i-nau'i daban daban daga jerin zaɓuɓɓukan jerin saukewa don kare lissafin lissafin sun haɗa da:

• Kare kayan aiki wanda ya haɗa da kulle kwayoyin A1 zuwa A4 akan takardar 2
• Ana buƙatar kalmar sirri don canza littafin
• Samun littafi ya buɗe azaman Read-only