What Are the Autofilter Shortcuts in Mac Excel?
Quick Answer: The core AutoFilter toggle on Mac Excel is
Control+Shift+L— one of the handful of shortcuts Mac Excel deliberately kept asCtrlinstead of switching toCmd, matching Windows exactly. Once filters are on, opening a column's dropdown and navigating it is mostly arrow-keys-and-Return, with a couple of Mac-specific quirks below. Mac Excel Shortcuts app keeps this and the rest of your Windows filtering muscle memory working consistently, including gaps like Remove Duplicates that neither platform maps by default.
This is the keyboard-only quick reference. For the full step-by-step walkthrough, see the complete filtering guide linked below.
Why some AutoFilter shortcuts stay on Ctrl
Mac Excel remaps most Windows Ctrl shortcuts to Cmd (Ctrl+C → Cmd+C, Ctrl+S → Cmd+S, etc.) because Cmd is the "primary modifier" convention on macOS. But a small set of shortcuts — mostly ones involving letter combos that would collide with macOS system-level or app-level shortcuts if moved to Cmd — were left on Ctrl on purpose. AutoFilter toggle (Ctrl+Shift+L) is one of them. This is genuinely useful for Windows migrators: it's one of the few places your old muscle memory just works unchanged.
Quick reference table
| Shortcut | Description | Windows Equivalent |
| Control+Shift+L | Toggle AutoFilter on/off for the selected range/table | Ctrl+Shift+L |
| Option+Down Arrow | Open the filter dropdown for the active cell's column (when AutoFilter is on) | Alt+Down Arrow |
| Down Arrow / Up Arrow (inside open dropdown) | Move between filter options | Same |
| Space | Toggle the checkbox of the highlighted filter item | Same |
| Return | Apply the current filter selection and close the dropdown | Same |
| Esc | Close the dropdown without applying changes | Same |
| No default shortcut | Clear the filter on one column: open its dropdown with Option+Down Arrow and choose Clear Filter From [Column] | N/A / varies |
| No default shortcut | Reapply filters after data changes (Data → Reapply) | Ctrl+Alt+L |
| Tab (inside dropdown search box) | Move focus from the search field into the item list | Same |
| Typing while dropdown is open | Jumps to / filters the item list by typed text (search-as-you-type in newer builds) | Same |
Two shortcuts toggle AutoFilter on Mac
Microsoft's Excel for Mac shortcut list gives two ways to add or remove a filter: ⌘⇧F and Control+Shift+L. They do the same thing, so use whichever your hand finds easier. If one of them is intercepted by macOS or another app on your Mac, the other usually still works. ⌘⇧L is not a documented Excel shortcut for this.
A related shortcut worth knowing is ⌘⇧R, which Microsoft lists for opening the Sort dialog, the natural next step once your filters are on.
Filter a column from the keyboard, step by step
Click any cell inside your data. The first row should contain headings.
Press ⌘⇧F (or Control+Shift+L) to turn the filter arrows on. If your data is already an Excel Table, the arrows are already there.
Move to the heading of the column you want, then press Option+Down Arrow to open its filter list.
Use Down Arrow and Up Arrow to move through the values, and Space to tick or untick the highlighted one.
Press Return to apply the filter.
To turn filtering off again, select a cell in the range and press the same shortcut.
What you can filter by
Microsoft notes that Excel for Mac can filter a column in three ways: by the values in the list, by a condition, or by color.
By condition: choose a text, number or date filter, for example Begins With, Ends With, Contains or Equals, and combine two criteria with And or Or.
By color: use the By color menu to filter on cell color, font color or a cell icon.
By wildcard: in text criteria a question mark matches any single character, an asterisk matches any number of characters, and a tilde in front of either one lets you search for the character itself.
For blanks: scroll the list near Select All to find the Blanks option.
Limits worth knowing
One range at a time. Microsoft says you can apply filters to only one range of cells on a sheet at a time.
10,000 unique values. Only the first 10,000 unique entries in a column appear in the filter list.
Filters do not refresh themselves. If you add, change or delete data, reapply the filter to update the results.
Clearing is per column or all at once. To clear one column, open its arrow and choose Clear Filter. To remove every filter, select a cell in the range and press the Filter button on the Data tab.
Common gotchas
Ctrl+Shift+Ltoggles for the whole range, not one column. If you only want to remove one column's filter, open that column's dropdown and choose "Clear Filter From [Column]" instead.AutoFilter needs a header row. If Excel guesses your data has no headers, it will include row 1 in the filterable data.
Filtering a Table vs. a plain range behaves slightly differently — Tables (
Cmd+T) get AutoFilter dropdowns automatically and keep them even after re-sorting.
FAQs
Why does my filter not include all my rows?
Usually because Excel guessed the wrong range, often when there is a completely blank row or column inside the data. Select the whole range first, then turn the filter on.
Can I filter two separate ranges on one sheet?
Not at the same time. Microsoft says filters can be applied to only one range of cells on a sheet at a time. Format each range as a Table if you need independent filters.
How do I clear the filter on just one column?
Open that column's filter list with Option+Down Arrow, or click its arrow, and choose Clear Filter.
