Yadda za a ƙirƙiri / Cire wani Sauke List a Excel

Jerin layi ko menus za a iya ƙirƙirar a cikin Excel don iyakance bayanai da za a iya shiga cikin ƙirar ta musamman zuwa jerin jerin shigarwa. Amfanin amfani da jerin layi don tabbatar da bayanai sun hada da:

• Samar da shigar bayanai cikin sauki;
• hana kurakuran shigar da bayanai;
• ƙuntata lambar wurare don shigar da bayanai.

Jerin Lissafi da Lissafi

Bayanin da aka kara zuwa jerin abubuwan da aka sauke za a iya zama a kan:

1. wannan aikin rubutu kamar jerin.
2. a kan takarda daban daban a cikin littafin littafin Excel ɗin .
3. a cikin takarda daban na Excel.

Matakai na Ƙirƙirar Lissafi

Matakai da aka yi amfani da su don ƙirƙirar jerin layi da aka nuna a cikin sakonni B3 (nau'in cookie) a cikin hoto a sama sune:

1. Danna kan tantanin halitta B3 don sa shi tantanin halitta ;
2. Danna kan Data shafin na kintinkiri ;
3. Danna kan Amincin Bayanan don buɗe jerin abubuwan da za a iya saukewa;
4. A cikin menu, danna kan Shaidar Bayanan don kawo akwatin maganganun Bayanan Bayanan;
5. Danna kan Saituna shafin a cikin akwatin maganganu;
6. Danna kan Zaɓin Izinin a cikin akwatin maganganu don buɗe menu da aka saukewa - darajar tsoho ne Duk wani darajar;
7. A cikin wannan menu, danna Jerin ;
8. Danna maɓallin Yanayin cikin akwatin maganganu;
9. Fassara sel E3 - E10 a cikin takardun aiki don ƙara bayanai a wannan jeri na sel zuwa jerin;
10. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki;
11. Dole ne ya sauka a kusa da tantanin halitta B3 yana nuna gaban jerin abubuwan da aka sauke;
12. A yayin da ka danna kan kibiyar zaɓin da za a bude don nuna sunayen takwas na cookie;

Lura: Abun da ke nuna alama a gaban jerin layi yana bayyane kawai lokacin da aka sanya tantanin halitta tantanin halitta mai aiki.

Cire Dattiyar Lissafi a cikin Excel

Da zarar an gama shi da jerin saukewa za a iya cire shi daga wani siginar aiki ta amfani da akwatin maganganu na tabbatar da bayanai kamar yadda aka nuna a hoton da ke sama.

Lura : Idan motsi da jerin saukewa ko bayanan bayanan wuri zuwa sabon wuri a kan wannan aikin aiki, bazai zama dole ba don sharewa da sake sake jerin jerin sauƙaƙe kamar yadda Excel zai sabunta tasirin bayanan da aka yi amfani dashi don jerin .

Don cire lissafin drop-down:

1. Danna kan tantanin halitta dauke da jerin saukewa don cirewa;
2. Danna maɓallin Data shafin na kintinkiri ;
3. Danna madogarar Bayanan Bayanin Labarai a kan rubutun don buɗe menu da aka sauke;
4. Danna Zaɓin Bayanin Bayanin Bayanai a cikin menu don bude akwatin maganganun Bayanin Bayanin Bayanai;
5. A cikin akwatin maganganu, danna kan Saituna shafin - idan ya cancanta;
6. Danna maɓallin Maɓallin Bayyana don cire jerin sauƙi kamar yadda aka nuna a hoton da ke sama;
7. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki .

Dole a cire wannan lissafin sauƙaƙan da aka zaɓa daga cell din da aka zaɓa, amma duk bayanan da aka shiga cikin tantanin halitta kafin a cire lissafi zai kasance kuma dole ne a share shi daban.

Don cire duk Drop Down List a kan Shafin Farko

Don cire duk jerin sunayen da aka sauke a kan takardun aiki ɗaya a lokaci guda:

1. Yi matakai ɗaya ta hanyar biyar a cikin sharuɗɗan a sama;
2. Bincika Aiwatar da waɗannan canje-canje a duk sauran kwayoyin tare da wannan saitunan saitunan Saituna shafin na maganganu;
3. Danna kan Maɓallin Bayyana duk don cire duk jerin sunayen da aka sauke a kan aikin aiki na yanzu.
4. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki.