|  

» Setting the Number of Fields Displayed in 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.



Rate This Tip
12 34 5
Rating:     Views: 3492
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments