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.

I want to thank you for your posting of "Split dimensions into three parts" on your web site. You have saved our company many hours of PITA work. Our calculations of cubic inches are a slam dunk now! -Doug

Excel foundational video course

Excel Pivot Table video training course

Excel formulas and functions video training course

Excel Shortcuts Video Course

Excel Charts video training course

Video training for Excel Tables