» Setting the Number of Fields Displayed in Excel 2007
CATEGORY - Excel Pivot Tables
VERSION - Microsoft Excel 2007
To set the number of fields displayed per column in the Page layout:1. Select a cell in the PivotTable report.
2. Right-click and then select Table Options -> Layout & Format tab.
3. Set the number in Report Filter fields per column, and click OK.
Result: Filter fields are grouped by four fields in each column.
Book Store:
Recommended Books:
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Special Edition Using Microsoft Access 2002
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Accounting for Dummies
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
No comments have been submitted.
