We help IT Professionals succeed at work.

Filters in excel

Kiwi-123 used Ask the Experts™
Is it possible to use the inbuilt filter function when the spreadsheet is locked (Password protected)?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Yes, you have to enable the option when formatting the cells.

Highlight the cells > File > Permissions > Protect Workbook > Protect Current Sheet > Scroll down to see option to "use auto filter" - see attached image. You can set the password here as well.
Most Valuable Expert 2011
Awarded 2010

Yes, the Autofilter function can be used to filter (not sort!!) list data, if the cells are not locked. When protecting the sheet, make sure to tick the box for "Use AutoFilter" in the list of things the user will be allowed.

See attached file.

cheers, teylyn
In Excel, there are two parts to the protection mechanism:
1. You can apply protection to a worksheet, and specify what actions a user can perform, and
2. You can specify which cells on the worksheet are locked (the user can't do ANYTHING to the cells), and which are UNlocked (the user can perform the allowed actions on those cells).

So if you have already protected spreedsheet you can't use filter.