How do you put a password on an Excel file?

Asked By 40 points N/A Posted on -
qa-featured

My sister keeps on using my desktop and happens to open my Excel files and mess them up. is there a way to protect the file from being opened by putting a password? I know how to protect a sheet but I want a more secured way of protecting my file by not allowing it to be opened in the first place. 

SHARE
Best Answer by kijingo
Answered By 0 points N/A #98715

How do you put a password on an Excel file?

qa-featured

Dear Gmlaud,

Here is how you can put password in an Excel document and protect it from access by anyone. To password protect a file:

  1. Click on the Office menu and save the file using Save As.
  2. Go to tools and click General Options.
  3. Then if you want the password protection right even before you can open the document, type a password in the "Password to open" box. If you want it only or as well be protected from any change, type a password in the "Password to modify" box. You can assign both at the same time for maximum security.
  4. Save the file.

Hope this helps.

Best Answer
Best Answer
Answered By 0 points N/A #98717

How do you put a password on an Excel file?

qa-featured

Here is the solution to your question.

For Microsoft Word documents (Word 2000 and newer), you can choose a higher level of security when saving a file. Rather than simply clicking "Save", click File, then Save As and follow these steps:

  1. Click on Tools in the upper right corner of the file save dialog box
  2. Click on Security Options
  3. The Security Options box provides a variety of options:

    • You can enter a password in the box next to Password to open if you wish the file to be completely inaccessible without the password
    • In Word 2002 and 2003, you can click on the Advanced button next to the password box to choose a higher level of encryption that is even harder to break into.

Welcome.

Answered By 0 points N/A #98719

How do you put a password on an Excel file?

qa-featured

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.).

1. On the File menu, click Save As.

2. On the Tools menu, click General Options.

3. 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.

4. 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.

5. 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.

6. Click OK.

7. When prompted, retype your passwords to confirm them.

8. Click Save.

9. 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).

That's it.

Login/Register to Answer

Related Questions