200 Excel Shortcuts for PC and Mac

Learn Microsoft Excel Download PDF

Group pivot table items

Just as you can do with cells, rows and columns, this shortcut allows you to group selected items with your pivot tables. You can do so by certain dates if you are working over a period of time, or simply but selected numbered within the table.

Alt Shift 

 Shift K

Get more Reference tips and tricks

Subscribe to our email updates and get Reference tips direct to your inbox.