Working in PivotTables

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.

Shortcuts for Working in PivotTables

Select the entire PivotTable

[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.

Group the selected items

[Alt] - [Shift] - [ ’ ]

Select the items you want to group, and then press this shortcut.

Ungroup the grouped items

[Alt] - [Shift] - [ ]

Select the group of items, and then press this shortcut to ungroup the items.

Navigate from item to item in the PivotTable

[ ] , [ ’ ] , [ ‘ ] , [ “ ]