Filter disappears in a column with date values in Excel 2016 for Mac

Last updated: October 13, 2017

ISSUE

When trying to filter a column that contains only date values, the filter list is empty, so you are not able to set the filter. This issue affects Excel 2016 for Mac version 15.38 and 15.39.

STATUS: WORKAROUND

We are actively working on a fix for this issue. As a workaround, you may be able to filter your data as needed using the filter options above the filter values list.

Excel for Mac filter date values

More Resources

Icon Community

Get help in the community

Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.

Excel for Mac forum

Icon feature request (light bulb, idea)

Suggest a new feature

We love reading your suggestions and feedback! Share your thoughts. We're listening.

Excel UserVoice

See Also

Fixes or workarounds for recent issues in Excel for Mac

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.

×