General discussion

Locked

How to password protect Excel worksheet

By arunk ·
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

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by TheChas In reply to How to password protect E ...

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

Collapse -

by DKlippert In reply to How to password protect E ...

Everything you need to know about protection

See John Walkenbach at:

http://tinyurl.com/yqfun

Collapse -

by Aoife In reply to How to password protect E ...

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

Collapse -

by davidfranks78 In reply to How to password protect E ...

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

Collapse -

by davidfranks78 In reply to

The link given by DKLippert is really good. It has a lot of information about excel

Collapse -

by srinuvasu143 In reply to How to password protect E ...

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

Back to Software Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums