Buzz
If you already know how to show or hide formula bar in Excel from the previous article, in this post, Mytour will share with you how to hide zero values in Excel spreadsheets.
Guide to Hiding Zero Values in Excel Spreadsheets
Suppose you have a spreadsheet with zero values as shown below:
To hide zero values, follow these steps:
Method 1: Spreadsheet Setup
For Word 2003
Step 1: Choose Tools -->Options
Step 2: A dialog box will appear, in the View tab, uncheck the Zero Values option, then press OK.
Result:
For Word 2007
Step 1: Select Office button --> Excel options
Step 2: A dialog box will appear, in the Advanced tab, uncheck the box next to Show a zero in cells that have zero value, then press Ok.
Result: Zero values in the spreadsheet will be hidden
Method 2: Number Formatting
Step 1: Select the data range containing zero values, right-click, and choose Format Cell
Step 2: A dialog box will appear, choose Custom, in the Types section type the following: 0;-0;;@ and then press Enter.
Result: Zero values will also be hidden.
Method 3: Conditional Formatting
For Word 2003
Step 1:Format -->Conditional Formatting
Step 2: A dialog box will appear, set the parameters as shown below, and then click Format.
Step 3: A dialog box will appear, in the Font tab, choose to change the font color to white and click Ok twice. Then view the result.
Result:
For Word 2007
Step 1: Select Home -->Conditional Formating -->New Rule
Step 2: A dialog box will appear, choose Format only cells that contain and set the parameters as shown below, then click Format.
Step 3: A dialog box will appear, in the Font tab, choose a font color that matches the spreadsheet's color, then click Ok twice. As a result, all zero values will blend in with the spreadsheet, making them invisible to the eye.
Result:
Here, we have shared with you 3 methods to hide zero values in Excel spreadsheets, each approach has its own characteristics, and you can choose which one to apply to your Excel spreadsheet.
