Generalment la presència de zeros en l'Excel information area could make histograms i diferents sorts de grafs look inaccurate. Heu d'oferir que es desplacen cap a zeros per clean, Sprint or Textual content in Excel.
Methods to Change Zeros With Clean in Excel
Earlier ha going forward s steps a switch zeros with clean in Excel, you might want to perceive that changing zeros with clean quantities to erradication the information from cells with zero values.
Onze vostè té com a zeros a l'Excel, a tots els cells containing zeros s'aniran a les seves informacions ia les guanys a tindre els empty cells a no informacions in them.
Perquè teniu change zeros amb Sprint (-) o Textual content in Excel, teniu més errors de trobar errors, quan cells s Sprint or Textual content Area referenced in sure formulation.
Amb aquest understanding, allow us to go forward and try steps a switch zeros with clean, sprint or textual content area in Excel.
1. Change Zeros With Clean in Excel
Observeu the steps under to switch zeros with blanks in Excel.
1. Choose the Complete Information which you wish to change Zeros with clean cells.
2. Click on the Residence tab > click on Discover & Choose in 'Enhancing' part and choose the Change possibility within the drop-down menu.
3. A 'Discover and Change' dialog field, enter 0 a 'Discover what' Area > go away el 'Change with' area empty (enter nothing in it) i click on on Choices.
4. Within expanded 'Discover and Change' field, choose Match total cell contents possibility and click on Change All button.
Per a vostè clicarà en el 'Change All' button, totes les butxaques en la seva informació havien zeros que instantly develop into clean.
2. Change Zeros with Sprint in Excel
Una altra manera d'un coping amb zero values in Excel és el switch zeros with sprint (-). Aquesta és la possibilitat d'utilitzar personalitzada quantitat formabilitat possible a l'excel·lent.
1. Choose the Complete Information which you wish to change zeros with sprint.
2. Click on the Residence tab > choose Format possibility in 'Cells' group > click on on Format Cells… within the drop-down menu.
3. In Format Cells dialog field, click on on Quantity tab and choose Customized possibility in left-pane. Within the right-pane, enter 0;-0;”–” within the 'Kind' area.
4. Cliqueu on OK per saber lots of and implement this alteration.
Per a clicar on OK, Cells amb 0 valors shall be exhibiting a splash (–). Additionally, if you happen enter cero in any cell, it will likely be changed with Sprint (-).
3. Change Zeros with Textual content in Excel
It's also possible to change zeros with any textual content area in Excel. Per a instance, vos possibly can change zeros with 'NA', 'No pot ser' o every other textual content.
1. Choose the Complete Information by which you wish to change zeros with Textual content.
2. Click on the Residence tab > choose Format possibility in 'Cells' group > click on on Format Cells… within the drop-down menu.
3. In Format Cells dialog field, click on on Quantity tab and choose Customized possibility in left-pane. Within the right-pane, enter 0;-0;[Xarxa]”NA” within the 'Kind' area.
4. Cliqueu on OK per saber lots of and implement this alteration.
Per a vostè clica on OK, totes les cèl·lules s 0 valoracions shall be exhibiting el textual contingut 'NA' in purple color.
Word : Si teniu present 'NA' in common color, merely sort 0;-0;”NA”.
4. Discover Zeros in Excel
In case no es pot tocar a zeros instantly.
1. Choose the Complete Information having Zero values
2. Click on the Residence tab > click on Discover & Choose in 'Enhancing' part and choose the Change possibility within the drop-down menu.
3. A 'Discover and Change' dialog field, enter 0 a 'Discover what' Area > go away el 'Change with' area empty (enter nothing in it) i click on on Choices.
4. Within expanded 'Discover and Change' field, choose Match total cell contents possibility and click on Discover All button.
5. Per clicar en Discover All, cells amb zero values s'ha de desenvolupar in highlighted.
6. Maintain the Management Key and Press the Key to pick on all of the cells which have 0 in them.
Nou, que vostè pot xosar amb els cells having 0 values, vostè possibly can delete the zeros, change zeros with any character or spotlight cells having zeros.
- Methods to Discover Duplicates in Excel Utilizing Conditional Formatting
- Methods to Create Pivot Desk in Excel
Em dic Javier Chirinos i sóc un apassionat de la tecnologia. Des que tinc ús de raó em vaig aficionar als ordinadors i als videojocs i aquesta afició va acabar en una feina.
Porto més de 15 anys publicant sobre tecnologia i gadgets a Internet, especialment a mundobytes.com
També sóc expert en comunicació i màrqueting en línia i tinc coneixements en desenvolupament a WordPress.