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.
Search the Site: