Lock cells but allow sorting and filtering

[Guest]

Is there any way to Lock cells such that the cell values cannot be changed
but still allow sorting and filtering?

I have gone through the steps of Locking all cells on a worksheet and then
protecting the worksheet with a password. When protecting the worksheet I
have checked the boxes to allow for sorting and filtering. However, when I
go to the Data menu, the AutoFilter is grayed out and when I try to sort I
get the message saying that the worksheet is protected and that it must be
Unprotected before any changes can be made.

Thank you for your time and assistance.

 

[mspikowski]

I am not sure of the best way to make Sort work on a protected sheet.
However, I have successfully made AutoFilter work on a protected
sheet. Before you protect the sheet, select Data > Filter >
AutoFilter. Then the AutoFilter arrows will appear on the column
headers. Now protect the worksheet, and make sure to check the box
Allow all users of this worksheet to: Use AutoFilter. You will be
able to use some AutoFilter functions, but not Sort Ascending or Sort
Descending. You will also not be able to select Data > Filter > Show
All when the worksheet is protected. All users will be able to use
AutoFilter, but they will not be able to remove the AutoFilter arrows
from the column headers.

 

[Guest]

Thank you for the help.
I guess Auto Filter will have to suffice.
If somebody needs to sort, they will just have to Copy & Paste the data into
a new workbook and sort it there.