how do i lock excel files with a password?

Answer 1

There are in fact two ways to password protect your Excel file.

First is listed below:

Open the workbook.
On the File menu, click Save As.
On the Tools menu, click General Options.
In the Password to open or Password to modify box, double-click the symbols that represent the existing password.
To change the password, type the new password, and then click OK.
Passwords are case sensitive. Type the password exactly as you want users to enter it, including uppercase and lowercase letters.
To remove the password, press the DELETE key, and then click OK.
If you changed the password, retype the new password, and then click OK.
Click Save.
If prompted, click Yes to replace the existing workbook with the open workbook.
(From Excel Help documentation)

Secondly, u can compress the file into zip format and while compressing add a password to it. So, the next time u uncompressed it, you will be asked for the password before unzipping.

Hope this helps and good luck!

Answer 2

1. Open the file you want to protect.
2. On the menu bar, click File.
3. From the drop-down, click Save As..
4. Click the Tools button (which you'll find near top right of the Save As dialogue box).
5. From the drop-down click General Options.
6. You will now get a dialogue box for entering your Password needed to open the file. You can also enter a Password necessary for modifying the file.
Hope this helps.

Answer 3

Once you have completed your document there are only a few simple steps required to protect it. First left-click on the "Tools" menu and then select "Options" from the drop down menu.

On the "Options" screen that appears you must left-click on the 'Security' tab to display the window shown below.

Once you have clicked on the 'Security Tab' you must enter a password in the 'Password to Open:' box. Doing this prevents anyone from being able to open the document without the password you assign.

Remember to use a unique password that will not be easy for someone else to figure out.

Click on OK once you have chosen a password. The window shown below will appear asking you to verify the password you entered.

Once you have done this save the document as you normally would and forward it as usual.

Answer 4

Open the workbook that you want to password protect. On the tools menu select options. In the options dialog box click on the security tab. Following the prompts.

The above instructions apply to Microsoft Excel 2003.

Answer 5

You can individually password protect any file with freeware software that is available by typing something along the lines of "password protect files freeware" in google.

Answer 6

Secure a workbook with a password
Show All
Hide All
To allow only authorized users to view or modify your data, you can help secure your entire workbook file with a password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.).

On the File menu, click Save As.
On the Tools menu, click General Options.
Do either or both of the following:
If you want users to enter a password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.) before they can view the workbook, type a password in the Password to open box, and then click OK.
If you want users to enter a password before they can save changes to the workbook, type a password in the Password to modify box.
Note Unlike passwords you specify in the Password to open box, passwords you specify in the Password to modify box are not encrypted. These passwords are only meant to give specific users permission to modify workbook data. For optimal password security, it's best to assign both passwords. An encrypted password to access the workbook, and one to provide specific users with permission to modify its content.

Important Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don't have to write it down.

If you want to use a different encryption type, click Advanced, click the type you want in the Choose an encryption type list, and then click OK.
If needed, specify the number of characters you want in the Choose a key length box.
Note Document property encryption is enabled by default for most encryption types and providers. It prevents unauthorized users from viewing summary and custom file properties (such as the author or any custom file information) in the Properties dialog box. When users right-click the password-protected file, and then click Properties, information won't be available on the Summary tab and Custom tab. Authorized users, however, can open the file and view all file properties (File menu, Properties command). To disable document property encryption, clear the Encrypt document properties check box.

Click OK.
When prompted, retype your passwords to confirm them.
Click Save.
If prompted, click Yes to replace the existing workbook.
Note You can also secure a workbook with a password on the Security tab of the Options dialog box (Tools menu, Options command).

Answer 7

Go to Tools>Protection. From there you can chose from the various categories to set a password.

Answer 8

On the Tools menu, point to Protection, and then click Protect Sheet.
and give it a password...don't forget to vote

Answer 9

Open the file.
Click the File, -Option 'save as' will appear in the drop down menu.
Click 'Save as', a new window will appear.
Click 'Tools"
Click 'General Options'.

Now you can proceed yourself.

Answer 10

go to settings on ur file n then select security options....then password. try it out...it may work. good luck