About This Shortcut
This shortcut converts a range to an Excel Table. To use this shortcut, first select the range of data you want to convert.
Note: in Mac Excel 365, you can also use Control + T to convert a range to a table.
About This Shortcut
This shortcut toggles filters on and off for a range of data. It works on tables or filtered lists, and it’s a fast way to clear filters - just turn autofilter off, then on again to reset all filters.
Note: in Excel 2016, this shortcut doesn’t appear to work if slicers are on the worksheet.
