How to Use a Shortcut to Select or Clear Excel Filters on Mac
Question details
The user wants to use a keyboard shortcut, such as the Spacebar, to select or clear items within an Excel filter list on macOS, similar to the functionality available on Windows.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Filtering data in Excel using keyboard shortcuts instead of a mouse.
- Observed behavior
- By default, the Spacebar does not select or deselect items in the Excel filter dropdown on a Mac.
Ensure your macOS is up to date, as the exact naming in System Preferences or System Settings may vary slightly depending on your specific macOS version.
Enable Keyboard Navigation in macOS System Settings
Adjusting your Mac's global keyboard settings allows you to use the Spacebar to interact with checkboxes, including those in Excel filter lists.
Because Excel for Mac relies on macOS system-level controls for certain dialog boxes, the Windows-style Spacebar shortcut for filters is disabled by default. By enabling 'All Controls' or 'Keyboard navigation' in your Mac settings, you restore this capability.
Click the Apple menu in the top-left corner of your screen and select System Settings (or System Preferences if you are on an older macOS version).
Click on Keyboard in the left sidebar, then click on the Keyboard Shortcuts button.
Look for an option labeled 'Keyboard navigation' or 'All Controls' and toggle it on. Alternatively, you can simply press Control+F7 on your keyboard to toggle this setting globally.
Return to your Excel spreadsheet, trigger a filter dropdown, navigate using your arrow keys, and press the Spacebar to select or clear individual filter checkboxes.

Try WPS Office for a Seamless Spreadsheet Experience on Mac
If you find Microsoft Excel for Mac's keyboard shortcuts limiting or difficult to configure, consider switching to WPS Office. It provides a highly compatible, lightweight, and free alternative with intuitive data filtering capabilities.
- 1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite for Mac.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing Excel files seamlessly without losing formatting.
- 3. Apply Filters Easily: Highlight your data headers, navigate to the Data tab, and click Filter to efficiently manage, sort, and sift through your spreadsheet data.

Frequently Asked Questions
Why doesn't the Spacebar select filter items by default in Excel for Mac?
Unlike Windows, macOS uses a different default keyboard navigation system. By default, macOS does not allow the Spacebar to interact with UI elements like checkboxes in dropdown menus unless 'Keyboard navigation' or 'All controls' is explicitly enabled in System Settings.
Is there an Excel-specific setting to fix the filter shortcut on Mac?
No, Excel for Mac does not have an isolated setting or shortcut exclusively for checking items in the filter menu. You must rely on the macOS system-wide keyboard navigation settings to enable this.
Will changing my Mac keyboard settings affect other applications?
Yes. Enabling 'All Controls' or 'Keyboard navigation' applies globally to your Mac. It allows you to use the Tab key to move focus between buttons and the Spacebar to click buttons or toggle checkboxes in all applications and system dialog boxes.
How can I quickly toggle Mac keyboard navigation on or off?
You can use the keyboard shortcut Control+F7 to instantly toggle the 'All Controls' or 'Keyboard navigation' setting on and off, allowing you to use the Spacebar in Excel filters only when you need it without permanently changing system behavior.




