Use Keyboard Shortcuts to Apply Excel Filters on Mac
Question details
Use the keyboard to select filter items and apply an Excel filter on a 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.
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.
Enable keyboard navigation and select Excel filter items
Use macOS keyboard navigation to move through the filter menu and toggle its checkboxes.
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.
Return to Excel, select a cell in the column header, and open its filter drop-down using your available keyboard shortcut.
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.
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.
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.

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.

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.




