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