Office for Mac Issues

Use Keyboard Shortcuts to Apply Excel Filters on Mac

Emma BrownEmma Brown Nov 22, 2026 868 views

Question details

Use the keyboard to select filter items and apply an Excel filter on a Mac.

Use Keyboard Shortcuts to Apply Excel Filters on Mac
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
A user wants to filter a worksheet column without using a mouse.
Observed behavior
The filter menu opens, but selecting items and applying the filter with the keyboard is unclear.
Before you start

Open the worksheet in Excel and make sure the column has a filter drop-down. If it does not, select the data range and choose Data > Filter.

Solution 1Recommended

Enable keyboard navigation and select Excel filter items

Use macOS keyboard navigation to move through the filter menu and toggle its checkboxes.

1
Enable keyboard navigation

Open the Apple menu > System Settings > Keyboard and turn on Keyboard navigation. On older macOS versions, open System Preferences > Keyboard > Shortcuts and select All Controls under Full Keyboard Access.

2
Open the filter menu

Return to Excel, select a cell in the column header, and open its filter drop-down using your available keyboard shortcut.

3
Move to the item list

Press Tab to move through the filter controls. If needed, Tab to the Search field, then use Down Arrow to move into or through the item list.

4
Select filter items

Use the arrow keys to highlight items and press Space to select or clear each checkbox. Adjust the Select All checkbox first if you want to choose only a few items.

5
Apply the filter

Press Tab until the OK or Apply button is focused, then press Return or Space. The available button and navigation order may vary by Excel version.

Enable keyboard navigation and select Excel filter items
Navigation can vary: If focus does not move as expected, try Tab or Shift+Tab to move between controls and the arrow keys to navigate within the list.
Free Microsoft Office alternative

Filter spreadsheets with WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and use column filters in WPS Spreadsheet for an easy transition from Microsoft Office.

Filter spreadsheet columns to focus on the data you needCompatible with Microsoft Excel XLS and XLSX formatsFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Where do I enable keyboard navigation on a Mac?

Open Apple menu > System Settings > Keyboard and turn on Keyboard navigation. On older macOS versions, look under System Preferences > Keyboard > Shortcuts for the All Controls option.

How do I check or uncheck an Excel filter item without a mouse?

In the open filter menu, use Tab to reach the item list, use the arrow keys to highlight an item, and press Space to toggle its checkbox.

How do I apply my filter selections from the keyboard?

After selecting the items, press Tab until the OK or Apply button is focused, then press Return or Space. The button name and tab order can vary by Excel version.

What if my column does not have a filter drop-down?

Select the data range in Excel and choose Data > Filter to add filter drop-downs to the column headers.