About This Shortcut

This shortcut will toggle check and uncheck the checkbox for fields listed in the pivot table field list. Use to add or remove a field from a pivot table. On Windows, you can use the spacebar to toggle items that appear in row and column label filters as well.

About This Shortcut

This shortcut will group selected pivot table items. If you want to group a field automatically by date or number, you only need to select one item in the field before using this shortcut.