DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

How to Password Protect a Sheet in Excel Office 365?

Password Protect a Sheet in Excel:

In this article, we are going to explore how to Password Protect a Sheet in Excel Office 365. Let’s step into this article!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Password Protect an Excel Sheet:

Do the below steps to password protect a sheet.

  • You have to go to the File Option.

File Option
File Option

  • Then, you have to click the Info option and choose the *Protect Workbook * Option.

Info Option
Info Option

  • Now, you have to select Encrypt with Password option from the menu list.

Encrypt with password
Encrypt with password

  • It will open the Encrypt Document dialog box , you have to enter your password in the text field.

Encrypt Document dialog box
Encrypt Document dialog box

  • Then, Re-enter your password in the Confirm Password dialog box.

Confirm Password dialog box
Confirm Password dialog box

  • Now, the sheet is protected with a password.

Protected workbook
Protected workbook

You can make use of the below video tutorial to protect your sheet in Excel using the password.

<!--[if lt IE 9]>document.createElement(&#39;video&#39;);<![endif]-->

Open a Password-Protected Sheet in Excel:

  • Open the protected Excel file and it will prompt you to enter the password of the sheet.
  • Once you enter the correct password , hit the Open button.
  • The password-protected Excel sheet will open and ready to work with it.
  • Kindly, watch the below video tutorial to unlock the password-protected Excel file for your reference.

Verdict:

In this article, you can understand how to Password Protect a Sheet in Excel Office 365. Drop your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!!

Top comments (0)