Quick Helpful Hints: Add Pivot Table Wizard in Excel 2007

Add Pivot Table Wizard in Excel 2007

Did you know…you can add the Pivot Table Wizard to your Ribbon/Quick Access Toolbar (QAT)?

 

 

Customize the Quick Access Toolbar (QAT)

To add the Pivot Table Wizard to your QAT, follow these steps:

Click on the Customize Quick Access Toolbar button

Click More Commands

 

 

 

From the 'Choose commands from' drop down list, select 'Commands Not in the Ribbon'

 

 

In the list of commands, click PivotTable and PivotChart Wizard

Click the Add button, then click OK

Open the Pivot Table Wizard

Now that the Pivot Table Wizard button has been added to the QAT, you can click it to open the Pivot Table Wizard.