alt+d+p

[lezawang]

Hi

I used to know what alt+d+p does and for what it is used for! I forgot! and now I do not see any used for it since there is a command to Consolidate data in Data tab. Any hint would be very much appreciated. Any real life example would be great.

Thanks a lot.

 

[Michael M]

ALT + D + P opens the Pivot table / chart wizard

 

[Trustee]

Hi there,

COMMAND + ALT + P , is used to open the PivotTable Wizard

If we have a table and want to convert it to a list that concatenates each column heading with the data in that column.


To accomplish this we are going to use the PivotTable and PivotChart Wizard. Oddly, Excel doesn’t put that on the ribbon, but there are two ways to access it:


1) Use the keyboard sequence Alt+D+P
2) Add the shortcut to your Quick Access Toolbar (QAT) by going to File => Options => Quick Access Toolbar. Choose “All Commands” from the drop down at the top of the left column. Search for “PivotTable and PivotChart Wizard” and add it to your QAT.

 

[FDibbins]

easiest way to find out - try it and see what happens