Contents
A cikin wannan labarin, zan bayyana dalilin da yasa ake cire layuka marasa tushe a cikin Excel ta amfani da su haskaka sel mara komai > share layi mummunan ra'ayi ne, kuma zan nuna muku hanyoyi guda 2 masu sauri da daidai don cire layukan da ba su da tushe ba tare da lalata bayanan ba. Duk waɗannan hanyoyin suna aiki a cikin Excel 2013, 2010, da tsofaffin sigogin.
Idan kuna karanta wannan labarin, to wataƙila kuna aiki koyaushe a cikin Excel tare da manyan tebur. Kun san cewa layuka marasa tushe lokaci-lokaci suna bayyana a cikin bayanan, suna iyakance aikin mafi yawan kayan aikin tebur na Excel (rarraba, cire kwafi, juzu'i, da sauransu), yana hana su tantance iyakar bayanai daidai. Kuma kowane lokaci dole ne ku ƙayyade iyakokin da hannu, in ba haka ba sakamakon zai zama sakamakon da ba daidai ba kuma lokaci mai yawa da aka kashe don gyara kurakurai.
Akwai dalilai da yawa da ya sa babu layukan bayyana. Misali, kun karɓi littafin aikin Excel daga wani mutum ko sakamakon fitarwa daga bayanan kamfanoni, ko kuma an share bayanan da ba dole ba a cikin layuka da hannu. A kowane hali, idan burin ku shine cire duk waɗannan layukan da ba su da tushe kuma ku sami tebur mai tsabta da tsafta, to ku bi matakai masu sauƙi a ƙasa:
Kada a taɓa share layukan da ba komai ba tare da zaɓin cell mara komai
A duk cikin intanit, za ku sami hanya mai sauƙi wacce za ta ba ku damar cire layukan da ba su da komai:
- Zaɓi bayanan daga na farko zuwa tantanin halitta na ƙarshe.
- latsa F5don buɗe maganganun Ka tafi zuwa ga (Tsarin Mulki).
- A cikin akwatin maganganu, danna maɓallin Special (Haske).
- A cikin akwatin maganganu Je zuwa na musamman (Zaɓi ƙungiyar sel) duba akwatin blanks (Bakwai Kwayoyin) kuma danna OK.
- Danna-dama akan kowane ɗayan sel da aka zaɓa kuma latsa share (Share).
- A cikin akwatin maganganu share (Goge sel) zaɓi Gaba ɗaya jere (layi) kuma danna OK.
Wannan hanya ce mara kyau., Yi wannan kawai tare da tebur masu sauƙi tare da layuka biyu na dozin waɗanda suka dace akan allo ɗaya, ko ma mafi kyau - kar a yi haka kwata-kwata! Babban dalili shine idan layin da ke da mahimman bayanai ya ƙunshi akalla tantanin halitta mara komai, to Za a share duk layin.
Misali, muna da tebur abokin ciniki tare da layuka 6 gabaɗaya. Muna son cire layi 3 и 5domin babu komai.
Yi kamar yadda aka ba da shawara a sama kuma sami sakamako mai zuwa:
line 4 (Roger) shima ya bace saboda tantanin halitta D4 a cikin wani shafi Hanyar zirga-zirga ya juya ya zama fanko
Idan tebur ɗinku bai yi girma ba za ku lura da asarar bayanai, amma a cikin tebur na ainihi tare da dubban layuka za ku iya share layuka masu yawa da suka dace ba da sani ba. Idan kun yi sa'a, za ku sami asarar a cikin ƴan sa'o'i kaɗan, mayar da littafin aiki daga madadin, kuma ku ci gaba da aiki. Idan aka yi rashin sa'a kuma ba ku da madaidaicin fa'ida?
Daga baya a cikin wannan labarin, zan nuna muku hanyoyi 2 masu sauri da aminci don cire layuka marasa tushe daga zanen Excel.
Cire layuka marasa komai ta amfani da ginshiƙin maɓalli
Wannan hanyar tana aiki idan tebur ɗin ku yana da ginshiƙi wanda ke taimakawa tantance ko ginshiƙin da ake tambaya ba komai bane ko a'a (lambar maɓalli). Misali, yana iya zama ID na abokin ciniki ko lambar oda, ko wani abu makamancin haka.
Yana da mahimmanci a gare mu mu adana tsarin layuka, don haka ba za mu iya tsara tebur ta wannan ginshiƙi don matsar da duk layuka marasa komai ba.
- Zaɓi duk teburin, daga jere na farko zuwa na ƙarshe (latsa Ctrl + Gida, sai me Ctrl + Shift + Ƙarshe).
- Ƙara autofilter zuwa tebur. Don yin wannan, a kan tab data (data) danna Tace (Tace).
- Aiwatar da tace zuwa ginshiƙi Cust#. Don yin wannan, danna maɓallin kibiya a cikin taken shafi, cire alamar zaɓi zabi All (Zaɓi Duk), gungura ƙasa zuwa ƙarshen lissafin (a aikace, wannan jeri na iya ɗaukar tsayi sosai) kuma duba akwatin. blanks (Ba komai) a kasan lissafin. Danna OK.
- Zaɓi duk layukan da aka tace: danna Ctrl + Gida, sannan kibiya ta ƙasa don matsawa zuwa layin farko na bayanai, sannan danna Ctrl + Shift + Ƙarshe.
- Danna-dama akan kowane zaɓaɓɓen tantanin halitta kuma daga menu na mahallin zaɓi Share layi (Share layi) ko kawai danna Ctrl + -(alamar cirewa).
- A cikin taga wanda ya bayyana tare da tambaya Share dukan jeri na takarda? (Grege duk layin layi?) danna OK.
- Share matatar da aka yi amfani da ita: akan shafin data (data) danna Sunny (Bayyanannu)
- Madalla! Dukkan layukan da babu komai an cire su gaba daya, kuma layin 3 (Roger) har yanzu yana cikin wurin (kwatanta da sakamakon ƙoƙarin da ya gabata).
Cire layuka marasa komai a cikin tebur ba tare da ginshiƙin maɓalli ba
Yi amfani da wannan hanyar idan tebur ɗin ku yana da sel mara komai a warwatse a ginshiƙai daban-daban, kuma kuna buƙatar share waɗancan layuka waɗanda ba su da kowane sel da bayanai.
A wannan yanayin, ba mu da ginshiƙi mai maɓalli don taimakawa sanin ko kirtani ba komai ko a'a. Don haka, muna ƙara ginshiƙi na taimako zuwa teburin:
- A ƙarshen tebur, ƙara shafi mai suna blanks kuma liƙa wannan dabarar a cikin tantanin halitta na farko na ginshiƙi:
=COUNTBLANK(A2:C2)=СЧИТАТЬПУСТОТЫ(A2:C2)Wannan dabarar, kamar yadda sunanta ke nunawa, tana ƙirga sel mara komai a cikin kewayon da aka bayar. A2 и C2 su ne sel na farko da na ƙarshe na jere na yanzu, bi da bi.
- Kwafi dabarar zuwa gaba dayan ginshiƙi. Yadda ake yin wannan – duba umarnin mataki-mataki Yadda ake saka dabara iri ɗaya cikin duk sel da aka zaɓa lokaci ɗaya.
- Yanzu teburin mu yana da ginshiƙi maɓalli! Aiwatar da tace zuwa ginshiƙi blanks (a sama shine jagorar mataki zuwa mataki kan yadda ake yin wannan) don nuna layuka kawai tare da matsakaicin ƙimar (3). Lamba 3 yana nufin cewa duk sel a wannan jere ba komai bane.
- Na gaba, zaɓi duk layukan da aka tace kuma share su gaba ɗaya. Yadda ake yin haka an bayyana a sama. Sakamakon haka, layin da babu komai (layi na 5) zai goge, duk sauran layin (tare da ko babu komai) za su kasance a wurinsu.
- Yanzu ana iya cire ginshiƙin taimako. Ko kuma kuna iya amfani da wani tacewa don nuna waɗancan sel waɗanda ke da sel ɗaya ko fiye da komai. Don yin wannan, cire alamar layin tare da ƙimar 0 (sifili) kuma danna OK.
