Exceljet

Quick, clean, and to the point

Open pivot table wizard

Windows shortcut

AltDP

Mac shortcut

⌘⌥P

This shortcut will launch the PivotTable Wizard dialog box.

Note: In Mac 2016, the Pivot Table Wizard appears to be gone. If you find a workaround, let us know.

222 Excel Shortcuts for Windows and Mac

form.antibot { display: none !important; } You must have JavaScript enabled to use this form.

Topics

Key functions

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. Read more.

I have relied on your website on countless occasions throughout the course of my graduate level finance internship. Compared to a number of unnamed Excel tutorial sites and forums, yours is par-none. It is invariably the only source for consistently accurate and understandable formula functions and syntaxes. I say that as this page has solved an hours-long problem facing me during an all-night work session. Thanks a lot! -Nick

Open pivot table wizard

Download 200+ Excel Shortcuts

Excel video training