Remember the old Excel Pivot Table Wizard? It doesn’t seem to be anywhere in the new interface or ribbons. Did you know you can find it though???
- Right click on the ribbon and select the Customize the Quick Access Toolbar…
- In the window – select ALL COMMANDS
- Scroll down to find the Pivot Table Wizard and click the Add button to add it to the Quick Access Toolbar.
- Notice the new icon on the Quick Access Toolbar.
- Open your spreadsheet with the multiple sheets you want to consolidate into a single Pivot Table.
- Click on the new Pivot Table and Chart Wizard.
- In the dialog box – select Multiple Consolidation Ranges and click Next.
- Click next again to click on the Create a single page field for me and click Next.
- Highlight the first range in your spreadsheet, then click Add.
Continue to add ranges as needed. Then click Finish.
- View the final results of your Pivot Table and modify as necessary.
