Protect Cell

[Guest]

I want to protect one cell "E3" on a worksheet, all other unprotected. I
have an area that is set up with the Data/AutoFilter where the dropdown
arrows go across line 6, ie below the protected cell. Here is my issue:
When I Set all the cells to Unprotected and then set E3 to Protected and
then Protect the Sheet the AutoFilter is locked and not funtional. Is there
another solution to this.

Thank you,

Steven

 

[Per Erik Midtrød]

When you protect the sheet scroll down the list that pops up and check
the use Autofilter box. I think that option came with Excel 2002.

Per Erik