Hide value 0 in Excel

In the process of working with Excel spreadsheets, for some reason, sometimes you want to hide all zero values. To do this, you only need to perform very simple steps, but if you do not pay attention You may not know how to do it.

Follow the article below for ways to hide zero values ​​in Excel spreadsheets.

Method 1: cell format.

Step 1: Select (black out) the data area containing the 0 values ​​that you want to hide the value to 0, then right-click and select Format Cells .

Or in the Home tab, navigate to Cells -> Format -> Format Cells .

Hide value 0 in Excel Picture 1

Step 2: The Format Cells dialog box appears, in the Number tab, select Custom . In the Custom settings , enter 0; -0 ;; @ in the Type field and select OK .

Hide value 0 in Excel Picture 2

The result of the 0 values ​​included in the data area you choose is hidden.

Hide value 0 in Excel Picture 3

METHOD 2: FORMAT CONDITIONS.

Step 1: Select the data area to hide the value to 0, on the Home tab of the Ribbon, select Conditional Formatting -> New Rule .

Hide value 0 in Excel Picture 4

Step 2: The New Formatting Rule dialog box appears .

- In the Select a Rule Type section, choose Format only cells that contain .

- Set the parameters in the Format only cells with section as shown below.

- Then select Format .

Hide value 0 in Excel Picture 5

Step 3: In the Font tab of the Format Cells dialog box , select the font colors that match the worksheet background color. For example in white and click OK .

Hide value 0 in Excel Picture 6

Continue to click OK to close the New Formatting Rule dialog box , resulting in 0 values ​​being hidden. This is suitable for Excel spreadsheets with a background color.

Hide value 0 in Excel Picture 7

Method 3: set up the Excel Spreadsheet worksheet.

Step 1: Open the Excel worksheet to hide the zero values, select File -> Options .

Hide value 0 in Excel Picture 8

Step 2: In the Excel Options dialog box, select Advanced then go to Show a zero in cells that has zero value and uncheck the box before it and click OK .

Hide value 0 in Excel Picture 9

So the zeroes will also be hidden.

This article has introduced you to three ways to help hide zero values ​​in Excel spreadsheets. You can choose for yourself the easiest way to manipulate. Good luck