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