Excel Pivot Tables

Personalize your Pivot Table layout

There are two ways you can adjust the layout settings for the PivotTable defaults. One way is to simply click the newly added Edit Default Layout button under the File menu to display the Edition Default Layout dialog. Here you can make changes to many of your favorite layout options. Included are all the settings in the “Layout” chunk of the Pivot Table Design contextual ribbon. We also included all the settings in the Pivot Table Options dialog.

Leave a Reply

Your email address will not be published. Required fields are marked *