Browse » Home
Tuesday, May 22, 2012
How to Change the Pivot Table Default Settings in Excel 2007
1. Open your Microsoft Excel 2007 application on your computer. Click on any cell in the range you want to use for your pivot table.
2. Click on the 'Insert' tab and then click on the 'PivotTable' button from the Table group. Click on the 'Create PivotTable' button. The 'Create PivotTable' dialog box will then appear.
3. Change any defaults in the 'Create PivotTable' dialog box. For instance, you can click on the 'Use an external data source' option. Click on 'OK' once you've finished changing any of the default selections.
4. Continue to create your pivot table by clicking on any of the options in the 'PivotTable Field List' box. Click on the 'Update' button when you finish.
5. Change the display defaults by clicking on the 'Options' tab and then selecting the 'Options' button in the 'PivotTable' group. Click on the 'Layout and Forms' tab and then click on the 'For error values show' option.
6. Click on the box next to the 'For empty cells show' field. Click on the 'OK' button and the default display options will be changed.