"Filter by color" has disappeared from my dropdown filter

I have an Excel sheet, and when using the data filters, Filter By Color is not available. There is definitely more than one color in the column I'm trying to filter on, so why isn't it showing?

1 Answer

The spreadsheet was in Sharing mode. For some reason, this removes Filter by color and Sort by color. I turned sharing mode off, and they returned.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy