» 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:
- East of Eden (Oprah's Book Club)
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Microsoft PowerPoint Version 2002 Step by Step
No comments have been submitted.
