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 .
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 .
The result of the 0 values included in the data area you choose is hidden.
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 .
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 .
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 .
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.
Method 3: set up the Excel Spreadsheet worksheet.
Step 1: Open the Excel worksheet to hide the zero values, select File -> Options .
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 .
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