CODEWITHSUNDEEP
excelsorting
Head and toes
Head and toes

Reputation: 659

Disable Sorting in excel

I have an excel document with many columns and many rows filled with data. I want to be prevent user for sorting the data completely, but user should be able to insert and delete row as they wish. They can also edit any cells that they want.

May I know if there is anyway to achieve that?

Thanks.

Upvotes: 1

Views: 27476

Answers (1)

Srijan
Srijan

Reputation: 152

I think this should work-

Protect the worksheet and check all the option other than the Sort and autofilter and you should be good to go.

Upvotes: 3

Related Questions