Discussion Locked

How to password protect Excel worksheet

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Can you protect individual worksheets in Microsoft Excel? If so, how?
I want to set a different password for each sheet in such a way that if the person doesn't have the password, he or she is unable to neither open the worksheet nor see the contents of the worksheet.

Thanks

6 replies

by thechas

The password protection in Excel protects the worksheet from being changed. Anyone with access to the file can view the spreadsheet.

You are looking for file protection.
On a NTFS drive, you have options for setting security for a file or folder.

On a FAT32 drive, you would need a 3rd party utility to protect your file or folder.

Chas

by aoife

Protecting worksheets and workbooks in excel is very simple:

Protecting worksheets:
if you only want certain cells to be edited in a worksheet do the following steps

1.select the cell range you want to leave editable

2.go to Format/Cells/Protection by default the cells are marked as locked, remove the check mark from the locked box that will unlock that cell range

3. then you need to protect the worksheet
Tools/Protection / Protect worksheet

4. Ensure all three options at the top of the dialogue box are selected

5. type a password

Only the cells you unlocked are now editable, if you want the entire worksheet protected only use steps 3-5

Protecting workbooks
If you do not want all worksheet's viewable hide the worksheets first

1. Tools/Protection / Protect workbook
2. Protect the workbook structure

hopr this helps

by davidfranks78

If it is possible for you to split each worksheet as a different file, then you can password protect each file with a different password as follows:

In the File -> Save As option, select the "Tools" dropdown and click the "General Options" option. There you can enter a password to open the file.

Regards

by srinuvasu143

Protecting worksheets and workbooks in excel is simple:

Try to follow these steps:

1.select the cell range you want to leave editable

2.go to Format/Cells/Protection by default the cells are marked as locked, remove the check mark from the locked box that will unlock that cell range

3. then you need to protect the worksheet
Tools/Protection / Protect worksheet

4. Ensure all three options at the top of the dialogue box are selected

5. type a password

Only the cells you unlocked are now editable, if you want the entire worksheet protected only use steps 3-5

Protecting workbooks
If you do not want all worksheet's viewable hide the worksheets first

1. Tools/Protection / Protect workbook
2. Protect the workbook structure

Bye

This discussion is closed to new replies.