How To Lock An Excel Sheet - The first step is to unlock cells that others can edit, and then you can protect the worksheet with or without a password. Select the protect workbook box and choose encrypt with password. Web you have three choices when it comes to protecting an entire excel workbook: If prompted, enter the password to unprotect the worksheet. Web on the review tab, select unprotect sheet (in the protect group). Web to completely lock a sheet for viewing, follow these steps: Web select file > info. Enter a password in the password box, and then select ok.
Enter a password in the password box, and then select ok. The first step is to unlock cells that others can edit, and then you can protect the worksheet with or without a password. Web on the review tab, select unprotect sheet (in the protect group). 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. Web you have three choices when it comes to protecting an entire excel workbook: Web select file > info.