Cómo Eliminar Filas en Blanco en Excel

Munzvimbo yespredishiti, Excel yave chishandiso chakakosha chinoshandiswa nemamiriyoni evanhu pasi rese kuronga uye ongorora data. Zvakadaro, zvakajairikawo kuwana maspredishiti ane mitsara isina chinhu inogona kukanganisa kushanda nesimba uye nemazvo ekuverenga. Muchikamu chino, isu tichaongorora nzira dzehunyanzvi dzekubvisa zvinobudirira uye nekukurumidza iwo mitsara isina chinhu muExcel, ichikubvumidza iwe kukwidziridza data rako uye nekuvandudza kunaka kwekuongorora kwako. Kana iwe uri mushandisi weExcel uchitsvaga kuwedzera kugadzirwa uye mhando yemaspredishiti ako, verenga kuti uwane nzira yekudzima mitsara isina chinhu muExcel!

1. Nhanganyaya yekudzima mitsetse isina chinhu muExcel

Kudzima mitsara isina chinhu muExcel ibasa rinowanzoita kana uchishanda nemaseti makuru edata. Iyi mitsetse isina chinhu inogona kuita kuti zviome kuongorora nekuronga ruzivo. Neraki, Excel inopa akati wandei maturusi uye matekiniki ekunyatso bvisa iyi isina mitsara uye kufambisa mafambiro ako.

Nzira iri nyore yekubvisa mitsara isina chinhu ndeye kushandisa basa kusefa muexcel. Ichi chinokutendera kuti uratidze mitsara chete inosangana nemamwe maitiro, seaya ane data. Kuti uite izvi, sarudza iyo data renji yaunoda kubvisa isina mitsara uye enda ku "Data" tab mu. mudziyo wekushandisa. Wobva wadzvanya bhatani re "Sefa" uye sarudza iyo "Not Empty" sefa kuratidza chete mitsara ine data.

Chimwe chishandiso chinobatsira ndeye "Tsvaga uye Sarudza" murairo. Iwe unogona kuwana uyu murairo uchishandisa nzira yekudimbudzira yekhibhodi "Ctrl + F" kana kubva "Kumba" tebhu mubhara rekushandisa. Kana bhokisi rebhokisi ravhurika, sarudza iyo "Enda kune Special" tebhu uye sarudza iyo "Chisina" sarudzo yekusimbisa ese asina chinhu maseru mune yakasarudzwa renji. Iwe unogona ipapo kudzima mitsara isina chinhu nekusarudza iyo "Delete Rows" sarudzo kubva kumenyu.

2. Kuziva Mitsetse isina Kujeka muExcel Spreadsheet

Pane nzira dzinoverengeka dzekuona mitsara isina chinhu muExcel spreadsheet. Pazasi pane matanho anodiwa kugadzirisa nyaya iyi:

1. Shandisa "Tsvaga uye Sarudza" basa: Basa iri rinobatsira zvikuru kukurumidza kuziva mitsara isina chinhu muspredishiti. Kuti uishandise, tevera matanho aya:

• Abre la hoja de cálculo en Excel.
• Sarudza chikamu chaunoda kutsvaga mitsara isina chinhu.
• Dzvanya pane "Home" tab mu toolbar.
• Dzvanya "Tsvaga uye Sarudza" uye sarudza "Enda kune Special."
• Mu "Enda kune Special" dialog box, sarudza "Blank" uye tinya "OK."
• Masero ese asina chinhu ari muchikamu chakasarudzwa achasarudzwa.

2. Shandisa fomula: Imwe nzira yekuziva mitsara isina chinhu ndeyekushandisa fomula muExcel. Heino muenzaniso wekuti ungazviita sei:

• Abre la hoja de cálculo en Excel.
• Sarudza sero paunoda kuratidza fomula mhinduro.
• Nyora fomula = IF(ISBLANK(A1),»Mutsetse usina chinhu»,»Hapana mutsara usina chinhu»).
• Tsiva A1 nesero rekutanga mukoramu yaunoda kutarisa.
• Dzvanya Enter uye icharatidza "Blank Row" kana sero risina chinhu, kana "No Blank Row" kana sero riine chero kukosha.
• Dhonza fomula pasi kuti utarise mitsara yasara.

3. Shandisa macro: Kana iwe uchida kuziva mitsara isina chinhu mumaspredishiti nguva dzose, zvinogona kubatsira kugadzira macro muExcel. Macros zvirongwa zvidiki zvinodzokorodza otomatiki mabasa. Kugadzira macro inoratidza mitsara isina chinhu, tevera matanho aya:

• Abre la hoja de cálculo en Excel.
• Dzvanya Alt + F11 kuti uvhure Visual Basic Mharidzo.
• Dzvanya "Insert" uye sarudza "Module."
• Nyora kodhi inotevera mumodule:

«`vba
Sub IdentifyBlankRows()
Dim cell As Range
Kune Imwe neimwe sero In Selection.Masero
Kana IsEmpty(sero) Zvadaro
cell.Interior.Color = RGB(255, 0, 0)
Kuguma Kana
Sero rinotevera
Chikamu Chekupedzisira
«`

Iyi kodhi inotenderera nemaseru akasarudzwa uye kuratidza chero masero asina chinhu mune tsvuku. Iwe unogona kupa iyi macro kune bhatani kuti uishandise nekudzvanya kamwe chete pese paunoda.

3. Nzira dzekudzima mitsara isina chinhu nemaoko muExcel

Kudzima mitsara isina chinhu nemaoko muExcel kunogona kunetesa kana uine mahombe data seti. Nenzira yakanaka, kune nzira dzakawanda dzinoita kuti basa iri rive nyore. Pazasi pane nzira nhatu dzakasiyana dzekudzima mitsara isina chinhu muExcel:

1. Shandisa sefa: Nzira yekukurumidza uye iri nyore yekubvisa mitsara isina chinhu ndeye kushandisa sefa basa muExcel. Kuti uite izvi, tevera matanho aya:

• Sarudza chikamu chaunoda kusefa.
• Enda kune "Data" tab uye tinya "Sefa."
• Mukoramu yawasarudza, isa sefa kuti iratidze chete mibairo isina chinhu.
• Sarudza mitsara yakasefa uye woidzima.

2. Shandisa "Tsvaga uye Sarudza" basa: Imwe nzira yekudzima mitsara isina chinhu nemaoko ndeye kushandisa "Tsvaga uye Sarudza" basa. Tevera matanho aya:

• Sarudza maseru ese ari muspredishiti.
• Enda kune "Kumba" tebhu uye tinya "Tsvaga uye Sarudza."
• Sarudza "Enda kune Special" uye wobva wasarudza "Masero asina chinhu."
• Dzvanya kiyi "Delete" kana "Delete" kudzima mitsetse isina chinhu.

3. Shandisa fomula: Kune avo vanoziva mafomula muExcel, unogona zvakare kushandisa fomula kudzima mitsara isina chinhu. Tevera matanho aya:

• Inowedzera mbiru yekubatsira padivi pe data.
• Musero rekutanga rekoramu yekubatsira, isa fomula "=ISBLANK(A2)" (apo "A2" iri sero riri mukoramu yekutanga yedata).
• Dhova fomula pasi kuti uiise kumitsara yese yedata.
• Inosefa koramu yekubatsira ne "Chokwadi" uye inodzima mitsara yakasefa.

Kudzima nemaoko mitsara isina chinhu muExcel kunogona kutora nguva, asi nenzira idzi unogona kukurumidza kuita uye kuona kuti data rako rakachena uye rakarongeka. Rangarira kuchengetedza a kuchengetedza usati waita chero shanduko huru kune yako data.

4. Kushandisa mabasa uye mafomula kudzima mitsara isina chinhu muExcel

Pane nzira dzinoverengeka dzekudzima mitsara isina chinhu muExcel uchishandisa mabasa uye mafomula. Tevere, isu ticharondedzera nzira mbiri dzinokubatsira kugadzirisa dambudziko iri nenzira iri nyore.

Nzira 1: Kushandisa iyo FILTER basa

1. Sarudza iyo column kana huwandu hwe data yaunoda kubvisa isina mitsara.

2. Enda kune tab Data wobva wadzvanya pa Sefa kuti uvhure sefa pane iyo column.

3. Mumusoro wembiru, tinya museve unooneka wosarudza sarudzo Delete mitsara isina chinhu.

4. Yakagadzirira! Mitsara isina chinhu yakabviswa uye chete data rakakodzera mumutsara wakasarudzwa ndiro richaratidzwa.

Nzira 2: Kushandisa iyo COUNTA basa

1. Isa mutsara mutsva pedyo nedheta raunoda kubvisa mitsara isina chinhu.

2. Musero mumutsara wekutanga wekoramu itsva, isa fomula =COUNT(C2:C100) (reemplaza C2:C100 nekoramu inoenderana uye data renji).

3. Dhonza fomula pasi kuti uiise kumitsara yese mukoramu.

4. Sarudza koromo yefomula uye shandisa basa Values ​​sefa kuratidza chete mitsara ine kukosha kusiri zero mukoramu yefomula.

Idzi nzira dzinokutendera kuti ubvise nekukurumidza mitsara isina chinhu kubva kune yako data muExcel, kufambisa kuona uye kuongororwa kwemashoko. Edza nhanho idzi uye shandisa zvakanyanya eExcel mashandiro uye mafomula ekukwidziridza yako data manejimendi mabasa.

5. Kuita otomatiki kubviswa kwemitsara isina chinhu ine macros muExcel

Kudzima mitsara isina chinhu muExcel kunogona kuve basa rinonetesa uye rinotora nguva kana richiitwa nemaoko. Nekudaro, nerubatsiro rwemacros, zvinokwanisika kuita otomatiki iyi maitiro uye kuchengetedza nguva nesimba. Muchikamu chino, tichakuratidza kuti ungaita sei basa iri. zvinobudirira kushandisa macros muExcel.

Chekutanga pane zvese, zvakakosha kuyeuka kuti macro nhevedzano yemirairo uye zviito zvinoitwa otomatiki muExcel. Kuti utange, vhura Excel uye enda ku "Developer" tebhu mubhara rekushandisa. Kana iwe usingaone iyi tebhu, unogona kuigonesa nekuenda ku "Faira"> "Sarudzo"> "Gadzirisa Ribhoni" uye kusarudza "Developer" kubva pane rondedzero yematabu aripo.

Kana uchinge wavhura iyo "Developer" tab, tinya "Rekodha Macro" uye ipa macro yako zita. Iva nechokwadi chekusarudza zita rinotsanangura richakubatsira kuziva basa raro. Tevere, sarudza nzvimbo yaunoda kuti macro ichengetedzwe uye tinya "Zvakanaka." Kubva panguva ino, Excel ichatanga kurekodha zvese zvaunoita muspredishiti.

6. Zvishandiso zvePamusoro zvekunyatsodzima Mitsara isina chinhu muExcel

Kudzima mitsara isina chinhu muExcel inogona kuve inofinha uye inopedza nguva kana ukasashandisa maturusi akakodzera. Neraki, pane sarudzo dzepamberi dzinogona kuita kuti basa iri rive nyore uye rinonatsiridza zvakanyanya kushanda zvakanaka. Heano maturusi matatu anobatsira ekukurumidza kudzima mitsara isina chinhu muExcel:

Chishandiso 1: Otomatiki Sefa
Iyo Otomatiki Sefa ibasa rakavakirwa muExcel iro rinokutendera kuti kusefa uye kuratidza chete yaunoda data muspredishiti. Kuti ushandise chishandiso ichi, sarudza koramu ine data uye tinya pane "Sefa" mu "Data" tab. Wobva wasarudza iyo "Sefa nezvisina chinhu" sarudzo kuratidza chete mitsetse isina chinhu. Iwe unogona ipapo kusarudza mitsara yese yakasefa uye woidzima kamwechete.

Chombo 2: SUM Formula
Zvimwe nzira inoshanda Nzira yekudzima mitsara isina chinhu muExcel ndeye kushandisa iyo SUM formula. Iyi fomula inowedzera kukosha kwea huwandu hwemasero uye, kana ikaiswa padanho rine mitsetse isina chinhu, mhedzisiro ichaita zero. Kuti ushandise chishandiso ichi, gadzira imwe koramu padivi pe data uye shandisa fomula "= SUM(RANK)" pamutsetse wega wega wedata. Wobva wasefa mitsara ine kukosha kwe zero mukoramu yehuwandu uye woidzima.

Chishandiso 3: VBA Macro
Kana iwe uchida kudzima mitsara isina chinhu nguva nenguva kana muhuwandu hukuru, unogona kushandisa VBA macro. Macros zvinyorwa zvinoshandura mabasa muExcel. Kugadzira macro inobvisa mitsara isina chinhu, vhura VBA mupepeti nekudzvanya "ALT + F11" wobva waisa kodhi inotevera:

«`vb
Sub DeleteBlankRows()
Dim LastFila Nenguva Yakareba
LastRow = Masero(Rows.Count, 1).End(xlUp).Row
For i = LastRow Ku 1 Danho -1
Kana WorksheetFunction.CountA(Rows(i)) = 0 Zvadaro
Mitsara(i).Delete
Kuguma Kana
Inotevera ini
Chikamu Chekupedzisira
«`

Sevha uye vhara iyo VBA mupepeti, wobva wamhanya iyo macro nekudzvanya "ALT + F8" uye kusarudza "DeleteBlankRows." Iyi macro ichabvisa mitsetse yese isina chinhu kubva paspredishiti zvinobudirira uye nekukurumidza. Rangarira kuchengetedza backup yefaira rako usati wamhanyisa macro, kana zvikaitika.

7. Kukosha kwekudzima mitsara isina chinhu yekuongorora data muExcel

Rimwe remabasa akakosha e ongorora data muExcel ndeyekubvisa mitsara isina chinhu inogona kukanganisa kurongeka uye kuvimbika kwemhedzisiro. Iyi mitsara isina chinhu inogona kukanganisa mafomula uye mabasa anoshandiswa kune data, pamwe nekuunza zvikanganiso mukuverenga. Kuti uve nechokwadi chekutendeseka kwekuongorora kwako, zvinodikanwa kubvisa iyi mitsetse isina chinhu usati watanga maitiro.

Kudzima mitsara isina chinhu muExcel inzira iri nyore inogona kuitwa nekutevera matanho aya:

1. Sarudza iyo column ine data nemitsara yaunoda kuongorora.
2. Enda kune "Kumba" tebhu pane Excel toolbar.
3. Dzvanya bhatani re "Tsvaga uye Sarudza" uye sarudza "Enda kune Special" sarudzo.
4. Mubhokisi rehurukuro rinoonekwa, sarudza "Masero asina chinhu" uye tinya "Zvakanaka."
5. Mitsara isina chinhu icharatidzwa uye yakasarudzwa muspredishiti.
6. Tinya-kurudyi pane imwe yemitsara yakasarudzwa uye sarudza iyo "Delete" sarudzo kubva pane yekudonha-pasi menyu.
7. Sarudza "Delete Rows" uye mitsara isina chinhu ichabviswa kubva paspredishiti.

Zvakakosha kuziva kuti usati wadzima mitsara isina chinhu, zvinokurudzirwa kuchengetedza kopi yekuchengetedza yedata rako kuti urege kurasikirwa neruzivo rwakakosha. Pamusoro pezvo, nzira iyi inogona kushandiswawo kubvisa makoramu asina chinhu nekutevera nhanho dzakafanana, asi nekusarudza iyo "Blank Cells" sarudzo pachinzvimbo che "Blank Rows." Nekubvisa iyi mitsara isina chinhu kana makoramu, iwe unozogona kuwana yakanyanya kunyatso uye yakavimbika mhedzisiro mukuongorora kwako data muExcel.

8. Mazano uye maitiro akanakisa paunenge uchidzima mitsara isina chinhu muExcel

Kudzima mitsara isina chinhu muExcel inogona kuve basa rinonetesa, asi nemamwe matipi uye maitiro akanaka, unogona kuzviita nemazvo. Heano mamwe ekurudziro achakubatsira iwe kuita izvi nekukurumidza uye zvinobudirira:

1. Sefa data: Shandisa sefa basa muExcel kuratidza chete mitsara ine data. Nenzira iyi, iwe unozokwanisa kuona mitsara isina chinhu zvakajeka uye nyore kuisarudza kuti ibvise.
2. Shandisa iyo Tsvaga uye Kutsiva chimiro: Iwe unogona kushandisa "Tsvaga uye Dzorera" basa kuti uwane uye kubvisa mitsara isina chinhu kubva paspredishiti rako. Ingo tsvaga iyo isina chinhu kukosha ("") uye woitsiva isina chinhu. Ita shuwa kuti wasarudza "Tsvaga mu: Values" sarudzo kuitira kuti kutsvaga kuitwe paspredishiti rese.
3. Shandisa VBA macro: Kana iwe uine huwandu hukuru hwe data uye uchida kudzima mitsara isina chinhu pane inodzokororwa, unogona kugadzira VBA macro kuti uite otomatiki maitiro. Nerubatsiro rweVBA programmer, unogona kugadzirisa macro kuti ikwane zvaunoda uye kubvisa mitsara isina chinhu nekukurumidza uye nemazvo.

9. Gadzirisa matambudziko akajairika paunodzima mitsara isina chinhu muExcel

Kuti ubvise mitsara isina chinhu muExcel, pane mhinduro dzakasiyana dzinogona kukubatsira kukwenenzvera basa rako uye kuita kuti maspredishiti ako ashande. Hedzino dzimwe sarudzo dzekufunga nezvadzo:

1. Sefa uye bvisa mitsara isina chinhu: Nzira yekukurumidza uye iri nyore yekubvisa mitsara isina chinhu ndeye kushandisa sefa basa muExcel. Ingosarudza koramu yaunoda kusefa, enda kune "Data" tab uye tinya bhatani re "Sefa". Tevere, bvisa bhokisi rekutarisa mitsara isina chinhu uye sarudza sarudzo yekudzima mitsara yakasefa.
2. Shandisa VLOOKUP basa: Kana iwe uchida kudzima mitsara isina chinhu otomatiki, unogona kushandisa Excel's VLOOKUP basa. Iri basa rinokutendera kuti utsvage kukosha kwakasiyana mukoromo uye wodzosa kukosha kunoenderana kubva kune imwe mbiru mumutsara wakafanana. Kuti ushandise chimiro ichi, unofanirwa kudoma chirevo chekutsvaga chinowanikwa pamitsara yese yaunoda kudzima.
3. Macro yekubvisa mitsara isina chinhu: Kana iwe uine yakawanda mitsara isina chinhu uye uchida kuidzima zvakanyanya, unogona kugadzira macro muExcel. A macro seti yemirairo inoitwa otomatiki kuita rimwe basa. Iwe unogona kurekodha macro inosefa uye inobvisa isina mitsara, uye wobva waimhanyisa chero paunoda.

Aya angori mamwe emhinduro dzakajairika kudzima mitsara isina chinhu muExcel. Imwe neimwe sarudzo ine yayo zvakanakira nezvakaipira, saka tinokurudzira kuedza nzira dzakasiyana uye kusarudza iyo inonyatsoenderana nezvido zvako. Gara uchiyeuka kuchengetedza faira yako usati waita chero shanduko, kudzivirira chero kurasikirwa kwedata.

10. Maitiro ekudzima mitsara isina chinhu muExcel mumaseti makuru edata

Kudzima mitsara isina chinhu muExcel inogona kuve basa rinonetesa kana uchishanda nemaseti makuru edata. Sezvineiwo, kune nzira dzinoverengeka dzekuita basa iri nemazvo uye nekukurumidza. Pazasi pane chidzidzo nhanho nhanho Kudzima mitsara isina chinhu muExcel:

1. Shandisa mafirita: Nzira iri nyore yekubvisa mitsara isina chinhu ndeyekushandisa mafirita basa muExcel. Kutanga, sarudza tafura yose yedata. Wobva waenda kune "Data" tab uye tinya "Sefa." Masefa achaonekwa mumakoramu ese. Sarudza sefa yekoramu yaunofunga kuti ine mitsara isina chinhu uye tinya iyo "isina" sarudzo. Izvi zvinongoratidza chete mitsetse isina chinhu mukoramu iyoyo. Tevere, sarudza ese asina mitsara anoratidzwa uye woadzima.

2. Shandisa "Tsvaga uye Sarudza" basa: Imwe nzira yekudzima mitsara isina chinhu ndeyokushandisa "Find and Select" basa muExcel. Kutanga, sarudza maseru ese ari patafura yedata. Zvadaro, enda ku "Kumba" tab uye tinya pane "Tsvaga uye sarudza" sarudzo. Kubva pane yekudonha-pasi menyu, sarudza "Enda kune Special." Muwindo rehurukuro, sarudza iyo "Masero asina chinhu" uye tinya "Zvakanaka." Izvi zvichasarudza maseru asina chinhu mutafura yedata. Tevere, tinya-kurudyi pane rimwe masero akasarudzwa uye sarudza iyo "Delete" sarudzo. Sarudza "Delete Row" kudzima ese akasarudzwa mitsara isina chinhu.

11. Kushanda Kushandisa Nyaya dzekudzima Mitsara isina Kujeka muExcel

Patinoshanda nemaspredishiti muExcel, zvakajairika kuwana mitsara isina chinhu isina chero data. Iyi mitsara isina chinhu inogona kunetsa sezvo inogona kukanganisa kuona uye kuongororwa kwedata. Neraki, Excel inopa nzira dzinoverengeka dzekudzima iyi mitsetse isina chinhu nekukurumidza uye nyore. Zvimwe zvicharatidzwa pasi apa.

1. Shandisa Sefa basa: Nzira yekukurumidza kubvisa mitsara isina chinhu ndeyokushandisa Excel's Filter basa. Kuti uite izvi, sarudza data yespredishiti uye enda kune "Data" tab. Dzvanya "Sefa" uye wosarudza "Sefa nemaitiro asina chinhu" sarudzo. Izvi zvichasefa data uye kuratidza chete mitsara ine zvakakosha. Iwe unogona ipapo kukopa uye kunama iyo yakasefa data muspredishiti nyowani.

2. Shandisa basa reKutsvaga uye Kutsiva: Imwe nzira yekubvisa mitsetse isina chinhu ndeyokushandisa Excel's Tsvaga uye Kutsiva basa. Sarudza data yespredishiti uye enda kune "Kumba" tab. Dzvanya pakanzi “Tsvaga uye Tsiva” uye pafafitera rinovhurika, siya ndima ya “Tsvaga” isina chinhu uye muchikamu che“Tsvaga ne” isa chimiro chakakosha, senge nzvimbo isina chinhu kana hyphen (-). Wobva wadzvanya "Siva Zvese" uye Excel ichabvisa ese asina mitsara nekuitsiva neyakakosha hunhu hwawakaisa.

12. Kuchengetedza kuvimbika kwedata paunenge uchidzima mitsetse isina chinhu muExcel

Kudzima mitsara isina chinhu muExcel kunogona kukubatsira kuchengetedza kuvimbika kwedata uye kugadzirisa kurongeka kwespredishiti rako. Dzimwe nguva kana iwe ukashanda nedata rinotengeswa kunze kwenyika kana kukopi kubva kune mamwe masosi, unogona kupedzisira uine mitsara isina chinhu iyo inowedzera kusakosha pakuongorora kwako uye kungotora nzvimbo mufaira rako. Sezvineiwo, kune nzira dzinoverengeka dzekubvisa iyi mitsetse isina chinhu nekukurumidza uye nemazvo.

Nzira iri nyore yekubvisa mitsara isina chinhu ndeye kushandisa mafirita maficha muExcel. Kutanga, sarudza makoramu ese ari muspredishiti rako. Wobva waenda kune "Data" tab pane toolbar uye tinya "Filter" bhatani. Miseve midiki ichaonekwa mumutsara wekutanga wekoramu yega yega. Dzvanya museve wekoramu yaunoda kusefa uye usatarise bhokisi re "White". Izvi zvichasefa mitsetse yese isina chinhu mukororamu iyoyo. Dzokorora maitiro ekoramu yega yega uye pakupedzisira sarudza mitsara yakasefa woidzima.

Imwe nzira yekudzima mitsara isina chinhu ndeye kushandisa "Tsvaga" uye "Sarudza" mabasa muExcel. Kutanga, sarudza spreadsheet yose. Wobva waenda ku "Kumba" tebhu pane bhatani rekushandisa uye tinya "Tsvaga uye Sarudza" bhatani uye sarudza "Enda kuna." Muhwindo rinooneka, sarudza "Special" sarudzo uye ipapo "Blank." Izvi zvichasarudza maseru asina chinhu muspredishiti chako. Unogona kudzima mitsara yese yakasarudzwa nekudzvanya-kurudyi pane imwe yemitsara yakasarudzwa uye kusarudza iyo "Delete" sarudzo.

13. Kuenzanisa nzira dzakasiyana dzekudzima mitsara isina chinhu muExcel

• Imwe yezvinetso zvakajairika pakushanda nedata muExcel kuvepo kwemitsara isina chinhu, iyo inogona kukanganisa kurongeka uye kurongeka kweruzivo. Neraki, kune nzira dzakasiyana dzinotibvumira kubvisa iyi mitsara isingakoshi uye nekuvandudza kunaka kwedata redu.
• Nzira iri nyore yekubvisa mitsara isina chinhu ndeye kushandisa basa Automatic Sefa. Kuti uite izvi, ingosarudza koramu ine data uye tinya "Sefa" tebhu mubhara rekushandisa. Tevere, shandisa iyo "Otomatiki Sefa" sarudzo uye uncheck bhokisi rinoenderana nemitsara isina chinhu. Nenzira iyi, mitsara chete ine data ndiyo icharatidzwa, zvichiita kuti zvive nyore kudzima.
• Imwe nzira inoshanda ndeyekushandisa basa Tsvaga uye kutsiva. Kuti uite izvi, sarudza huwandu hwemasero aunoda kuchenesa, tinya "Kumba" tebhu uye sarudza "Tsvaga uye Sarudza" kubva pane yekudonha-pasi menyu. Wobva wasarudza iyo "Replace" sarudzo uye siya nzvimbo yekutsvaga isina chinhu. Mundima ye "Siva ne" pinda nzvimbo isina chinhu. Pakupedzisira, tinya "Dzorera Zvese" uye mitsetse isina chinhu inobviswa ipapo ipapo. Iyi nzira inonyanya kubatsira kana mitsara isina chinhu ichipararira mudhadha re data.

14. Mhedziso uye kurudziro yekupedzisira yekudzima mitsara isina chinhu muExcel

Kana tangoongorora nzira dzakasiyana dzekudzima mitsara isina chinhu muExcel, tinogona kusvika kune dzimwe mhedziso dzekupedzisira. Kurudziro yekutanga ndeye kushandisa "Tsvaga uye Tsiva" basa kuona uye kudzima mitsara isina chinhu muspredishiti. Iri basa rinotibvumira kutsvaga chaiyo kukosha, mune iyi kesi isina chinhu, uye kuitsiva isina chinhu, nokudaro kubvisa mitsara isina chinhu. Pamusoro pezvo, tinogona kushandisa tsvaga uye kutsiva sarudzo paspredishiti rese kuti tive nechokwadi chekuti mitsetse yese isina chinhu inobviswa zvakanaka.

Imwe sarudzo yekudzima mitsara isina chinhu ndeye kushandisa macros muExcel. A macro seti yemirairo inotitendera kuti tiite otomatiki kudzokorora mabasa muExcel. Tinogona kugadzira macro inotarisa mitsara isina chinhu uye kuibvisa otomatiki. Izvi zvinotichengetera nguva nesimba, kunyanya kana tikashanda nemaspredishiti makuru kana tichida kudzima mitsetse isina chinhu nguva nenguva. Kugadzira macro, isu tinongorekodha script muExcel uye topa iyo bhatani kana kiyi musanganiswa kuti iite nyore.

Chekupedzisira, zvakakosha kuratidza kukosha kwemafomula muExcel kubvisa mitsara isina chinhu. Tinogona kushandisa fomula ine zvirevo, senge "IF" basa, kutarisa kana sero risina chinhu uye kudzima mutsara unoenderana. Semuenzaniso, tinogona kushandisa fomula «=IF(A1=»», «», A1)» kukopa zviri mukati mesero A1 chete kana isina chinhu. Zvadaro, tinogona kudhonzera fomula pasi kuti tiiise kune ese maseru mukoramu uye nekudzima mitsara isina chinhu otomatiki.

Mukupedzisa, kudzima mitsara isina chinhu muExcel ibasa riri nyore asi rakakosha kugadzirisa uye kushanda nemazvo nemaseti makuru edata. Kuburikidza nenzira dzakasiyana siyana, senge kusarudzwa kwemaoko, kushandiswa kwemafomula kana kushandisa macros, takaongorora nzira dzakasiyana dzekubvisa iyi mitsara isingakoshi.

Izvo zvakakosha kuti uzive kuti kubvisa mitsara isina chinhu hakungonatsiridza kutaridzika kwegwaro, asiwo kunodzivirira matambudziko emangwana kana uchiita masvomhu kana kuongorora data. Mukuwedzera, nekusunungura nzvimbo, nzira yekuverenga nekugadzirisa ruzivo inokurumidza kukurumidza, kuchengetedza nguva nekuedza.

Rangarira kuti kwakaringana manejimendi data kwakakosha kune chero nyanzvi inoshanda neExcel, ingave mubhizinesi, yedzidzo kana yemunhu. Kudzima mitsara isina chinhu chimwe chezvishandiso zvakawanda zvinopihwa neExcel kuti basa iri rive nyore.

Muchidimbu, kugona nzira yekudzima isina mutsara ruzivo rwakakosha kune chero mushandisi weExcel. Tinovimba kuti chinyorwa ichi chakupa zvishandiso zvinodiwa uye ruzivo rwakakosha kuti uite basa iri nemazvo. Ramba uchiongorora nekushandisa zvakanyanya cheichi chine simba chespredishiti chishandiso. Basa rakanaka!