» 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:
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Monte Carlo Methods in Finance
- Keys to Reading an Annual Report (Barron's Business Keys)
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
No comments have been submitted.
