How to put password in excel file5/21/2023 ![]() Note: You can also use VBA code to protect a sheet. This means you have completely protected your worksheet from viewing. Now, if you try to unhide the sheet, you’ll see that the unhide option is disabled. Reenter the password to confirm and click OK.In the Ribbon, go to Review > Protect Workbook. Right-click the sheet you want to protect (here, Sheet1), and click Hide. ![]() To completely lock a sheet for viewing, follow these steps: You can hide Sheet1 by right-clicking it and selecting Hide.Īs 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. Say you have an Excel file with three sheets (Sheet1, Sheet2, and Sheet3). Click File > Info > Protect Workbook > Encrypt with Password in Excel 2010 / 2013, see screenshot. If you only hide the sheet without protecting it, users can still unhide the sheet and view it. Launch your workbook that you want to set a password. In Excel, you can completely hide and protect a worksheet from being viewed by hiding and then protecting the worksheet. This tutorial will demonstrate how to password protect an Excel sheet from being viewed.
0 Comments
Leave a Reply. |