Autofilter drop-down issue when cells exceeds 10000 in Excel for Office 365

Last updated: September 14, 2017


When using Excel 2016, the AutoFilter drop-down is not showing all available checkboxes. This happens when the number of rows exceeds 10,000. Other symptoms may occur as well. For example, the checkboxes may not be clickable, or the filtered result may not return expected results.


This issue is now fixed in Version 1707 (8326.2073) or later. To get the update immediately, open Excel and choose File > Account > Update Options > Update Now.

Have a feature request?

Lightbulb - Idea

We love reading your suggestions on new features and feedback about how you use our products! Share your thoughts on the Excel UserVoice site. We’re listening.

See Also

Fixes or workarounds for recent issues in Excel for PC

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.