» Formatting a PivotTable Report
CATEGORY - Excel Pivot Tables
VERSION - All Microsoft Excel Versions
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:
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Marketing Plan: A Handbook with Marketing Plan
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Yes, You Can Time the Market!
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
No comments have been submitted.

