» Hiding the Display of Zero Values in Excel 2007
CATEGORY - Excel Format
VERSION - Microsoft Excel 2007
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:
- Accounting Principles, with CD, 6th Edition
- Definitive Guide to Excel VBA
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
No comments have been submitted.
