Pivot Tables | WIN | MAC |
---|---|---|
Select entire pivot table | Ctrl A | ⌘ A |
Toggle pivot table field checkbox | Space | Space |
Group pivot table items | Alt Shift → | ⌘ ⇧ K |
Ungroup pivot table items | Alt Shift ← | ⌘ ⇧ J |
Hide pivot table item | Ctrl – | Ctrl – |
Create pivot chart on same worksheet | Alt F1 | |
Create pivot chart on new worksheet | F11 | Fn F11 |
Open pivot table wizard | Alt D P | ⌘ ⌥ P |
Insert Calculated field | Ctrl Shift + |