Sorting unlocked cells in a protected worksheet.

[Zagra147]

I have a simple worksheet where selected consecutive columns, say 'D' to 'R', are 'Data Entry' columns with the cells unlocked. The remainder columns after column 'R' contain formulae and are locked.
If I protect the sheet to prevent accidental overwriting formulae, I cannot sort the unlocked columns/cells. Is there a way around this?

Excel 2010

Regards,

Alan

[TMS]

What options did you select when you protected the sheet? Are you only trying to sort the unprotected cells?

[Zagra147]

Thanks TMS.

I figured that out almost as soon as I posted. A severe case of RTFM! DOH!

I tried to reply but for some reason I couldn't open the link to the forum for the rest of the day.

[TMS]

... I couldn't open the link to the forum for the rest of the day.

It happens


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.