Mac Excel Filter Shortcut: Turn Filters On and Use Them

Formulas & functions · Updated November 20, 2026

In Excel for Mac, press Command+Shift+F to turn AutoFilter on or off for a data range. Select a cell in the range first; Excel adds or removes filter arrows in the header row. This shortcut toggles the arrows—it does not open a column’s filter menu.

The Mac Excel filter shortcut and what it does

The shortcut to remember is Command+Shift+F (⌘+Shift+F). It switches filtering on for the current data region, or switches it off if filtering is already enabled. When you turn it on, small drop-down arrows appear beside the column headings. Use those arrows to choose which records to display.

AutoFilter changes what is visible, not the underlying data. For example, filtering a sales list to show only rows for Canada hides the other rows temporarily; it does not delete them or change their values. Turn the filter off, or clear the condition, to see the complete list again.

If the shortcut does nothing, try the ribbon command instead: select a cell in the list, then choose Data > Filter. This is also a useful way to confirm whether the issue is the keyboard shortcut or the data layout. Keyboard behavior can vary with Excel version, keyboard layout, and system settings, so the ribbon is the dependable fallback.

Turn filters on for the right range

Before using the shortcut, check that the list has one clear header row and that the active cell is inside the data. Excel usually detects the surrounding contiguous block of cells. A blank row or blank column in the middle can split a list into separate regions, so Excel may add arrows to only part of the data.

For a straightforward list, use this sequence:

  1. Make sure each column has a distinct heading, such as Date, Region, and Amount.
  2. Click any filled cell in the list, rather than a blank cell beside it.
  3. Press Command+Shift+F.
  4. Click a heading’s filter arrow and select the values or conditions you want to see.

If the detected range is incomplete, undo the toggle if needed, select the full range including its headings, and use Data > Filter. Check for blank rows and columns that divide the list. Avoid including a separate title or notes above the headings unless those cells belong to the actual table.

Open a column menu and apply a filter

Turning on AutoFilter creates the drop-down arrows; it does not choose a condition for you. Click the arrow in the relevant heading to open its menu. Depending on the kind of values in that column, the menu offers a checklist of distinct entries, a search field, and filtering choices such as text, number, or date conditions.

For instance, in a list with Region, Product, and Sales columns, open the Region menu and select West to show only western-region records. You can then open the Product menu and select a product as well. Filters on different columns work together: a row remains visible only when it meets every active column filter.

To remove a condition without removing the filter arrows, reopen that column’s menu and choose its clear-filter command. This restores the hidden records for that column while leaving other column filters in place. To remove the arrows altogether, use Command+Shift+F again or choose Data > Filter.

Filter by text, numbers, dates, and color

The options in a filter menu depend on the column’s contents. A column of names can be narrowed to selected names or filtered with text conditions. A numeric column can be filtered to values above, below, or between limits. A date column can offer date-based groupings and conditions. If a column contains a mixture of text, numbers, dates, or blanks, its menu may not present the choices you expect.

Here are practical ways to use those choices:

  • Find a value: use the menu’s search box to locate an entry in a long checklist, then select the matching item.
  • Show a range: use a number condition to display, for example, sales greater than 500.
  • Narrow dates: choose a date option to display a particular period or use a condition when you need a specific boundary.
  • Show blanks: select the blank entry in the checklist when you need to locate records without a value in that column.

Some filter menus also offer filtering by cell color, font color, or icons when those formats are present. These options are useful for a worksheet that uses color to mark status, but color should not replace a clear status column if the information needs to be sorted, checked, or shared reliably.

Using filters with an Excel table

For a list you expect to expand, formatting it as an Excel table can make filtering easier to manage. Select a cell in the list and choose Insert > Table, then confirm that the range is correct and that the table has headers. Excel tables include filter arrows in their heading row and generally extend as you add data directly below them.

Tables also provide a named structure and consistent formatting, but they are not required to use AutoFilter. A regular range can still be filtered with Data > Filter. If you already have arrows on the headings, check whether the data is a table or a filtered range before adding another feature; the visible result may look similar even though the table has additional behavior.

When new rows do not appear in a filtered list, check whether they were added within the table or contiguous range. A row separated from the list by a blank line may not become part of the filtered area automatically. Expanding or resizing the table, or selecting the full intended range before applying the filter, can resolve that mismatch.

Filtering is different from sorting

Filtering and sorting are often found in the same heading menu, but they do different things. A filter hides rows that do not meet a condition. A sort rearranges the order of the rows that remain in the range. Filtering to show only one region does not put its sales in order; sorting the Sales column does not hide records from other regions.

Use a filter when the question is which records should be visible, such as which orders are overdue. Use a sort when the question is how to arrange records, such as listing the largest orders first. You can use both together: filter to a region, then sort the visible sales values. Clear the filter afterward if you need to inspect the full list.

Common shortcut and filter problems

If Command+Shift+F appears not to work, first check the Data tab to see whether the filter arrows are already present. The shortcut is a toggle, so pressing it when filtering is on removes the arrows rather than opening a menu. If the arrows are present, click one to set or change a condition.

Other frequent causes are a selection outside the list, an interrupted data range, or missing or ambiguous headings. Try these checks:

  • Click inside a populated cell in the intended list and try again.
  • Look for completely blank rows or columns that could split the range.
  • Give each column a single, nonblank heading and avoid merged heading cells.
  • Select the whole intended range and use Data > Filter if Excel is detecting only part of it.
  • If the command is unavailable, check whether the worksheet is protected or whether the workbook’s editing restrictions prevent changes.

Also remember that a filter can make records seem missing even though they are still in the sheet. Look for a filter indicator on the heading, clear the active condition, or turn filtering off to restore the full view. Before editing or deleting rows, confirm whether a filter is hiding other records so you do not mistake a partial view for the complete list.

Frequently Asked Questions

What is the shortcut to filter in Excel on a Mac?
Press Command+Shift+F to toggle AutoFilter for the current data range. If it does not respond, select a cell in the list and use Data > Filter.

Does Command+Shift+F open the filter drop-down menu?
No. It turns the filter arrows on or off. Click the arrow in a column heading to open that column’s menu and choose values or conditions.

How do I clear a filter without removing the arrows?
Open the filtered column’s menu and choose the command to clear its filter. The arrows remain, and any filters on other columns remain active.

How do I remove all filter arrows in Excel for Mac?
Press Command+Shift+F again, or select Data > Filter. Because this is a toggle, check whether the arrows are currently on before using it.

Why does Excel filter only part of my list?
A blank row or column may have split the data into separate regions, or the selected cell may be outside the intended range. Select the complete list, including its headings, and apply the filter again.

A quick way to remember it

Use Command+Shift+F to toggle filter arrows, then use a heading arrow to choose what to display. If you only want to clear a condition, clear it from that column’s menu rather than turning AutoFilter off. Keeping a continuous range with clear headings—and using a table for a list that grows—helps Excel apply filters to the records you intend.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.