Hello

I have 3 cells A1, B1, and C1 that are protected and these are column
headings. I want to be able to autofilter the data under these columns using
auto filter. I locked these cells by selecting format-protection-locked.
I then selected protect this sheet and allow user to do autofilter and to
select unlock and locked cells. However, when I try to use autofilter for
these locked cells I still can't use autofilter. I also tried selecting
autofilter on these columns first and then protecting them but then I can not
use autofilter on the other columns that are not protected. Can you please
explain how I can make sure autofilter work on all cells of the sheet
including the locked cells?

Thanks.