Buzz
While working with Excel spreadsheets, there are occasions where you may want to hide all zero values for various reasons. Achieving this requires a simple set of steps, but overlooking them might leave you clueless.
Stay tuned to discover methods for hiding zero values in Excel spreadsheets.
METHOD 1: CELL FORMATTING.
Step 1: Select the data range containing the zero values you want to hide, then right-click and choose Format Cells.
Alternatively, in the Home tab, navigate to the Cells section -> Format -> Format Cells.
Step 2: The Format Cells dialog appears, in the Number tab, select Custom. In the Custom settings, enter 0;-0;;@ into the Type box and click OK.
As a result, the zero values within the selected data range are hidden.
METHOD 2: CONDITIONAL FORMATTING.
Step 1: Select the data range where you want to hide zero values. On the Home tab of the Ribbon, choose Conditional Formatting -> New Rule.
Step 2: The New Formatting Rule dialog appears.
- In the Select a Rule Type section, choose Format only cells that contain.
- Configure the parameters in the Format only cells with section as shown in the image below.
- Then select Format.
Step 3: In the Font tab of the Format Cells dialog, choose a font color that matches the background color of the spreadsheet. For example, select white and click OK.
Continue pressing OK to close the New Formatting Rule dialog, and the zero values will be hidden. This method is suitable for Excel spreadsheets with a single background color.
METHOD 3: SETTING UP EXCEL WORKSHEET.
Step 1: Open the Excel worksheet where you want to hide zero values, select File -> Options.
Step 2: In the Excel Options dialog, choose Advanced then locate the Show a zero in cells that have zero value section and uncheck the box next to it, then click OK.
This way, the zeros will also be hidden.
The article above has introduced you to three methods to hide zero values in Excel spreadsheets. You can choose the simplest method for yourself. Wishing you success!
