Forum Discussion

ELIASALANIZI's avatar
ELIASALANIZI
Copper Contributor
Jan 03, 2025
Solved

Excel PivotTable Keyboard shortcuts

Hi,

 

I used to make a pivot table, Press Menu Key > Press M( Summarize Value By ) and click on the option ( Sum, Min, Max, Average ) However on Excel 365 its not clickable anymore, I have tried to restart the pc, Open different excel workbooks and even tried a different pc, Could there be an option I need to toggle?
As you can see the options are grayed and not clickable.

keyboard shortcuts used to be (Menu Key > M > S, M, I )

I still can summarize values but i have to do it manually with the mouse 
As the only way to click on those options now is to click on the Value field settings from the pivot table