Office for Mac Issues

How to Add Current Selections While Filtering in Excel on Mac

Kushani Nimanthika Oct 10, 2026 871 views

Question details

The user wants to know how to add current selections to an active filter in Excel for Mac, as the interface differs from the Windows version.

How to Add Current Selections to Filter in Excel for Mac

Product: Microsoft Excel for Mac
Device & OS: macOS
Scenario: Expanding an active data filter to include additional records without losing the current filter results.
Observed behavior: The specific 'Add current selection to filter' checkbox found in Excel for Windows is not displayed in the same way on Excel for Mac.

Before you start

Ensure your Excel for Mac is updated to the latest version, as Microsoft frequently updates interface elements and filtering behaviors to match feature parity across operating systems.

Solution 1Recommended

Manually Select Additional Records to Expand the Filter

Since the explicit 'Add current selection to filter' checkbox may be missing in some Mac versions, you can manually check additional items in the filter drop-down menu to achieve the same result.

Excel for Mac often handles multiple filter selections by retaining previously checked boxes when you reopen the filter menu, rather than utilizing a distinct 'add to current selection' button.

Apply the Initial Filter

Click the Filter drop-down arrow on your column header and select your first set of criteria to filter the data.

Reopen the Filter Menu

Click the Filter drop-down button again on the same column header.

Check Additional Records

In the list of available records, simply check the boxes next to the new data points you want to add to your current results. Do not uncheck the previously selected items.

Apply the Expanded Filter

Close the filter menu or click 'Apply' (if prompted) to view the expanded data selection.

Manually Select Additional Records to Expand the Filter

Filter Behavior: As long as you leave the original boxes checked while selecting new ones, Excel for Mac will automatically combine the selections and display all chosen records.

Solution 2

Update Excel for Mac to the Latest Version

If your filtering behavior remains inconsistent or buggy, updating your software ensures you have the latest UI improvements and bug fixes.

Seamless Data Filtering

Use WPS Spreadsheet for a Consistent Filtering Experience on Mac

If you prefer a filtering interface that closely mirrors the classic spreadsheet layout you are used to on Windows, WPS Office for Mac offers a highly intuitive and consistent data management experience.

1. Open Your Spreadsheet: Launch WPS Spreadsheet on your Mac and open your existing Excel (.xlsx) file.
2. Enable Filtering: Highlight your data headers, navigate to the 'Data' tab on the top ribbon, and click 'Filter'.
3. Add to Current Selection: Click the filter drop-down arrow on a column, select your initial criteria, and easily check additional boxes later to add them to your current filter results.

Familiar interface consistent across Mac and Windows platformsFully compatible with Microsoft Excel (.xlsx and .xls) formatsFree and lightweight alternative that will not slow down your MacRobust data filtering, sorting, and analysis tools

Frequently Asked Questions

Why does Excel for Mac look different from the Windows version?

Microsoft develops Excel for Mac and Windows using different underlying frameworks. This can lead to minor interface variations, such as how filter menus, search boxes, and specific checkboxes are displayed.

Can I use Advanced Filters in Excel for Mac?

Yes, you can use the Advanced Filter feature by going to the Data tab and clicking 'Advanced'. This allows you to filter your dataset using complex criteria ranges defined outside of your main table.

What should I do if the Filter button is grayed out on my Mac?

If the filter button is disabled, ensure that your worksheets are not grouped together, the sheet is not protected with a password, and you are not currently actively typing inside a cell.

Office App Problems