This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Cell Formatting - Hide Zeros in your Spreadsheet

Many people may find their Excel 2003 spreadsheets easier to read if instead of cells displaying zeros, either as values or the results of calculations, they would just remain blank. This may remove clutter from complex spreadsheets where readers would naturally assume that if a cell is blank, it must be a zero value. To make this change:

1. Select "Tools" - "Options".
2. When the "Options" multi-tabbed dialog box appears, select the "View" tab.
3. Underneath "Window options", uncheck "Zero values".
4. Click "OK" to save your changes.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Cell Formatting - Hide Zeros in your Spreadsheet.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.