How To Lock An Excel Worksheet. Web on the review tab, select unprotect sheet (in the protect group). Enter a password in the password box, and then select ok.
lock worksheet in excel
If prompted, enter the password to unprotect the worksheet. 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). Click the protect workbook button and then choose encrypt with password from the dropdown menu. Web to set it up, open your excel file and head to the file menu. Confirm the password in the reenter. Web protect an excel file. Enter a password in the password box, and then select ok. You'll see the info category by default. Web select file > info.
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 select file > info. Confirm the password in the reenter. Unlock any cells that needs to be. Enter a password in the password box, and then select ok. You'll see the info category by default. Web protect an excel file. Create a strong password to protect your excel workbook. Click the protect workbook button and then choose encrypt with password from the dropdown menu. If prompted, enter the password to unprotect the worksheet.
