How to Protect Excel Sheet from Viewing Using Password

If you want to protect the Excel sheet from viewing by using a password, this article is for you. Here, we describe 3 simple, easy, and effective methods to do the task effortlessly.

Download Workbook

3 Methods to Protect Excel Sheet from Viewing Using Password

Here, the following Employee List table in the Dataset Excel sheet contains information that we want to protect. Therefore, we will use 3 methods to protect that Excel sheet from viewing using a password. Here, we used Excel 365. You can use any available Excel version.

password protect excel sheet from viewing


Method-1: Using Review Tab to Protect Sheet from Viewing with Password

In this method, we will use the Review tab to give a password so that we can protect the Dataset sheet from viewing.

➤ First of all, we will right-click on the sheet name which is Dataset > click on Hide.

After that, a confirmation window will appear.

➤ Click OK.

➤ Afterward, we will go to the Review tab > select Protect > click on Protect Sheet.

password protect excel sheet from viewing

Now, a Protect Sheet window will appear.

➤ After that, we will give a password in the Password to unprotect sheet box.

➤ Click OK.

A Confirm Password window will appear.

➤ After that, we have to reenter the password in the Reenter password to proceed box.

➤ Finally, if we now click on any cell in the Dataset sheet to edit, we will see that a warning appears. Therefore, the sheet has been protected with a password.

password protect excel sheet from viewing

Read More: How to Protect Excel Sheet from Editing (7 Smart Ways)


Method-2: Using Info Option from File Tab

In this method, we will use the Info option to password protect the Excel sheet from viewing.

➤ First of all, we will go to the File tab in the ribbon.

password protect excel sheet from viewing

➤ After that, we will select Info > click on Protect Workbook > select Protect Current Sheet.

Now, a Protect Sheet window will appear.

➤ After that, we will give a password in the Password to unprotect sheet box.

➤ Click OK.

A Confirm Password window will appear.

➤ After that, we have to reenter the password in the Reenter password to proceed box.

➤ Finally, if we now click on any cell in the Dataset sheet to edit, we will see that a warning appears. Therefore, the sheet has been protected with a password.

password protect excel sheet from viewing

Read More: How to Protect Excel Sheet with Password (3 Quick Approaches)


Similar Readings


Method-3: Protect Workbook While Saving

In this method, we will protect the entire workbook in Excel from viewing by using a password.

➤ First of all, we will go to the File tab.

password protect excel sheet from viewing

➤ After that, we will click on Save As.

Then, we will select the location where we want to save the file, and we have to give the file a name.

➤ After that, we will click on Tools which is at the left of Save > select General Options.

Now, a General Options window will appear.

➤ We will give a password in the Password to Open box > give a password in the Password to Modify box > click OK.

A Confirm Password window will appear.

➤ After that, we have to reenter the password in the Reenter password to proceed box > click OK.

Another Confirm Password window will appear.

➤ After that, we have to reenter the password in the Reenter password to modify box > click OK.

➤ Finally, we can see that when we want to open the Excel file, it does not open. We can see that it requires a password to open.

password protect excel sheet from viewing

Read More: How to Protect a Worksheet in Excel (6 Effective Ways)


Conclusion

Here, we tried to show you 3 methods to password protect the Excel sheet from viewing. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, feel free to know us in the comment section. You can check the ExcelDemy site for more Excel solutions.


Related Articles

Afia

Afia

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo