Tip Printed from ExcelTip.com

---

Setting the Number of Fields Displayed in the Page Layout


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.