How do I Password protect an Excel 2010 File?

Protect an Excel file

  1. Select File > Info.
  2. Select the Protect Workbook box and choose Encrypt with Password.
  3. Enter a password in the Password box, and then select OK.
  4. Confirm the password in the Reenter Password box, and then select OK.

How do I protect an Excel spreadsheet with a Password?

To prevent other users from opening a workbook by encrypting a password:

  1. Click the File tab in the Ribbon. The Backstage View appears.
  2. Select Info.
  3. Click Protect Workbook. A drop-down menu appears.
  4. Choose Encrypt with Password.
  5. Enter a password in the edit box.
  6. Click OK.
  7. Re-enter the password.
  8. Click OK.

How do I add a Password to Office 2010?

Step 1 – Click the File tab, then Click Info. On the menu to the right Click Protect Document and Click Encrypt with Password. Step 2 – The Encrypt Document dialog will appear, Type in a strong password and then Click OK to finish. Please note – It’s critical to use a strong password or passphrase step #2.

How do you password protect an Excel file but allow read only?

More videos on YouTube

  1. Click on the Tools button and click General Options.
  2. In the Password to modify box, enter a password and click OK.
  3. Note: If you only want to recommend users to open the Excel file as read-only, without protecting it, don’t enter a password and check Read-only recommended.

How do you password protect a File?

First, open the Office document you would like to protect. Click the File menu, select the Info tab, and then select the Protect Document button. Click Encrypt with Password. Enter your password then click OK.

How do you password protect an Excel File but allow read only?

How do you put a password on an Excel file with read only option?

For a better protection, protect the sheet with a password.

  1. Open a workbook.
  2. On the File tab, click Save As.
  3. Click Browse.
  4. Click on the Tools button and click General Options.
  5. In the Password to modify box, enter a password and click OK.
  6. Reenter the password and click on OK.
  7. Enter a file name and click Save.

How do I Password protect a Word 2010 document?

Step 1: Open the document in Microsoft Word 2010. Step 2: Click the File tab at the top-left corner of the window. Step 3: Click the Info tab at the left side of the window. Step 4: Click the Protect Document drop-down menu at the center of the window, then click the Encrypt with Password option.

How do you put a Password on a File?

How To Password Protect a Folder in Windows

  1. Select the file or folder you want to encrypt.
  2. Right-click on that file and select “Properties” in the drop down menu.
  3. On the General tab, click the Advanced button.
  4. Check the box next to “Encrypt contents to secure data”
  5. Click Apply and then click OK.

How do you lock a file in Excel?

To prevent others from accessing data in your Excel files, protect your Excel file with a password. Select File > Info . Select the Protect Workbook box and choose Encrypt with Password. Enter a password in the Password box, and then select OK . Confirm the password in the Reenter Password box, and then select OK . See More….

How do you apply a password to an Excel file?

Adding a password Step 1: In Excel, open the document you want to secure with a password. Step 2: Click “File,” followed by “Info.” Step 3: Next, click the “Protect Workbook” button. Step 4: Excel will then prompt you to type in a password.

How can I protect an Excel workbook?

Excel provides a way that you can protect an entire workbook. To stop the user from taking actions such as renaming a worksheet or inserting new worksheets, you must use workbook-level protection. To protect your workbook, select Protection from the Tools menu and then choose the Protect Workbook option.