How To Lock Excel Worksheet. Create a strong password to protect your excel workbook. Web to set it up, open your excel file and head to the file menu.
lock worksheet in excel
Enter a password twice and click ok. If prompted, enter the password to unprotect the worksheet. Web on the review tab, select unprotect sheet (in the protect group). Create a strong password to protect your 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. Unlock any cells that needs to be. Web to set it up, open your excel file and head to the file menu. You'll see the info category by default. Web select file > info. Web things you should know click file → info → protect workbook → encrypt with password.
Web things you should know click file → info → protect workbook → encrypt with password. Create a strong password to protect your excel workbook. You'll see the info category by default. Enter a password twice and click ok. If prompted, enter the password to unprotect the worksheet. Web on the review tab, select unprotect sheet (in the protect group). Web to set it up, open your excel file and head to the file menu. Web things you should know click file → info → protect workbook → encrypt with password. Click the protect workbook button and then choose encrypt with password from the dropdown menu. Web select file > info. The first step is to unlock cells that others can edit, and then you can protect the worksheet with or without a password.
