Ndingadzima sei mitsara yese isina chinhu muExcel otomatiki

Unyanzvi hwekushanda neExcel program zvechokwadi hunobatsira kune vamiririri vemabasa mazhinji. Muchinyorwa chino, tichatarisa akati wandei nyaya - kunyanya, sei kubvisa mitsara muExcel uchishandisa "sarudza masero asina chinhu -> bvisa mutsara" chirongwa harisi iro rakanakisa zano. Tichaongororawo 3 Kurumidza uye Kuvimbika Nzira dzekubvisa Blank Lines saka, kuitira kuti irege kukuvadza ruzivo mune mamwe masero neimwe nzira. Yese mhinduro inoshanda kuExcel 2019, 2016, 2013 uye yapfuura.

3 Kurumidza uye Kuvimbika Nzira dzekubvisa Blank Lines 

Sezvo uri kuona chinyorwa ichi parizvino, zvine musoro kufunga kuti iwe, sevamwe vazhinji, unofanirwa kugara uchitarisana nazvo. excel maspredishiti ehukuru hwakakura. Mikana yekuti wakasangana nemasituations uko mitsetse isina chinhu, kudzivirira akawanda ezvishandiso zvakavakwa kubva pakuziva zvakarurama huwandu hwe data. Nokudaro, nguva imwe neimwe, iwe unofanirwa kutsanangura miganhu nemaoko - kana zvisina kudaro iwe uchawana chigumisiro chisina kunaka, uye zvinotora nguva inopfuura awa imwe yenguva kuti uone nekugadzirisa zvikanganiso zvakadaro. 

Panogona kuve nezvikonzero zvakasiyana nei mitsara isina chinhu ichioneka - semuenzaniso, iwe wakawana faira reExcel kubva kune mumwe munhu, kana iyo faira yakatumirwa kubva kune imwe dhatabhesi, kana iwe netsaona kudzima ruzivo mumitsara yausingadiwe. Chero mamiriro ezvinhu, kana iwe uchida bvisa mitsetse isina chinhu uye semugumisiro kuti uve netafura yakachena uye yakanaka, unoda kuuraya akatevedzana matanho nyore. Ngatitarisei mamwe mashoma chaiwo mamiriro pamisoro inotevera:

• Sei usingafaniri kubvisa mitsara isina chinhu nekusarudza masero asina chinhu.
• Nzira yekubvisa sei mitsara yese isina chinhu kana paine kiyi column.
• Nzira yekubvisa sei mitsara yese isina chinhu kana pasina kiyi column.
• Mashandisiro anoita Delete Empty Lines chishandiso, uye nei chiricho chiri nyore, uye chinonyanya kukosha, nzira inokurumidza.

Usabvisa mitsara isina chinhu nekusarudza maseru asina chinhu  

PaInternet, unogona kazhinji kuwana mazano anotevera:

• Sarudza maseru ese ane ruzivo, kubva pa1 kusvika pekupedzisira.
• Dhinda kiyi F5 -Nekuda kweizvozvo, iyo dialog bhokisi "Shanduko".
• Mukati mehwindo rinovhurwa, tinya "Highlight".
• Pahwindo"Kusarudza boka remasero»sarudza sarudzo «masero asina chinhu", zvino"OK".
• Tinya-kurudyi pane chero sero rakasarudzwa, wobva wasarudza “Delete...".
• Mukati mefafitera rinovhurikaKudzima maseru» tinya pane iyo sarudzo «tambo". 

Zvinosuruvarisa, iyi haisiyo nzira yakanakisa -ishandise chete kumatafura madiki uko mitsara inoratidzwa mukati mechidzitiro, kana kunyange zvirinani - usashandise zvachose.

Izvi zvinokonzerwa nenyaya yekuti kana paine sero rimwe chete risina chinhu mumutsara rine ruzivo rwakakosha, mutsara wese unodzimwa. 

Ngatitarisei muenzaniso. Pamberi pedu pane tafura yevatengi, mairi chete 6 temu. Tinoda bvisa mitsara yechitatu neyechishanu, sezvo vasina chinhu.

Shandisa nzira iri pamusoro uye iwe uchawana zvinotevera:

Mutsara wechina (Rojer) haupo zvakare, nekuti mu "Traffic source" column  cell D4 haina chinhu.

Sezvo uine tafura duku, iwe uchakwanisa kuwana kushaya data, asi mumatafura makuru ane zviuru zvemitsara, unogona kudzima akawanda emitsara inodiwa usingatombozviziva. Kana iwe uine rombo rakanaka uchaona kuti yashaikwa mumaawa mashoma, dzosa faira rako kubva negadziriro yeparutiviwozviita zvakare. Asi zvakadini kana iwe usina rombo rakanaka kana usina backup? 

Ngatitarisei 3 Dzakakurumidza uye Dzakavimbika Nzira dzekubvisa Blank Lines kubva kune yako Excel spreadsheets. Uye kana iwe uchida kuchengetedza nguva yako - enda zvakananga kune 3rd nzira.

Bvisa mitsetse yese isina chinhu kana paine kiyi koramu

The nzira mabasa chero iwe uine koramu yekukubatsira kuona kana tambo isina chinhu kana kwete (inonzi kiyi column) Semuenzaniso, iyi inogona kunge iri nhamba yeoda, kana ID yemutengi, kana chimwe chinhu chakafanana.

Tinofanira kubva tambo kutevedzana isina kuchinjika, saka, kungorongedza nekoramu iyi uye kushandura mitsetse yese isina chinhu kusvika kumagumo etafura hazvishande. Saka manje unofanirwa kuita.

1. Sarudza tafura zvachose, kubva pa1 kusvika kumutsara wekupedzisira (kuita izvi, unogona kubata pasi panguva imwe chete. Ctrl + Imba, Uyezve - Ctrl + Shift + End).

2. Set Autofilter: enda kune tab "Data” uye tinya bhatani "firita".

3. Tevere, iwe unofanirwa kuisa sefa kune "Cust #" ("Mutengi Kwete.") koramu: tinya pane inodonha-pasi museve "Autofilter" muzita rekoramu, bvisa (sarudza zvese), skira pasi kusvika kumagumo (chaizvoizvo runyorwa rwakareba), ipapo tarisa bhokisi rakanzi “Empty”… Tinya OK.

4. Sanganisa mitsara yose yakasvibiswa: nokuda kweizvi unogona kubata pasi panguva imwe chete Ctrl + Imba, ipapo bhatani remuseve wepasi kuti udzokere kumutsetse wekutanga zvakare, wobva wabata Ctrl + Shift + End.

5. Tinya-kurudyi pane chero sero rakasarudzwa wodzvanya pakanzi "Bvisa mutsara»kana kungodzvanya Ctrl + – (minus sign).

6. Dzvanya pane bhatani OK pakupindura mubvunzoUnodzima nguva yese yetsamba?»

7. Ipapo iwe unofanirwa kujekesa iyo yakaiswa sefa: kuita izvi, enda kune "Data” uye tinya bhatani "zvakachena".

8. Basa rakanaka! Mitsetse yese isina chinhu yaenda, uye mutsara wechitatu (Rojer) uchiripo (kuenzanisa, unogona kutarisa kune yakapfuura vhezheni).

Bvisa mitsetse yese isina chinhu kana pasina kiyi column    

Shandisa izvi nzirakana uine tafura mubasa rako ine nhamba huru yemasero asina chinhu akaiswa mumakoroni akasiyana-siyana, uye iwe unoda kudzima chaizvo mitsara iyo. zvachose pasina.

kiyi column, iyo inogona kushandiswa kuona kana tambo isina chinhu kana kuti kwete, inoshaikwa mumuenzaniso wedu. Kuita sei? Isu pachedu gadzira imwe column:

1. sika column "Marange" ("Empty cells") kumucheto chaiko kwetafura yako, wobva wanyora musero rekutanga rekoramu iyi. fomura: = COUNTBLANK (A2: C2).

ichi Formula inoverenga masero asina chinhu mune zvakatemwa dungwerungwe, apo A2 ndiyo 1st sero, C2 ndiyo yekupedzisira sero.

2. mufananidzo fomura kumaseru ese ari mukoramu.

3. Iye zvino tawana kiyi column. Zvadaro shandisa firita mu "Blanks" column (yakadzama mirairo pamusoro) kuratidza mitsara ine huwandu hunokosha (3). “3” zvinoreva zvinotevera: maseru ese ari mumutsara haana chinhu.

4. Zvadaro sarudza zvose mitsara yakasefa uye bvisa zvachose Zvisina chinhuuchishandisa mirairo yakambotaurwa.

Saka mutsara usina chinhu (mutsara 5) yakabviswa, uye mitsetse ine ruzivo rwakakosha ramba uri panzvimbo.

5. Zvadaro, bvisa imwe column. Hazvichadiwi zvakare. Kana kuti unogona kuisa imwe firita uye kuratidza mitsara pane imwe kana mamwe maseru asina chinhu.

Kuti uite izvi, uncheck the0", wobva wadzvanya"OK".

Kushandisa Bvisa Empty Lines chishandiso ndiyo nzira iri nyore uye inokurumidza  

Iyo inokurumidza uye isina kukanganisa nzira yekubvisa mitsara isina chinhu chishandisoBvisa mitsetse isina chinhu”, yakabatanidzwa mukiti Ultimate Suite yeExcel.

Pakati pezvimwe zvinobatsira mabasa ine akati wandei zvishandiso, iyo inobvumira kudzvanya kamwe chete kufambisa makoramu nekudhonza; dzima maseru ese asina chinhu, mitsara nemakoramu, pamwe nesefa nehuwandu hwakasarudzwa, verenga maperesenti, shandisa chero yakakosha masvomhu kushanda kune renji, kopi kero yesero kuclipboard uye zvimwe zvakawanda.

Maitiro ekubvisa mitsara isina chinhu mumatanho mana ari nyore

Kushandisa Ultimate Suite, kuwedzera yakaiswa kuExcel chirongwa, ndizvo zvaunoda do:

1. Dzvanya pane chero chitokisi patafura.
2. Dzvanya iyo tab Tools Zvinogoneka > Shandura Boka.
3. dzvanya Bvisa mitsetse isina chinhu > Mitsetse isina chinhu.

4. dzvanya OKkuratidza kuti unoda chaizvo Bvisa mitsetse isina chinhu.

Ndizvo zvose! Kungobaya zvishoma uye iwe uchawana tafura yakachena, mitsetse yose isina chinhu yaenda, uye kurongeka kwemitsara hakuna kukanganisa!