» Hiding the Display of Zero Values in Excel 2007
CATEGORY - Excel Format
VERSION - Microsoft Excel 2007
To hide zero values in a sheet:1. Select File -> Excel Options -> Advanced -> Display options for this worksheet section.
2. Deselect the checkbox in Show a zero in cells that have zero value.
To hide zero values in all cells in the entire workbook:
1. From the sheet tab shortcut menu, select Select All Sheets.
2. Follow the steps of previous procedure.
Book Store:
Recommended Books:
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Word 2002: The Complete Reference
- Accounting the Easy Way
- PowerPoint® 2002 For Dummies®
No comments have been submitted.
