If you keep your files in the office
or any other shared computers, chances are there that others may access your
files and make alterations or deletions.
You have created an Excel file with sensitive data having some special formulas
and for which you have taken so much time and effort to create it. If you lose any number or formula the whole
sheet will have no use and creating the same may take time.
There may be data which you have to
show or share to other employees including your boss but at the same time you need
to protect them from any alteration or deletion. There is an option to protect your MS-Excel
sheets, follow the steps below:
- Open the file à Select your particular sheet
- Right Click on the Mouse à you can see an option ‘Protect Sheet’
- Select ‘Protect Sheet’ à a pop up window will appear named ‘Protect Sheet’
- Check the option ‘Protect worksheet and contents of locked cells’ at the top
- Type the password in the space provided just below ‘Password to unprotect sheet’ à click ‘OK’
- Another window 'Confirm Password' will open and ask you to ‘Reenter password to proceed’
(Remember if you forget the password, you cannot recover it) à retype the password and click ‘OK’
The sheet is now protected. You can also check the options to allow users to do some functions like ‘Insert rows or columns’, ‘Delete rows or columns’, ‘sort’, etc (see picture No.2).
If any one tries to make alterations or deletions, they will see the message as below:
You can also unprotect the sheet by using the ‘Unprotect Sheet’ (see below picture).
Type the password to unprotect the sheet in the pop up window ‘Unprotect Sheet’.
The sheet will become free from restrictions of use.
0 Comments For "How to Protect Sheets in MS-Excel?"