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.Step 4: The file gets converted into a zip file. Step 3: The device system will fetch a confirmation window, click on Yes. Step 2: Modify the File Extension to zip from xlsx. File Explorer will show the selected file types (i.e., xlsx ). To completely lock a sheet for viewing, follow these steps: Step 1: In the device directory, Select the encrypted file, and go to View > Tick File name extensions. 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). If you only hide the sheet without protecting it, users can still unhide the sheet and view it. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |