Like charts , PivotTables are largely graphical items for which the mouse tends to be much more convenient than the keyboard. Nevertheless, if you work extensively with PivotTables, you may benefit from knowing the keyboard shortcuts that Excel offers for working with them.
[Ctrl] - [Shift] - [*]
When you want to take an action with the PivotTable ”for example, apply formatting to it ”use this shortcut to select the whole PivotTable.
[Alt] - [Shift] - [ ’ ]
Select the items you want to group, and then press this shortcut.
[Alt] - [Shift] - [ ]
Select the group of items, and then press this shortcut to ungroup the items.
[ ] , [ ’ ] , [ ‘ ] , [ “ ]