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