Select what the user can do after protection is enabled
In worksheet-level protection, you select what the user is allowed to do within an Excel worksheet 😀
You can specify which features and functions they can and can’t do in it. For example, you can allow them to only enter data or insert hyperlinks but not format cells or insert rows and columns.
To do that, you must know that worksheet protection is a two-step process.
First, make sure that you locked the specific cells you want to be protected in your worksheet. You can click here for a step-by-step guide.
Now that you’ve locked the cells, it’s time for the second step.
- Go to the Review Tab.
- Click Protect Sheet in the Protect group in the Review Tab.
The Protect Sheet dialog box will appear.
You have the option to password-protect the worksheet. This gives you a layer of protection.
You’ll see the default protection as well: select locked and unlocked cells.
- Now, select other features and functions that you would like to allow users to do by ticking the checkbox on their left side.
- Click OK.
That’s it 🙌
All these checked features and functions are now allowed when you’re working with Excel worksheets.
This means that users including you, can now format cells, insert hyperlinks, Sort data, use AutoFilter, and Edit Objects within your worksheet, other than the default cell selection 😀
When you right-click on the cells, you’ll see the features you’ve selected are now available.
If you want to change the features and function, you can always click the unprotect sheet button and select other features you want.