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.

About This Shortcut

This shortcut toggles the visibility of the total row in an Excel Table. It’s equivalent to using the “Total Row” checkbox on the Table tab of the ribbon.