|
|
|
|
|
Password protect your Excel sheets
If you don't want other people changing the content of your sheet, you can put a password on it.
|
|
 |
|
|
|
|
|
|
|
|
|
|
 |
1.
|
|
|
Open an Excel file which sheet you want to password protect.
Click Review in the menu.
|
|
| |
2.
|
|
|
Click Protect Sheet button.
|
|
| |
3.
|
|
|
Check Protect worksheet and contents of locked files and enter the password.
Click OK.
|
|
| |
4.
|
|
|
Enter the same password once again and don't forget that password, for you will need it to unprotect your sheet again.
|
|
| |
5.
|
|
|
If you or someone else tries to change the content of the cells in this sheet, a pop-up appears saying you mass unprotect the sheet if you want to make some changes.
The password protection will only work on the very sheet you set it on, other sheets will stay unprotected.
|
|
| |
6.
|
|
|
To unprotect the sheet, click Review in the menu, click Unprotect Sheet button ...
|
|
| |
7.
|
|
|
... enter the password you set for that sheet and click OK.
Now you or anyone else can again change the content of the sheet.
|
|
|
 |
|
|
|
