» 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:
- The Guide to Understanding Financial Statements
- Keys to Reading an Annual Report (Barron's Business Keys)
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Now, Discover Your Strengths
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
No comments have been submitted.
