Typically you might discover the necessity to cover zero values in your knowledge and present cells with zero values as clean cells. You can see under totally different strategies to Conceal Zeros in Excel.
Conceal Zeros in Excel
Earlier than going forward with the steps to Conceal Zeros in Excel, you might need to perceive the distinction between hiding zeros and eradicating zeros in Excel.
Whenever you cover zeros in Excel, you’re solely hiding the info in cells containing zero values, the cells proceed to retain their zero values knowledge.
This virtually implies that the info (zero worth) within the cell shall be thought of in all calculations and formulation.
As compared, once you take away zeros from an Excel Information subject, the cell turns into clean and its gained’t be thought of in formulation and calculations.
With this understanding, allow us to go forward and check out totally different strategies to Conceal Zeros in Excel.
1. Robotically Conceal Zeros in Excel
Observe the steps under to routinely cover zeros in Excel.
1. Open the Excel worksheet during which you need to cover zeros and click on on the File tab.
2. Within the File Menu, scroll all the way down to the underside and click on on Choices.
3. On Excel Choices display, click on on Superior within the left pane. Within the right-pane, scroll all the way down to ‘Show choices for this worksheet’ part > choose the worksheet during which you need to cover zero values and uncheck Present a zero in cells which have zero worth possibility.
5. Click on on OK to save lots of this setting for the worksheet.
When you click on on OK, all of the cells within the knowledge subject having zeros will seem clean.
2. Conceal Zeros in Excel Utilizing Conditional Formatting
The above methodology hides zero values in the whole worksheet and can’t be used to Conceal Zeros in a selected vary within the knowledge.
If you wish to cover Zeros in a specific portion of the info, you should use conditional formatting.
1. Choose the Portion of Information during which you need to Conceal Zero Values.
2. Click on on the Dwelling tab > Conditional Formatting > Spotlight Cells Guidelines and click on on Equal to possibility.
3. In ‘Equal To’ dialog field, enter 0 within the left subject. Within the right-field, choose Customized Format possibility and click on on OK .
4. On Format Cells display, choose the Font tab > use the Coloration drop-down and choose white color.
5. Click on OK to save lots of this setting.
The above methodology hides zeros in Excel by altering the font color of the cells which have zeros in them to white, which make these cells look clean.
3. Conceal Zeros In Excel Utilizing Background Color
The above methodology to cover zeros in Excel by altering the font color to white doesn’t work if the cells within the worksheet have a colored background.
In case you have a worksheet with colored background, you may nonetheless cover zero values by following the steps under.
1. Choose the Portion of Information during which you need to Conceal Zero Values.
2. Click on on the Dwelling tab > Conditional Formatting > Spotlight Cells Guidelines and click on on Equal to possibility.
3. In ‘Equal To’ dialog field, enter 0 within the left subject. Within the right-field, choose Customized Format possibility and click on on OK.
4. In ‘Format Cells’ display, click on on the Quantity tab and choose Customized possibility within the left pane. Within the right-pane, enter ;;; (3 semi-colons) within the ‘Kind’ subject and click on on OK.
Whenever you apply ;;; (3 semi-colons) format in Excel, it hides each numeric and textual content values within the cells during which this format is utilized.
On this case, we’re utilizing conditional formatting to making use of the three semi-colons format solely to cells with 0 values.
- Easy methods to Conceal Cells, Rows and Columns In Excel
- Easy methods to Conceal Formulation in Excel
Me llamo Javier Chirinos y soy un apasionado de la tecnología. Desde que tengo uso de razón me aficioné a los ordenadores y los videojuegos y esa afición terminó en un trabajo.
Llevo más de 15 años publicando sobre tecnología y gadgets en Internet, especialmente en mundobytes.com
También soy experto en comunicación y marketing online y tengo conocimientos en desarrollo en WordPress.