» 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:
- Finance and Accounting for Nonfinancial Managers
- Microsoft Excel Version 2002 Step by Step
- Investing in Real Estate, Fourth Edition
- Wall Street Journal Guide to Understanding Money and Investing
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Business Analysis with Microsoft Excel (2nd Edition)
No comments have been submitted.
