Excel Pivot Table Layout. Then move the page field into the row area above the existing row field. On the analyze or options tab in the active field group click field settings.
Set pivottable default layout options. It s primary purpose it to save horizontal space. On the ribbon under the pivottable tools tab click the design tab.
This displays the pivottable tools tab on the ribbon.
Click the layout that you want to uses e g. Set pivottable default layout options. In the save as dialog select the folder you want to locate the workbook then select excel 97 2003 workbook from save as type list. Click on the office button or file tab and click save as.
