How to Filter Data in Excel on Mac Using Only the Keyboard

Filtering lets you temporarily hide rows that do not match what you need to see. The data stays in place; Excel simply shows a smaller, more useful subset. On a Mac, you can turn filtering on, open a column's filter list, select values, and return to the full list without reaching for the mouse.

Quick answer: Put the active cell anywhere in your data and press ⌘⇧F (or ⌘⇧L) to add or remove filter arrows. Move to the header you want to filter, press ⌥↓ to open its filter list, then use Tab, arrow keys, Space, and Return to choose values and apply the filter.

What keyboard filtering does—and why it is useful

Excel's AutoFilter works on a continuous range with a header row, or on an Excel table. Once enabled, every header gets a drop-down control. A filter can keep only selected values, use a text/number/date condition, or limit the view to values matching a search.

The key point is that filtering does not delete or rearrange your records. It hides entire rows that do not meet the current criteria. That makes it safe for reviewing a sales list, checking overdue tasks, or copying only visible results. Filters across columns are additive: each extra condition narrows the rows that remain visible.

Before you start

Your data should have:

• one header row, with a label for each column;

• no completely blank rows or columns inside the range; and

• one active cell inside the range or table.

For the example below, imagine a list in `A1:D9` with the headers Date, Region, Rep, and Revenue. We will show only rows where Region is West.

Excel tables already have filter arrows. If yours is a table, skip straight to open a column filter.

At a glance: the keyboard commands you need

Method 1: Turn filters on with a native shortcut

1. Use the arrow keys to put the active cell anywhere inside the data range.

2. Press ⌘⇧F. If that shortcut conflicts with another setup, press ⌘⇧L instead.

3. Confirm that filter arrows appear in the header row.

Both shortcuts toggle the feature. Pressing the same shortcut again removes the filter arrows and removes any active filters from that range, so do not use it merely to show all rows again.

Method 2: Open a column filter with the keyboard

1. Move the active cell to the header you want. You can use the arrow keys, or press ⌘G to open Go To, type a cell reference such as `B1`, and press Return.

2. Press ⌥↓. Excel opens the selected header's filter list.

3. Press Tab to move through the controls. Use ⇧Tab to move backwards.

4. Use ↑ and ↓ to move through list items, and press Space to check or clear the focused item.

5. Tab to OK and press Return.

For the sample data, go to the Region header, open the filter list, clear (Select All) with Space, move to West, press Space, then tab to OK and press Return.

The exact number of Tab presses can differ slightly between Excel releases and the type of filter list. The reliable pattern is: use Tab to reach a control, use arrow keys within a list, use Space to toggle, and use Return to activate the focused button.

Method 3: Filter faster by searching for a value

Long lists are easier to filter through the search box than by moving through hundreds of checkboxes.

1. Select the relevant header and press ⌥↓.

2. Press Tab until the search box has focus.

3. Type the value you need, such as `West`.

4. Tab into the filtered results, use Space to select the matching value, then tab to OK and press Return.

Use an asterisk (`*`) for any string of characters and a question mark (`?`) for a single character when you need a wildcard search. For example, `*west` finds entries that end in “west.”

Method 4: Use a text, number, or date condition

The same filter list can do more than exact matches. Text columns offer Text Filters, numeric columns offer Number Filters, and date columns offer Date Filters.

1. Select the column header and press ⌥↓.

2. Use Tab and arrow keys to reach the appropriate filter category.

3. Choose a condition, such as Greater Than, Contains, or Between, and press Return.

4. In the dialog, type the criterion. Use Tab to move between fields, then press Return on OK.

For instance, choose Number Filters → Greater Than on the Revenue column, enter `10000`, and confirm. Excel keeps rows whose revenue exceeds 10,000.

Method 5: Use MacCove for familiar Windows-style filtering

If you use MacCove's Mac Excel Shortcuts, select any cell in the data and press Alt, A, T to run the Filter command. This mirrors the familiar Data → Filter sequence from Windows-style Ribbon navigation.

After the arrows are present, use Excel's built-in ⌥↓, Tab, arrow keys, Space, and Return to operate the filter list. MacCove is most helpful when your muscle memory is based on Windows Excel; the actual criteria selection remains a keyboard-only Excel workflow.

Real-world example: show West-region deals over $10,000

Starting from the sample table:

1. Put the active cell in the data and press ⌘⇧F.

2. Go to the Region header, press ⌥↓, select only West, and press Return on OK.

3. Go to the Revenue header and press ⌥↓.

4. Choose Number Filters → Greater Than, enter `10000`, and confirm with Return.

Excel now displays only rows where Region is West and Revenue is greater than 10,000. It has not changed the order or content of the other rows; they are hidden until you clear the filters.

Clear a filter without removing the filter arrows

To show all rows while keeping the filter controls available:

1. Move to a header that has an applied-filter icon.

2. Press ⌥↓.

3. Tab to Clear Filter From [Column Name] (or select (Select All)), then press Return.

To clear every active column filter, repeat this for each filtered header. Do not press ⌘⇧F or ⌘⇧L unless you intend to remove filtering entirely.

Common mistakes when filtering with only the keyboard

Opening the filter list from a data cell

⌥↓ opens the filter list for the selected *header*. If it does not open a filter menu, move to the column's header row first.

Filtering a range with blank rows inside it

AutoFilter detects a continuous data region. A blank row can make Excel stop early and exclude records below it. Remove the blank row or convert the data to an Excel table before enabling the filter.

Turning Filter off when you only meant to clear results

The toggle shortcuts remove filter arrows as well as active filters. Use the header's Clear Filter command when you want to keep the arrows.

Expecting an additional filter to replace the first one

Filters across different columns work together. A second criterion narrows the already filtered list. Clear the earlier column filter first if you want to start over.

Forgetting that only visible cells are being reviewed

After filtering, find and copy operations may work only on the visible subset. Clear filters before searching the entire dataset or making changes intended for every row.

Windows equivalent

FAQs

What is the Excel filter shortcut on a Mac?

Use ⌘⇧F or ⌘⇧L to add or remove filters from the active data range. Microsoft lists both shortcuts for Excel for Mac.

How do I open an Excel filter drop-down without a mouse?

Select the column header and press ⌥↓. Then use Tab, the arrow keys, Space, and Return to make and apply your choice.

Why does Option-Down Arrow not open my filter menu?

Usually the active cell is not in a header, filters have not been enabled, or the data range does not have a usable header row. Select the header cell, turn Filter on with ⌘⇧F, and try again.

Can I filter more than one Excel column using the keyboard?

Yes. Apply the first column's filter, then move to another header and repeat ⌥↓. Each filter further narrows the rows displayed.

Does filtering delete hidden rows?

No. Filtering only hides rows that do not meet the criteria. Clear the filter to make them visible again.

Related guides

• Complete Mac Excel shortcut cheat sheet

• Why Excel keyboard shortcuts do not work on Mac

Sources

• Microsoft: Keyboard shortcuts in Excel

• Microsoft: Filter data in a range or table in Excel

• Microsoft: Reapply a filter and sort, or clear a filter