Not able to Sort on a protected sheet in Excel

Hi,

I am not able to Sort on a protected sheet in Excel.  I have selected the box in the protection menu but it does not work.

By contrast, the Auto-filter function I selected, functions correctly.

Advise or trick?  Is this a bug that needs to be fixed?

Thanks.

 

Question Info


Last updated May 10, 2020 Views 36,778 Applies to:
Answer
Answer

Hi,

is the range to be sorted unlocked, highlight the range, right click on the mouse,format cells, protection, unckeck locked,ok, then protect the sheet and check the sort box

If this post is helpful or answers the question, please mark it so, thank you.

2 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Answer
Answer

I have this Sort box selected, but it does not work.  I've experimented with most of the other check boxes and they all seem to function as they should except the Sort box.  (i.e. insert column, auto filter, etc...)

Am I the only one experiencing this issue?  I'm running Windows 7 Enterprise and Office 2010.

Thanks.

1 person was helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.