Forum Discussion
ELIASALANIZI
Jan 04, 2025Copper Contributor
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
Click in a value field.
Press Alt+JT, then press G.
Click in a value field.
Press Alt+JT, then press G.
- ELIASALANIZICopper Contributor
Much appreciated mate HansVogelaar 🙏