sorting after protection

briannakmg

New Member
Joined
Jan 26, 2006
Messages
42
I have a worksheet that has a list of data with autofilter on the header row. All of the cells on the sheet are locked. I want to password protect the sheet but still allow users to sort and use the auto filter.

After I go to tools/protection/protect sheet and check the boxes with sort and auto filter then type in my password, users are only able to sort by entry. They cannot "sort ascending" or "sort descending". For example if one of the columns has "red, blue, green" The user can sort by selecting "red" but can't sort them in ascending order.

Is there something that I am doing wrong or is there no way to "sort ascending/descending" after protection has been enforced?
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Forum statistics

Threads
1,136,655
Messages
5,677,019
Members
419,668
Latest member
DharmaK

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top