» Hiding the Display of Zero Values
CATEGORY - Excel Format
VERSION - All Microsoft Excel Versions
To hide zero value in specific cells:The third section in the number custom formatting (after the second ;) returns the formatting for a zero value. To hide the zero value, erase the # and 0 symbols in this section. The formatting will now display an empty cell.
Example:
#,##0_;[Red](#,##0);;
To hide zero values in a sheet:
1. From the Tools menu, select Options, and then select the View tab.
2. Deselect the Zero values checkbox and click OK.
To hide zero values in all cells in the entire workbook:
1. From the sheet tab's shortcut menu, select Select All Sheets.
2. Follow the steps in the previous procedure.
Book Store:
Recommended Books:
- Microsoft Windows XP Inside Out
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Microsoft PowerPoint Version 2002 Step by Step
- Microsoft Word Version 2002 Inside Out
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Microsoft Outlook 2002 for Dummies
No comments have been submitted.
