About This Shortcut

This shortcut selects the data area of a table, when the cursor is in an Excel table. Behavior changes as the shortcut is used more than once:

  1. First time: selects table data
  2. Second time: selects table data + table header
  3. Third time: selects entire worksheet

About This Shortcut

This shortcut clears or resets the filter for a selected slicer. You must select the slicer first before using the shortcut.

Note: if you want to reset all filters applied to an Excel Table at the same time, you can use a shortcut to toggle filters off then on again.