Office
Sign in

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

Last updated: June 13, 2018

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: FIXED

This issue has been fixed in version 16.10.0 or higher. To get the latest update, open Excel for Mac, go to the Help > Check for Updates menu, and follow the instructions in the AutoUpdate app.

More Resources

Icon Experts (brain, gears)

Ask the experts

Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.

Excel Tech Community

Icon Community

Get help in the community

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

Excel Forum on Answers

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.

×