Kay has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course
How to allow Sort & filter’ > ‘Clear’ in protected sheets?
Allow sorting and filtering in a protected sheet
I have a protected sheet however I often have to play to find the filter if someone saves the sheet whilst filtered, rather than use ‘Sort & filter’ > ‘Clear’ (as this is greyed out when protected)
I have tried to change the settings "In the Allow Users to Edit Ranges dialog, by clicking New to display the New Range dialog however this is still not working - Sort and Filter> Clear is still greyed out
I would like to protect the sheet however enable ‘Sort & filter’ > ‘Clear’. Is it possible to do this?
Appreciate your help on this
RE: How to allow Sort & filter’ > ‘Clear’ in protected sheets?
Hi Kay
Thank you for using the forum to ask a question.
Unfortunately there isn't a way to clear filters while a sheet is protected. This is a known problem with Excel. It means that you need to keep removing protection to clear all filters before protecting it again.
Kind regards
Richard Bailey
Microsoft Certified Trainer
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
