Bookmark page
Printable version
Course updates
|
RSS feeds
Hints and tips home » Excel hints and tips » No Zeros
No Zeros
Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.
Added by Pete on 26th January 2007
More Excel hints and tips, like:
- Hiding and unhiding rows using the keyboard
- Change the Print button so it brings up the Print dialogue box
- Quickly Adding New Worksheets
 |
|
» Forum post: Filters |
How do you turn on filters ?
