Thread: Sort Data In A Protected Worksheet

Once you protect a worksheet, Excel stops users from executing variety of tasks on the worksheet data. You can still allow you colleagues to do some basic operations and yet have the sheet protected:



1.Under the Review tab, select Protect Sheet.

2.At the bottom of the dialog box you will see long list of check boxes. Checking each box will allow the user that particular operation. This way, you caI1 specify what all functions the users are permitted to perform on the worksheet.