Why aren't the exceptions I selected in WS Protection working?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Excel 2003 and am attempting to protect my worksheet, but need to
allow others to be able to sort and filter data. I've followed the
instructions given by MS' "Help," but for some reason others are not able to
sort/filter data.
 
The entire range to be sorted must have cells "unlocked".

Select range A1:D45 and set those cells to "unlocked".

Protect the sheet and you can sort that range.

The Auto-Filter must already invoked before protecting the sheet.

Select columns A:D and Data>Filter>Autofilter to get the dropdown arrows.

Protect the sheet.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Similar Threads

Protecting Excel Formulas 2
allow a user to edit ranges in a protected worksheet 3
How to sort protected worksheet in Excel 07? Doesn't work. 1
Protected Sheets 2
sort part of a filtered spreadsheet 1
Protect worksheet but still be able to use Data Filter and Data Sort 2
Sorting a protected sheet 1
Protecting/Unprotecting all sheets with macro leads to "image" iss 3

Back
Top