Maitiro ekudzima ese asina Blank Row muExcel

Muchikamu chino, ini ndichatsanangura chikonzero nei uchibvisa mitsara isina chinhu muExcel uchishandisa simbisa masero asina chinhu > bvisa mutsara ipfungwa yakaipa, uye ini ndichakuratidza 2 nzira dzinokurumidza uye dzakaringana dzekubvisa mitsara isina chinhu pasina kuparadza data. Idzi nzira dzese dzinoshanda muExcel 2013, 2010, uye shanduro dzekare.

Kana iwe uri kuverenga chinyorwa ichi, saka kazhinji iwe unogara uchishanda muExcel nematafura makuru. Iwe unoziva kuti mitsara isina chinhu nguva nenguva inooneka pakati pe data, ichidzikamisa basa reakawanda eExcel tafura maturusi (kuronga, kubvisa zvakapetwa, subtotals, zvichingodaro), zvichivadzivirira kubva mukunyatso kutarisisa huwandu hwe data. Uye nguva imwe neimwe yaunofanirwa kutsanangura nemaoko miganhu, zvikasadaro chigumisiro chichava chigumisiro chisina kururama uye nguva yakawanda inoshandiswa pakugadzirisa zvikanganiso.

Pane zvikonzero zvakawanda nei mitsetse isina chinhu ichioneka. Semuenzaniso, wakagamuchira bhuku rekushanda reExcel kubva kune mumwe munhu kana semhedzisiro yekutumira kunze kubva kune yekambani dhatabhesi, kana data isingaite mumitsara yakadzimwa nemaoko. Chero zvazvingava, kana chinangwa chako chiri chekubvisa ese aya mitsara isina chinhu uye uine tafura yakachena uye yakatsvinda, tevera matanho ari pasi apa:

• Usambofa wadzima mitsetse isina chinhu nesero sarudzo isina chinhu
• Kubvisa mitsetse isina chinhu uchishandisa kiyi column
• Kubvisa mitsara isina chinhu mutafura isina kiyi column

Usambofa wadzima mitsetse isina chinhu nesero sarudzo isina chinhu

Pese pawebhusaiti, iwe unowana zano rakareruka iro rinofungidzirwa kuti rinokutendera kuti ubvise mitsetse isina chinhu:

• Sarudza data kubva kune yekutanga kusvika kune yekupedzisira sero.
• dzvanya F5kuvhura dialog Enda ku (Shanduro).
• Mubhokisi rehurukuro, tinya bhatani Special (Simbisa).
• Mubhokisi rehurukuro Enda kune yakakosha (Sarudza boka remasero) tarisa bhokisi blanks (Empty masero) uye tinya OK.
• Tinya-kurudyi pane chero masero akasarudzwa wodzvanya Kudzima (Delete).
• Mubhokisi rehurukuro Kudzima (Delete masero) sarudza Mutsara wose (mutsara) uye dzvanya OK.

Iyi inzira yakaipa kwazvo., ita izvi chete nematafura akareruka ane gumi nemaviri mitsara inokodzera pane imwe skrini, kana kunyange zvirinani - usaite izvozvo zvachose! Chikonzero chikuru ndechekuti kana mutsara une data rakakosha rine kanenge sero rimwe chete risina chinhu, saka mutsara wese uchadzimwa.

Semuenzaniso, tine tafura yevatengi ine mitsara ye6 muhuwandu. Tinoda kubvisa mitsetse 3 и 5nokuti havana chinhu.

Ita sezvataurwa pamusoro uye uwane mhedzisiro inotevera:

mutsetse 4 (Roger) akanyangarikawo nekuti sero D4 muchikamu Traffic sosi panga pasina

Kana tafura yako isiri yakakura iwe uchaona kurasikirwa kwedata, asi mumatafura chaiwo ane zviuru zvemitsara unogona kusaziva kudzima akawanda emitsara inodiwa. Kana iwe uine rombo rakanaka, iwe unowana kurasikirwa mukati memaawa mashoma, dzosera bhuku rebasa kubva kune backup, uye ramba uchishanda. Ko kana usina rombo rakanaka uye usina backup?

Gare gare muchinyorwa chino, ini ndichakuratidza nzira mbiri dzinokurumidza uye dzakavimbika dzekubvisa mitsara isina chinhu kubva kuExcel sheet.

Kubvisa mitsetse isina chinhu uchishandisa kiyi column

Iyi nzira inoshanda kana tafura yako iine koramu inobatsira kuona kana iyo column iri mubvunzo haina chinhu kana kwete (iyo kiyi koramu). Semuenzaniso, inogona kunge iri ID yemutengi kana nhamba yekuodha, kana chimwe chinhu chakafanana.

Zvakakosha kuti isu tichengetedze kurongeka kwemitsara, saka hatigone kungorongedza tafura nekoramu iyo kuti tiise mitsetse isina chinhu pasi.

1. Sarudza tafura yose, kubva kune yekutanga kusvika kune yekupedzisira (press Ctrl + Imba, uye ipapo Ctrl + Shift + End).
2. Wedzera imwe autofilter patafura. Kuti uite izvi, pane tab Data (data) tinya firita (Sefa).
3. Isa sefa pambiru Cust#. Kuti uite izvi, tinya bhatani remuseve mumusoro wekoramu, uncheck sarudzo Sarudza zvose (Sarudza Zvese), skira pasi kusvika kumagumo echinyorwa (mukuita, runyorwa urwu runogona kureba) uye tarisa bhokisi. blanks (Chisina chinhu) pazasi chaipo pechinyorwa. Dzvanya OK.
4. Sarudza mitsetse yese yakasefa: tinya Ctrl + Imba, ipapo museve wepasi kuti uende kumutsara wekutanga wedata, wobva wadzvanya Ctrl + Shift + End.
5. Tinya-kurudyi pane chero sero yakasarudzwa uye kubva pane yemukati menyu sarudza Delete row (Delete line) kana kungodzvanya Ctrl + -(minus sign).
6. Pahwindo rinoonekwa nemubvunzo Delete rese sheet row? (Delete rese sheet row?) tinya OK.
7. Bvisa sefa yakashandiswa: pane tab Data (data) tinya Clear (Bvisa).
8. Zvakanakisa! Mitsetse yose isina chinhu inobviswa zvachose, uye mutsara 3 (Roger) ichiri munzvimbo (enzanisa nemugumisiro wekuedza kwekare).

Kubvisa mitsara isina chinhu mutafura isina kiyi column

Shandisa nzira iyi kana tafura yako iine akawanda masero asina chinhu akapararira pamakoramu akasiyana, uye iwe unofanirwa kudzima chete iwo mitsara isina maseru ane data.

Muchiitiko ichi, isu hatina mbiru yakakosha yekubatsira kuona kana tambo isina chinhu kana kwete. Naizvozvo, isu tinowedzera mbiru yekubatsira patafura:

1. Pakupera kwetafura, wedzera koramu ine zita blanks uye namatidza fomura inotevera musero rekutanga rekoramu:

   =COUNTBLANK(A2:C2)

   =СЧИТАТЬПУСТОТЫ(A2:C2)

   Iyi fomula, sekureva kwezita rayo, inoverenga maseru asina chinhu muchikamu chakapihwa. A2 и C2 ndiwo masero ekutanga uye ekupedzisira emutsetse wazvino, zvichiteerana.

   

2. Kopa fomula kune iyo column yese. Maitiro ekuita izvi - ona nhanho-ne-nhanho kuraira Maitiro ekuisa iyo yakafanana formula mumaseru akasarudzwa kamwechete.
3. Zvino tafura yedu ine kiyi koramu! Isa sefa pambiru blanks (pamusoro pane nhanho nhanho gwara rekuita izvi) kungo ratidza mitsara ine huwandu hunokosha (3). Number 3 zvinoreva kuti maseru ese ari mumutsara uyu haana chinhu.
4. Tevere, sarudza mitsara yese yakasefa uye woidzima zvachose. Nzira yekuita izvi inotsanangurwa pamusoro apa. Nekuda kweizvozvo, mutsara usina chinhu (mutsara 5) uchabviswa, mamwe ese mitsara (ane kana asina masero asina chinhu) acharamba ari munzvimbo yawo.
5. Iye zvino mbiru yekubatsira inogona kubviswa. Kana kuti iwe unogona kuisa imwe sefa kuratidza chete iwo maseru ane rimwe kana mamwe maseru asina chinhu. Kuti uite izvi, bvisa mutsara nehuwandu 0 (zero) uye tinya OK.