I have a large number of people looking at my spreadsheet and I constantly get the problem of someone using filter instead of filterview which is a problem and highly annoying. I make announcements in emails, send notifications and even have a row colored in red saying "DO NOT USE FILTER, USE FILTER VIEW" but still I get people using filter.

I've tried protecting that row which prevents the user from using filter but it also prevents the user from using filter view as well.

How can I lock filter and not filter view?


Add people as viewers, not as editors or protect the entire sheet not only one row.

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.