If you have formulas in your worksheet that evaluate to zero, the zeros will display in the cell results by default. This may not be what you want and can make a spreadsheet rather unsightly. Excel has an option that allows you to hide zeros in formula results from view.
To Hide Zeroes in Excel 2007
- Click the Microsoft Office Button
- Click the Excel Options button.
- Click the Advanced category in the left pane.
- Scroll down until you see “Display Options for this Worksheet”
- Uncheck the checkbox next to “Show a zero in cells that have zero value”.
- Click OK.
Similar Posts:
- Change Ruler Preferences in Word 2007
- Disable Automatic Creation of Hyperlinks in Excel 2007
- Turn off AutoCorrect Features in Word 2007
- Modifying Workbook Elements in Excel 2007
- Disable the Mini-Toolbar in Word 2007
- Showing or Hiding Workbook Elements in Excel 2007
- Set Tab Stops in Word 2007 using the Ruler
