PivotTables · original practice scenario
Open the legacy PivotTable Wizard on Windows
Prepare a simple rectangular source with headers Item and Units and select a cell within it.
Start here: Windows desktop Excel supporting legacy menu access; worksheet focus
Do not hold all keys together. The publisher warns that the wizard disappeared on Mac 2016; its historical Mac key is withheld. Insert > PivotTable is the current menu alternative.
Follow these instructions in your own desktop Excel workbook. This page explains the operation; it does not send commands to Excel.
Windows keys and context
Alt+D,P
Publisher-documented binding. Native desktop execution has not been tested.
Desktop key table and operation notes; reviewed 2026-10-18. Exceljet publisher reference ↗
Walk through the operation
- Press and release Alt+D, then P in sequence.
- Inspect the dialog identity and source options before continuing.
- Cancel the wizard after inspection so no report is created accidentally.
Instruction 1 of 3: Press and release Alt+D, then P in sequence.
Expected result: The legacy PivotTable Wizard is inspected without creating or overwriting a report.
Recall the keys
Which listed Windows combination or sequence starts this operation in the context above?
Related walkthroughs
- Select an entire PivotTable report
- Clear a focused PivotTable slicer filter
- Toggle a PivotTable field checkbox
- Group selected PivotTable items
Catalog updated 2026-10-18. US keyboard notation: + joins held keys; commas separate successive presses. Function keys may require Fn. Desktop instructions are separate from this browser's own keyboard shortcuts.