» 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:
- Microsoft Excel Version 2002 Step by Step
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Special Edition Using Microsoft Excel 2002
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Microsoft Windows XP Inside Out
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
No comments have been submitted.
