Ever wish you could just fix it so your worksheet could not be altered or potentially corrupted? You are not alone! The good news is that there actually IS a way to do this!
It is a great feature to use. The result of the action you about to learn, is that it will prevent a user from doing just about anything with your data unless they know how to unlock it and are privy to your password, if one has been used.
Follow the steps below to learn how:
- Go to the Review tab, in the Changes group on your Ribbon .
- Click on Protect Sheet.
- Select if you want to use a password protect your data or not. This is optional.
- Select what you would like a user to do in your worksheet. There are a lot of options, but Select locked cells and Selected unlocked cells are selected by default and this will usually be enough.
- Click OK and you are finished.
Now, a user cannot change any data in your worksheet, the message below will appear.
The message tells the user where to go to Unprotect the worksheet though, so if you did not enter a password in the step above, then it will be fairly easy for any user to change your data.
- To unprotect a worksheet, follow the steps below:
- Open your worksheet.
- Go to the Review tab in the Changes group on your Ribbon.
- Select Unprotect Sheet.
- This will only appear if your sheet is protected.
- If there is a password for your sheet, you would enter it now.
Your sheet is now unprotected and can be worked on as one normally would.