Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Cell Formatting

Hide Zeros in your Spreadsheet

Summary: Prevent zero values from cluttering up your Excel 2003 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.

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 13, 2008, at 12:04 A.M. EDT

Return to the Microsoft Excel 2003 Cell Formatting page.

Print this tip.

- Subscribe!

Search the Site: