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.
Mac keys and context
This catalog has no verified Mac binding for this operation. The steps below describe Windows. Choose Windows to use the walkthrough and recall controls.
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.
Expected result: The legacy PivotTable Wizard is inspected without creating or overwriting a report.
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.