This tutorial will demonstrate how to password protect an Excel sheet for viewing.
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).
You can hide Sheet1 by right-clicking it and selecting Hide.
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.
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.
2. Now, protect the workbook. In the Ribbon, go to Review > Protect Workbook.
3. Enter a password, and press OK.
4. Reenter the password to confirm and click OK.
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.
Note: You can also use VBA code to protect a sheet.