» Formatting a PivotTable Report
CATEGORY - Excel Pivot Tables
VERSION - All Microsoft Excel Versions
To format a PivotTable report:1. Select a cell in the PivotTable report.
2. Click the Format Report icon on the PivotTable toolbar.
OR
Press Alt+P (if the PivotTable toolbar is not visible, see the Note in Tip #299).
Select Format Report and select one of the format options, and then click OK.
In Excel 97, use AutoFormat (this exists in all Excel versions): From the Format menu, select AutoFormat.
Book Store:
Recommended Books:
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Microsoft Outlook 2002 for Dummies
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
No comments have been submitted.
