» Setting the Number of Fields Displayed in the Page Layout
CATEGORY - Excel Pivot Tables
VERSION - All Microsoft Excel Versions
To set the number of fields displayed per column in the Page layout:1. Select a cell in the PivotTable report.
2. Press Alt+P.
OR
Right-click and then select Table Options from the shortcut menu.
3. Change the number in Fields per column, and then click OK.
Note:
If the PivotTable toolbar is not visible, hover the mouse pointer on the toolbar, right-click and select the PivotTable toolbar.
Book Store:
Recommended Books:
- Learn MS Excel 2002 VBA/XML Programming
- Excel Charts
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Monte Carlo Methods in Finance
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- The Fall of Advertising and the Rise of PR
No comments have been submitted.
