Office Settings & Configuration

How to Fix Missing Excel Filter Check Marks in Microsoft 365

Algirdas Jasaitis Sep 30, 2026 869 views

Question details

The user needs to restore the missing check marks in the Excel drop-down filter menu after a recent repair or reinstallation.

How to Fix Missing Excel Filter Check Marks in Microsoft 365

Product: Microsoft Excel 365
Device & OS: not provided
Scenario: Attempting to filter data using the standard drop-down filter menu in a spreadsheet.
Observed behavior: The selection symbols and check marks next to filter options, including the Select All box, are completely missing or invisible.

Before you start

Before proceeding, save your active workbook to avoid any data loss, and verify which version of Microsoft 365 you are currently running by checking your account settings.

Solution 1Recommended

Update Microsoft 365 to the Latest Release

Because missing check marks in the filter menu are often tied to a known bug in older releases (such as the January update), forcing a version update is the most effective fix.

Microsoft frequently patches UI glitches through their continuous update cycle. Updating your Microsoft 365 Apps ensures you receive the bug fix that restores the check mark visibility in Excel filters.

Open Excel Account Settings

Launch Microsoft Excel, click on 'File' in the top-left corner, and select 'Account' from the bottom of the left-hand menu.

Check for Updates

Under the 'Product Information' section, click on the 'Update Options' drop-down button.

Apply Updates

Select 'Update Now' from the menu. Wait for Microsoft 365 to download and install the latest patches.

Restart Excel

Once the update is complete, close and reopen Excel. Click on a filter drop-down to verify the check marks have returned.

Update Microsoft 365 to the Latest Release

Update History Reference: You can verify the release versions and patch notes by visiting the official Microsoft 365 Apps update-history page online.

Solution 2

Perform an Online Repair of Microsoft 365

If updating to the latest version does not resolve the issue, repairing the Office installation files can fix corrupted UI components.

Free Microsoft Office alternative

Use WPS Office to Avoid Frustrating UI Bugs

If display bugs like missing Excel filter check marks are slowing down your workflow, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet environment without the heavy, bug-prone update cycles of Microsoft 365.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office installer.
2. Install and Launch: Run the installer, open the WPS Office suite, and select 'Spreadsheets'.
3. Open Your Files: Drag and drop your existing .xlsx workbooks into WPS to immediately continue your work with fully functional data filters.

100% compatibility with Microsoft Excel (.xlsx) file formats.Free to use with a familiar, easy-to-navigate user interface.Reliable built-in data filtering and sorting tools that work flawlessly.Lightweight software that rarely experiences unexpected display glitches.

microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel filter check boxes suddenly disappear?

This is typically caused by a known user interface bug introduced in a specific Microsoft 365 release (such as the January update). The application logic still works, but the visual symbols fail to render.

Will a standard uninstallation fix the missing check mark issue?

Not necessarily. If you reinstall using an outdated installer or your system cache retains the old settings, the bug will persist. Updating your app directly via File > Account > Update Options is much more effective.

Does the missing check mark affect how my data is filtered?

No. The missing check marks are purely a visual glitch. You can still click the blank spaces where the check marks should be to include or exclude data, though it makes managing filters highly confusing.

Office App Problems