Skip to main content

Filter in Excel (macOS)

Press Shift + Command + F to switch the filter buttons of a table on or off.

What it does

With a cell inside your data selected, the command puts a button with an arrow into each heading of the first row. A click on a button lists the values of that column, where you tick what to show, sort the rows or set a condition. Rows that do not match are hidden and not deleted. The same keys take the filter off again.

More Excel shortcuts: Frequently used

  • Expand/Collapse Ribbon
  • Open Workbook
  • Insert Hyperlink
  • Create Names
  • Find

All 95 Excel shortcuts for macOSThe full list has a search and a printable PDF.

Questions

What is the Excel shortcut for Filter on macOS?

⇧⌘F (Shift + Command + F). Press it to switch the filter buttons of a table on or off.