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