Disable Sorting in excel

Question

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.

Answer 1

Go to the Home ribbon, click the arrow below the Sort & Filter icon in the Editing group and choose Clear.