You may have rows or columns hidden that you don't want selected when you are working with the surrounding data range. Mac equivalent: Group: Cmd + Shift + K | Ungroup: Cmd + Shift + J 3. Or, if you prefer to use your keyboard to expand and collapse, you can use the following shortcuts.

Once the group is formed, you can expand or collapse the entries using the plus and minus buttons that Excel creates in the header section for the rows or columns.

To ungroup the rows, use Shift + Alt + ←. To group two or more columns or rows together, select the entries you want to group and then type Shift + Alt + →. To clear all filters, use Alt, then A, then C. This creates a filter and excludes the item(s) you selected. If you want one or more items to be filtered out of your pivot table, just select the item(s) you want filtered and type Ctrl +. If you are looking to up your Excel game and work faster using keyboard shortcuts, I recommend you give these 19 techniques a try. 19-Advanced-Excel-Shortcuts.xlsx Download Advanced Keyboard Shortcuts

Microsoft 2007 excel shortcut keys