» Handling Errors in Values & Empty cells in Excel 2007
CATEGORY - Excel Pivot Tables
VERSION - Microsoft Excel 2007
1. Select a cell in the PivotTable report, right click and select Table Options -> Layout & Format tab.
2. In the Format section type 0 for error values and/or any value for empty cells.
Book Store:
Recommended Books:
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Now, Discover Your Strengths
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Microsoft Access 2002 for Dummies
- Finance and Accounting for Nonfinancial Managers
No comments have been submitted.
