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:

• Adding cells, Rows & columns
• Ctrl+d's double life
• editing a formula quickly