Protecting a worksheet

If, for whatever reasons, you do not wish people to mess with the data that you are sending out in your sheet, you can simply protect the sheet.

PS: In case you want them to be able to edit parts of your sheet, you can use "Allow Users to Edit Ranges".

For protecting a worksheet, select the appropriate worksheet.
Go to the tools menu.
Tools -> Protection -> Protect Worksheet


Tools -> Protection -> Protect Worksheet











- At this stage, excel would ask you for a password. Provide a password of your choice.
- Excel then asks you to re-enter the same password.
- Click OK, and you are all set.