Ƙirƙirar Rage List a cikin Excel Daga Wani Ɗauki

Samar da jerin jeri a cikin Excel ba ka damar shigar da bayanai zuwa cikin wani ƙirar takamaiman layin aiki daga jerin jerin shigarwar.

Amfanin amfani da jerin layi sun haɗa da:

• Yin sauki shigar da bayanai
• Tsarin kuskuren shiga bayanai
• Ƙuntata lambar wurare don shigar da bayanai

Jerin Drop-Down na Excel Daga mataki zuwa mataki Mataki Tutorial

• Shigar da Bayanan Tutorial
• Ƙirƙirar Rangi mai suna don Data
• Fara Shafin Drop-Down
• Amfani da Lissafi don Bayanin Bayanin Bayanai
• Shigar da Bayanin Bayanin Bayanai da Ƙaddamar Lissafin Drop-Down
• Canza Abubuwan Lissafin
• Zaɓuɓɓuka don Kare Tsararren List

Shigar da Bayanan Tutorial

Mataki na farko don ƙirƙirar jerin digo a Excel shine shigar da bayanai .

Lura: Umurni na koyawa ba sun haɗa da matakan tsarawa don aikin aiki ba.

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

Shigar da bayanan da ke ƙasa zuwa cikin kwayoyin da aka nuna akan zane-zanen daya da biyu na littafin littafin Excel.

Tutorial Steps

1. Shigar da wadannan bayanan zuwa cikin sassan daidai a kan Shine na 1 na takardun aiki: D1 - Kukis Type:
2. Danna kan shafin Shafi na Sheet 2.
   
3. Shigar da wadannan bayanan zuwa cikin sassan daidai a kan takarda na 2 na takardar aiki:
   A1 - Gingerbread A2 - Lemon A3 - Oatmeal Rabi A4 - Chip Chocolate

Za a kara jerin sunayen saukewa zuwa cell E1 a takardar 1.

Ƙirƙirar Rangi da aka sanya don Bayanin Lissafi

Ƙ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 jeri, ana amfani dakin mai amfani azaman tushen don abubuwan lissafi.

Tutorial Steps

1. Jawo zaɓi Kwayoyin A1 - A4 a Labarin 2.
2. Danna kan Akwatin Akwatin da ke saman shafi na A
3. Rubuta "kukis" (ba a faɗi) a cikin akwatin akwatin
4. Danna maballin ENTER akan keyboard
5. Sel A1 zuwa A4 a kan takardar 2 yanzu suna da sunan layin "kukis"
6. Ajiye aikinku ɗinku

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.

Kayan maganganun maganganun bayanan bayanai yana samuwa a ƙarƙashin bayanan shafin shafin rubutun .

Tutorial Steps

1. Danna kan shafin 1 na ƙasa a kasan allon don sauyawa zuwa takarda 1
2. Danna kan tantanin halitta E1 don sa shi tantanin halitta mai aiki - wannan shi ne inda za a kasance jerin jerin saukewa
3. Danna kan Data shafin na ribbon menu sama da takardun aiki
4. Danna kan icon ɗin Shaidar Data akan rubutun don buɗe menu da aka sauke
5. Danna kan Zaɓin Bayanan Bayanan a cikin menu don bude akwatin maganganun Bayanin Bayanan

Amfani da Lissafi don Bayanin Bayanin Bayanai

Bugu da ƙari don ƙara jerin jerin saukewa zuwa takardar aiki, ana iya amfani da bayanan bayanai a cikin Excel don sarrafawa ko iyakance irin bayanai da za a iya shiga cikin ƙananan sassan .

Wasu daga cikin hanyoyin da aka fi amfani da su:

• Jerin
• Dates da / ko sau
• Lambobi duka
• Rubutu
• Formulas (saita a ƙarƙashin zaɓi na Custom )

A cikin wannan mataki, za mu zaɓi zaɓi na Lissafi azaman nau'in bayanan bayanai don amfani da cell E1 a takardar 1.

Matakai

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ɓi jerin saukewa don tabbatar da bayanai a cikin cell D1 kuma don kunna tushen Layin a cikin maganganun maganganu

Shigar da Bayanin Bayanin Bayanai da Ƙaddamar da Lissafin Lissafi

Tun lokacin da aka samo asalin bayanan bayanai akan jerin saukewa a kan wani nau'in aiki na daban, za a shigar da sunan mai suna da aka tsara a baya a cikin Maɓallin Lantarki a cikin akwatin maganganu .

Matakai

1. Danna maɓallin Yanayin
2. Rubuta "= kukis" (babu tsayayyar) a cikin layi
3. Danna Ya yi don kammala jerin jerin saukewa kuma rufe akwatin maganganun Bayanin Bayanan
4. Ƙananan arrow icon dake a gefen dama na cell E1
5. Danna kan kiban ƙasa ya buɗe jerin jerin saukewa da sunaye sunaye sun shiga cikin sassan A1 zuwa A4 akan takarda 2
6. Danna kan daya daga cikin sunaye ya shigar da wannan sunan zuwa cikin cell E1

Ana gyara abubuwan Abubuwa

Don kiyaye jerin jerin saukewa har zuwa yau tare da canje-canje a bayananku, yana iya zama dole ya canza canjin lokaci a 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 layin da ake kira a cikin sassan A1 zuwa A4 a kan takarda 2 nan da nan ya canza sunaye a jerin jeri.

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 cikin wannan mataki, za mu canza Shortbread zuwa Oatmeal Raisin a cikin jerin saukewa ta hanyar sauya bayanan a cikin cell A3 na layin mai suna.

Matakai

1. Danna kan salula A3 akan takardar 2 (Shortbread) don yin sautin mai aiki
2. Rubuta Rabiyar Oatmeal a cikin sel A3 kuma danna maɓallin Shigar da ke keyboard
3. Danna kan maɓallin ƙasa don jerin jeri a cikin cell E1 na sheet 1 don buɗe jerin
4. Sashe na 3 a cikin lissafi ya kamata a karanta yanzu a raisin Oatmeal maimakon Shortbread

Zaɓuɓɓuka don Kare Tsararren List

Tun da yake bayanan mu a kan wani nau'i-nau'i daban daban daga jerin jerin saukewa akwai zaɓi biyu don kare bayanan lissafi:

• Ɓoye takardun aiki wanda ke dauke da bayanai (takarda 2)
• Kare kayan aiki wanda ya haɗa da kulle kwayoyin A1 zuwa A4 akan takardar 2

Idan tsaro ba damuwa bane, ɓoye aikin aiki wanda ke dauke da bayanan lissafin wani zaɓi ne mai kyau tun lokacin da ya sauƙaƙe don sabunta jerin idan aka buƙata.

Idan tsaro ya kasance damuwa za'a iya ƙaddamar da kalmar sirri a yayin kare nauyin aiki don hana canje-canje a cikin jerin abubuwa.

Ƙirƙirar Lissafin Lissafi a Tasiri daban-daban

Jerin jerin saukewa ya baka dama ka shigar da bayanai a cikin takarda na Excel daga jerin jerin shigarwa.

Sashe na 1 yana rufe matakai don ƙirƙirar jerin layi tare da bayanai a kan takaddun takaddun kamar jerin jerin sunayen.

Wannan koyaswar ya hada da samar da jerin digo a kan daban-daban ayyuka.

Misali: Samar da jerin saukewa tare da bayanai a kan daban-daban ayyuka

Shigar da wadannan bayanan a cikin sassan daidai a kan Labari na 1 na takardar aiki:
E1 - Kayan Kuki
D2 - Kukis Type:
Danna kan shafin Shafi na Sheet 2.
Shigar da wadannan bayanan zuwa cikin sassan daidai a kan takarda na 2 ko aikin aiki:
A1 - Gingerbread
A2 - Lemon
A3 - Oatmeal Raisin
A4 - Chip Chocolate
Fassara sel A1 - A4 a Labari 2.
Rubuta "kukis" (ba a faɗi) a cikin akwatin akwatin kuma danna maɓallin shigarwa akan keyboard.
Danna kan Shafin shafi na Sheet 1
Danna kan tantanin halitta E2 - wurin da za a nuna sakamakon
Danna kan Data shafin
Danna kan Zaɓin Bayanan Bayanan daga rubutun don buɗe menu
Danna kan Tabbacin Bayanan a cikin menu don gabatar da akwatin maganganu
Danna kan Saituna shafin a cikin akwatin maganganu
Daga Shafin menu zaɓi Jerin
Rubutun = kukis akan layin Layin a cikin akwatin maganganu
Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki
Dole ya sauka a gefen tantanin halitta E2
Lokacin da ka danna kan arrow, jerin jerin saukewa su bude don nuna sunayen sunaye hudu