Pivot Table Wizard

You may have thought the Pivot Table Wizard had been removed from Excel, but it hasn’t. You can use the following keyboard shortcut to activate it.

Alt d p

Pressed in sequence, not held down.

The Pivot Table Wizard doesn’t recognise formatted tables, and you should only use it if you need to define Multiple Consolidation Ranges.


Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.