We had already seen the following tutorials related with protection of worksheet in Excel 2016, 2013 & 2010.
- Prevent users from adding new worksheet.
- Password Protect Worksheet in Excel.
- Unprotect Worksheet in Excel.
And if a worksheet with auto filter is protected then users will not be able to use auto filter unless it is enabled while protecting the worksheet. This tutorial is about the steps required for enabling auto filter for a protected worksheet in Excel 2010.
Click the Protect Sheet option available under Review menu or Info menu.
Click Review menu –> Changes –> Protect Sheet
Click File menu –> Info menu –> Protect Workbook –> Protect Current Sheet.
On clicking the Protect Sheet option would display the following Protect Sheet window.
Scroll down the “Allow all users of this worksheet to” list and make sure to tick the check box with caption as “Use AutoFilter”. Click OK button to confirm and save the changes.
Now excel users will be able to use the auto filter option even in a protected worksheet.