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:
- Make sure each column has a distinct heading, such as Date, Region, and Amount.
- Click any filled cell in the list, rather than a blank cell beside it.
- Press Command+Shift+F.
- 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
- How to Use Inside Borders in Excel
- How to Unmerge Cells in New Excel Without Losing Data
- How to Unmerge Excel Files in Microsoft Excel
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- AVERAGEIF Excel Range: Syntax, Examples, and Common FixesIn Excel, the range in AVERAGEIF is the group of cells Excel checks against your condition; the optional…
- Excel Formula Not Calculating Until You Press Enter?If an Excel formula updates only after you press Enter, first check whether calculation is set to Automatic:…
- Sort Excel by Color: Steps, Options, and TroubleshootingTo sort an Excel sheet by color in Microsoft 365 for Windows, select a cell in your data,…
- Excel SUM and XLOOKUP: How to Add Lookup Results in ExcelTo add the values returned by XLOOKUP, wrap the lookup formula in SUM: with prices in B2:B5, matching…
- Excel SUMIF Formula Examples for Everyday TasksExcel’s SUMIF function adds values that meet one condition. With regions in A2:A7 and sales amounts in B2:B7,…
- Excel Workdays Between Dates: Formulas and ExamplesTo count workdays between two dates in Excel, use NETWORKDAYS. With the start date in A2 and the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.