How Do I Lock Excel Sheet - Unlock any cells that needs to be. Enter a password in the password box, and then select ok. In the ribbon, go to review > protect workbook. Click the protect workbook button and then choose encrypt with password from the dropdown menu. Web on the review tab, select unprotect sheet (in the protect group). Confirm the password in the reenter. Web to completely lock a sheet for viewing, follow these steps: Select the protect workbook box and choose encrypt with password. If prompted, enter the password to unprotect the worksheet. You'll see the info category by default.
Unlock any cells that needs to be. Web on the review tab, select unprotect sheet (in the protect group). Enter a password in the password box, and then select ok. If prompted, enter the password to unprotect the worksheet. You'll see the info category by default. Web protect an excel file. Click the protect workbook button and then choose encrypt with password from the dropdown menu. The first step is to unlock cells that others can edit, and then you can protect the worksheet with or without a password. Web to completely lock a sheet for viewing, follow these steps: In the ribbon, go to review > protect workbook. Web to set it up, open your excel file and head to the file menu. Select the protect workbook box and choose encrypt with password. Confirm the password in the reenter.