Kodi ndingachotse bwanji mizere yonse yopanda kanthu mu Excel zokha

Luso logwira ntchito ndi pulogalamu ya Excel ndiyothandiza kwambiri kwa oimira ntchito zambiri. M'nkhaniyi, tikambirana zinthu zingapo - makamaka, chifukwa chake kuchotsa mizere mu Excel pogwiritsa ntchito "sankhani maselo opanda kanthu -> chotsani mzere" si lingaliro labwino kwambiri. Tidzasanthulanso 3 Njira Zofulumira komanso Zodalirika Zochotsera Mizere Yopanda kanthu choncho, kotero kuti zisawononge chidziwitso m'maselo ena mwanjira iliyonse. Mayankho onse amagwira ntchito ku Excel 2019, 2016, 2013 ndi kale.

3 Njira Zofulumira komanso Zodalirika Zochotsera Mizere Yopanda kanthu 

Popeza mukuwona nkhaniyi pano, ndi zomveka kuganiza kuti, monga ena ambiri, muyenera kuchita nawo pafupipafupi. Excel spreadsheets zazikulu kwambiri. Mwayi kuti mwakumanapo ndi zochitika zomwe mizere yopanda kanthu, kuletsa zida zambiri zomangidwa kuti zisazindikire molondola kuchuluka kwa deta. Choncho, nthawi iliyonse, muyenera kufotokoza malire pamanja - mwinamwake mudzapeza zotsatira zolakwika, ndipo zidzakutengerani nthawi yoposa ola limodzi kuti muzindikire ndi kukonza zolakwika zoterozo. 

Pakhoza kukhala zifukwa zosiyanasiyana zomwe mizere yopanda kanthu imawonekera - mwachitsanzo, muli ndi fayilo ya Excel kuchokera kwa wina, kapena fayiloyo idatumizidwa kuchokera ku database ina, kapena mwachotsa mwangozi zambiri m'mizere yosafunikira. Muzochitika zilizonse, ngati mukufuna chotsani mizere yopanda kanthu ndipo chifukwa chokhala ndi tebulo loyera komanso lokongola, muyenera kuchita mndandanda wa njira zosavuta. Tiyeni tiwone zochitika zingapo pamitu iyi:

• Chifukwa chiyani simuyenera kuchotsa mizere yopanda kanthu posankha ma cell opanda kanthu.
• Momwe mungachotsere mizere yonse yopanda kanthu pomwe pali gawo lalikulu.
• Momwe mungachotsere mizere yonse yopanda kanthu pomwe palibe gawo lofunikira.
• Momwe chida cha Delete Empty Lines chimagwiritsidwira ntchito, komanso chifukwa chake ndichosavuta, komanso chofunikira kwambiri, njira yachangu kwambiri.

Osachotsa mizere yopanda kanthu posankha ma cell opanda kanthu  

Pa intaneti, nthawi zambiri mungapeze malangizo awa:

• Sankhani maselo onse omwe ali ndi chidziwitso, kuyambira woyamba mpaka wotsiriza.
• Dinani fungulo F5 - Zotsatira zake, bokosi la zokambirana "Kusintha".
• Pawindo lomwe limatsegulira, dinani "yosangalatsa".
• Pawindo "Kusankha gulu la maselo» sankhani njira «maselo opanda kanthu", ndiye"OK".
• Dinani kumanja pa selo iliyonse yosankhidwa, kenako sankhani "Chotsani…".
• Mkati mwa zenera lotsegukaKuchotsa ma cell» dinani pa njira «chingwe". 

Mwatsoka, iyi si njira yabwino - igwiritseni ntchito pamagome ang'onoang'ono pomwe mizere ikuwonetsedwa pazenera, kapenanso bwino - osachigwiritsa ntchito konse.

Izi ndichifukwa choti ngati pali selo limodzi lokha lopanda kanthu pamzere wokhala ndi chidziwitso chofunikira, mzere wonsewo umachotsedwa. 

Tiyeni tione chitsanzo. Pamaso pathu pali tebulo la makasitomala, momwemo mokha 6 nthawi. Ife tikufuna chotsani mzere wachitatu ndi wachisanu, popeza alibe kanthu.

Gwiritsani ntchito njira yomwe ili pamwambayi ndipo mupeza zotsatirazi:

Mzere 4 (Rojer) ukusowanso, chifukwa mu gawo la "Traffic source".  cell D4 ilibe kanthu.

Popeza muli ndi tebulo laling'ono, mudzatha kupeza kusowa kwa chidziwitso, koma m'matebulo akuluakulu omwe ali ndi mizere masauzande ambiri, mutha kufufuta mizere yambiri yofunikira popanda kudziwa. Ngati muli ndi mwayi mudzawona kuti ikusowa mu maola angapo, bwezeretsani fayilo yanu kuchokera kubwererandiyeno chitaninso. Koma bwanji ngati mulibe mwayi kapena mulibe zosunga zobwezeretsera? 

Tiyeni tione Njira 3 Zofulumira komanso Zodalirika Zochotsera Mizere Yopanda kanthu kuchokera pamasamba anu a Excel. Ndipo ngati mukufuna kusunga nthawi yanu - pitani mwachindunji 3 njira.

Chotsani mizere yonse yopanda kanthu pamene pali gawo lalikulu

The njira ntchito ngati muli ndi gawo lokuthandizani kudziwa ngati chingwe chilibe kanthu kapena ayi (chomwe chimatchedwa ndime yofunika). Mwachitsanzo, iyi ikhoza kukhala nambala yoyitanitsa, kapena ID yamakasitomala, kapena zina zofananira.

Tiyenera kuchoka mndandanda wa zingwe zosasinthika, chifukwa chake, kungosanja ndi gawoli ndikusintha mizere yopanda kanthu mpaka kumapeto kwa tebulo sikungagwire ntchito. Ndiye ndikuyenera kuchita.

1. Sankhani tebulo kwathunthu, kuyambira pa 1 mpaka mzere womaliza (kuti muchite izi, mutha kuyimitsa nthawi imodzi. Ctrl + Panyumba, Komanso - Ctrl + Shift + End).

2. Khalani Zosintha zokha: pitani ku tabu "Deta” ndipo dinani batani "fyuluta".

3. Kenako, muyenera kuyika zosefera pagawo la "Cust #" ("Kasitomala No."): dinani muvi wotsikira pansi "Autofilter" m'zachigawo, sankhani (sankhani zonse), pukutani mpaka kumapeto (kwenikweni mndandandawo ndi wautali), ndiye chongani bokosi lakuti “Empty”… Dinani OK.

4. Phatikizani mizere yonse yosefedwa: chifukwa cha izi mutha kugwira nthawi yomweyo Ctrl + Panyumba, kenako batani la pansi kuti mubwererenso pamzere woyamba, kenako gwirani Ctrl + Shift + End.

5. Dinani kumanja pa selo iliyonse yosankhidwa ndikudina "Chotsani mzere»kapena ingosindikizani Ctrl + - (chizindikiro chochotsera).

6. Dinani batani OK poyankha funsoChotsani nthawi yonse ya kalatayo?»

7. Kenako muyenera kuchotsa zosefera zomwe zayikidwa: kuti muchite izi, pitani ku "Deta” ndipo dinani batani "woyera".

8. Ntchito yabwino! Mizere yopanda kanthu yapita, ndipo mzere wachitatu (Rojer) udakalipo (kufananiza, mutha kulozera ku mtundu wakale).

Chotsani mizere yonse yopanda kanthu pamene palibe mzati wachinsinsi    

Gwiritsani ntchito izi njirangati muli ndi tebulo muntchito yanu yokhala ndi maselo ambiri opanda kanthu omwe amaikidwa m'mizere yosiyanasiyana, ndipo mukufuna kuchotsa ndendende mizere yomwe mwamtheradi opanda kanthu.

ndime yofunika, zomwe zingagwiritsidwe ntchito kuti mudziwe ngati chingwecho chilibe kanthu kapena ayi, chikusowa mu chitsanzo chathu. Zoyenera kuchita? Ife tokha pangani ndime yowonjezera:

1. Pangani Mzere wakuti “Zopanda kanthu” (“Maselo opanda kanthu”) kumapeto kwenikweni kwa tebulo lanu, kenako lembani mu selo loyamba la gawoli. chilinganizo: = COUNTBLANK (A2: C2).

izi chilinganizo amawerengera ma cell opanda pake omwe adalembedwa zosiyanasiyana, kumene A2 ndi selo loyamba, C1 ndi selo lomaliza.

2. Koperani chilinganizo kwa ma cell onse omwe ali muzanja.

3. Tsopano tili nazo ndime yofunika. Kenako gwiritsani ntchito sefa mu ndime ya "Zosalemba kanthu" (malangizo atsatanetsatane pamwambapa) kuti muwonetse mizere yokhala ndi mtengo wokwanira (3). "3" amatanthauza zotsatirazi: maselo onse pamzere alibe kanthu.

4. Kenako sankhani zonse mizere yosefedwa ndi kuchotsa kwathunthu chopanda kanthupogwiritsa ntchito malangizo omwe tafotokoza kale.

Chifukwa chake mzere wopanda kanthu (mzere 5) kuchotsedwa, ndi mizere yokhala ndi chidziwitso chofunikira khalani m'malo.

5. Kenako, chotsani ndime yowonjezera. Sizidzafunikanso. Kapena mukhoza kuika ina sefa ndikuwonetsa mizere pomwe pali selo limodzi kapena angapo opanda kanthu.

Kuti muchite izi, sankhani fayilo0", ndiye dinani"OK".

Kugwiritsa ntchito chida cha Chotsani Empty Lines ndiyo njira yabwino komanso yachangu kwambiri  

Njira yachangu komanso yopanda cholakwika kuchotsa mizere yopanda kanthu ndi chidaChotsani mizere yopanda kanthu”, zophatikizidwa mu kit Ultimate Suite kwa Excel.

Mwa zina zothandiza Nchito lili ndi zingapo zofunikira, zomwe zimalola kudina kumodzi kusuntha mizati pokoka; Chotsani maselo onse opanda kanthu, mizere ndi mizati, komanso zosefera ndi mtengo wosankhidwa, kuwerengera maperesenti, gwiritsani ntchito masamu aliwonse pamasamu osiyanasiyana, kukopera ma adilesi a cell pa clipboard ndi zina zambiri.

Momwe mungachotsere mizere yopanda kanthu munjira zinayi zosavuta

Kugwiritsa ntchito Ultimate Suite, kuphatikizapo zoyikidwa ku pulogalamu ya Excel, ndizomwe mukufuna do:

1. Dinani pa chilichonse selo patebulo.
2. Dinani tabu zida Zokwanira > Transform Group.
3. Press Chotsani mizere yopanda kanthu > Mizere yopanda kanthu.

4. atolankhani OKkutsimikizira kuti mukufunadi kuchotsa mizere yopanda kanthu.

Ndizomwezo! Kungodinanso pang'ono ndipo mupeza tebulo loyera, mizere yopanda kanthu yapita, ndipo dongosolo la mizere silinasokonezedwe!