Easy methods to Conceal Zeros in Excel

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

Before 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 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 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 format.

1. Choose the Serving of Information during which you need to Conceal Zero Values.

2. Click on the Dwelling tab > Conditional Formatting > Spotlight Cells Guidelines and click on on Equal to that 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 Drop-down coloring 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 makes these cells look clean.

3. Conceal Zeros In Excel Using 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 still cover zero values ​​by following the steps below.

1. Choose the Serving of Information during which you need to Conceal Zero Values.

2. Click on the Dwelling tab > Conditional Formatting > Spotlight Cells Guidelines and click on on Equal to that 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 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 used.

In this case, we're utilizing conditional formatting to make 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