How to Protect Excel Sheet from Viewing Using Password

Get FREE Advanced Excel Exercises with Solutions!

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.

Here, the following Employee List table in the Excel sheet named Dataset 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


1. Using Review Tab to Protect Excel 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 with Password


2. Protecting Sheet from Viewing with Password Through 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 an Excel Sheet Except for Certain Cells


3. Protecting Excel Workbook from Viewing with Password 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


Download Workbook


Conclusion

In this Excel tutorial, we have shown 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 let us know in the comment section. We will get back to you as early as possible.


Related Articles


<< Go Back to Protect Excel Sheet | Excel Protect | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo