Sunday, February 04, 2007

Hiding zeroes

How to hide zero values in Excel?
Zero values don't show up in Excel.What to do?


To hide zero values in Microsoft Excel,

  • GoTo->Tools->Options
  • Select the View tab
  • Now uncheck the box next to ZERO VALUES at the bottom.
  • Zero values wouldn't show up.
  • To show zeroes, check the box
Note:
By default, zero values are shown in Microsoft Excel.
This applies to all versions of Microsoft Excel.
When you use this option, zero values don't show up in the worksheet as well as in Print.
Though Excel hides zeroes, it is visible in the formula bar

No comments: