Prevent a User from Changing Any Data in Excel 2007

We will show you how to lock a spreadsheet so that nothing can be changed in it.

This is a great feature to use when you want to present data without allowing for it to be potentially corrupted or altered.

The result of this action is that it will prevent a user from doing almost anything with your data unless they know how to unlock it and know your password, if one is used.

Steps to Protect a Worksheet in Excel

1. Go to the Review tab and click the Protect Sheet button:

2. Choose if you want to password protect the data or not. This is optional.

3. Choose what you want a user to be able to do within the worksheet. There are many options, but "Select locked cells" and "Select unlocked cells" are selected by default and this is good enough usually.

4. Hit OK and you are DONE.

Now, the user cannot change any data within this worksheet. If they try to do something that is not allowed, this is the message they see:

This message does tell the user where to go to Unprotect the worksheet though, so, if you did not enter a password in Step 2 above, then it will be really easy for any user to change data on the sheet.