An FAQ that never seems to be answered: autofiltering with protection on...



Hey everybody,

I just did a quick search on this topic and found multiple posts, but
none answered my particular question. Here's the situation:

I'm using Microsoft Excel 2003.

I have created an autofilter for a cell range and then protected the
sheet with the "Use Autofilter" box marked. The autofilter seems to be
functioning properly with one exception:

It won't let me use either the "Sort Ascending" or "Sort Descending"
features in any column. Instead, I receive the standard cell protection
error message:
The cell or chart you are trying to change is protected and therefore

To modify a protected cell or chart, first remove protection using the
Unprotect Sheet command (Tools menu, Protection submenu). You may be
prompted for a password.

I have tried

- unlocking all cells in the filter,
- unlocking the header cells,
- limiting the filter to 10 rows and unlocking row 11, and
- allowing various other permissions with protection.

Does anyone know how to fix this? ideally, without leaving the cells

Thanks in advance,



Debra Dalgleish

The entire list, including heading cells, would have to be unlocked, in
order to sort on a protected sheet.
Enable Sort and Autofilter when you protect the sheet.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question