How do I display a worksheet with a password?

How do you password protect an Excel worksheet from viewing?

Require a password to open or modify a workbook

  1. Open the sheet or workbook that you want to protect.
  2. On the Review tab, click Protect Sheet or Protect Workbook.
  3. In the Password box, type a password, and in the Verify box, type the password again.
  4. Choose any other protection options you want and click OK.
  5. Click Save.

How do you password protect a worksheet?

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.

Can you restrict access to a sheet in Excel?

Please click to select the workbook which contains the worksheet you need to make it very hidden in the Workbook windows box. And in the Sheets box, click to select the certain sheet you will restrict access by others, then specify the VeryHidden option from the drop-down list. And finally close the dialog box.

How do I change a password to open an Excel file?

Change a workbook password

  1. Open the workbook that you want to change the password for.
  2. On the Review tab, under Protection, click Passwords.
  3. In the Password to open box or Password to modify box, select all contents.
  4. Type the new password, and then click OK.
Read more  How do I find out all my passwords?

How do you password protect a file?

Protect a document with a password

  1. Go to File > Info > Protect Document > Encrypt with Password.
  2. Type a password, then type it again to confirm it.
  3. Save the file to make sure the password takes effect.

Why does Excel have two options for passwords?

You have two choices here: File encryption: When you choose this option, you specify a password and lock the Excel file. This prevents other users from opening the file. … Setting a password to open or modify a file: You specify a password to open or modify a file.

How can I protect a folder by password?

Password-protect a folder

  1. In Windows Explorer, navigate to the folder you want to password-protect. Right-click on the folder.
  2. Select Properties from the menu. On the dialog that appears, click the General tab.
  3. Click the Advanced button, then select Encrypt content to secure data. …
  4. Double-click the the folder to ensure you can access it.

How do I unlock a password protected Excel file for free?


  1. Click “Browse…” and select the . XLS or . XLSX file you would like to unprotect.
  2. Agree to the Terms of Service by checking the appropriate check box.
  3. Click “Unlock File!” – and you’re done!