Office for Mac Issues

How to Use a Shortcut to Select or Clear Excel Filters on Mac

Algirdas JasaitisAlgirdas Jasaitis Nov 3, 2026 869 views

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.

How to Enable Keyboard Shortcuts to Select or Clear Excel Filters on Mac
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.
Before you start

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.

Solution 1Recommended

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.

1
Open System Settings

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).

2
Navigate to Keyboard Options

Click on Keyboard in the left sidebar, then click on the Keyboard Shortcuts button.

3
Enable Full Keyboard Access

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.

4
Use Spacebar in Excel Filters

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.

Enable Keyboard Navigation in macOS System Settings
System-Wide Impact: Enabling this setting will also allow the Spacebar and Tab keys to interact with buttons and dialog boxes across all other applications on your Mac, not just Excel.
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite for Mac.
  2. 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing Excel files seamlessly without losing formatting.
  3. 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.
Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Familiar user interface that supports intuitive keyboard operations for data filtering.Lightweight application that runs fast and smoothly on all macOS versions.Completely free to download and use with comprehensive spreadsheet tools.
microsoft office alternative - wps office

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.