» Setting the Number of Fields Displayed in Excel 2007
CATEGORY - Excel Pivot Tables
VERSION - Microsoft Excel 2007
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:
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Keys to Reading an Annual Report (Barron's Business Keys)
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
No comments have been submitted.

