Excel 2016 filters do not work

Ask a question PetraT - Last answered on Aug 4, 2017 at 04:54 PM by ac3mark

My filter stopped working in 2016. It is completely inactive - doesn't show any other option only the one it froze on. In the menu the filter is inactive - grey, so there is no way to disable it and make it work again. I got rid of hidden columns with no values, I am not sure what else to do. I would be very happy for an advice!

Thank you! Petra

plus moins
SO, in the menu of DATA, the filter is grayed out there too? Highlight the first row of about 4 cells, and goto DATA, FILTER. What happens?
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!