See all How-To Articles

How to Password Protect / Lock an Excel Sheet for Viewing

This tutorial will demonstrate how to password protect an Excel sheet for viewing.

 

password protect sheet for viewing 7

 

Lock an Excel Sheet For Viewing

In Excel, you can completely hide and protect a worksheet for viewing. If you only hide a sheet without protecting it, users can unhide the sheet and view it. Say you have an Excel file with three sheets (Sheet1, Sheet2, and Sheet3).

 

password protect sheet for viewing 1

 

You can hide Sheet1 by right-clicking it and selecting Hide.

 

password protect sheet for viewing 2

 

As a result, this sheet is hidden, but if you right-click on any of the other sheets’ tabs, you can unhide it by clicking Unhide.

 

password protect sheet for viewing 3

 

To completely lock a sheet for viewing, follow these steps:

1. Right-click the sheet you want to protect (in this example, Sheet1), and click Hide.

 

password protect sheet for viewing 2

 

2. Now, protect the workbook. In the Ribbon, go to Review > Protect Workbook.

 

password protect sheet for viewing 4

 

3. Enter a password, and press OK.

 

password protect sheet for viewing 5

 

4. Reenter the password to confirm and click OK.

 

password protect sheet for viewing 6

 

Now, if you try to unhide the sheet, you’ll see that the unhide option is disabled. This means you have completely protected your worksheet from viewing.

 

password protect sheet for viewing 7

 

Note: You can also use VBA code to protect a sheet.