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. Web select file > info. Web on the review tab, select unprotect sheet (in the protect group). Web you have three choices when it comes to protecting an entire excel workbook: 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. Enter a password in the password box, and then select ok.
Web you have three choices when it comes to protecting an entire excel workbook: Enter a password in the password box, and then select ok. Select the protect workbook box and choose encrypt with password. 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 to completely lock a sheet for viewing, follow these steps: Web select file > info. If prompted, enter the password to unprotect the worksheet.