There are many ways to protect your work. Protect your file from other people who are not responsible. So even on the results of your work stored in the form of an excel file. In addition, you can protect the file with a password to open it, you also protect your files with protecting the worksheet, in this way others can still see the results of your job, but there is no one can change your work. By using this trick, you can share with friends or colleagues, without fear that other will modify your work. Next, how to protect your worksheet? Follow the reviews below to get details, and your right to know how to protect your worksheet.
How to protect an excel file with a password so cannot be edited?
- Open your Excel worksheet.
- Mouse over the sheet name below, and then right click your mouse.
- Check the "protect your worksheet contents of locked cells"
- Check the "select locked cells"
- Check the "select unlocked cells"
- Enter a password on the "password to unprotect sheet".
- Click "OK".
- Will then be prompted to enter the password again (same as the password you type before)
- Click "OK".
- It’s Done.
The example on the screenshot is an example to protect the sheet 1. You can protect the sheet 2, 3 and so on in the same way. Following a password on sheet, you can save the file as usual.