» 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 Interpretation of Financial Statements
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
No comments have been submitted.
