How To Lock An Excel Worksheet. Enter a password in the password box, and then select ok. Select the protect workbook box and choose encrypt with password.
How to Lock Cells and Protect Worksheets in Excel
Web to set it up, open your excel file and head to the file menu. Web select file > info. Select the protect workbook box and choose encrypt with password. Unlock any cells that needs to be. Web on the review tab, select unprotect sheet (in the protect group). You'll see the info category by default. Web protect an excel file. The first step is to unlock cells that others can edit, and then you can protect the worksheet with or without a password. Confirm the password in the reenter. If prompted, enter the password to unprotect the worksheet.
Select the protect workbook box and choose encrypt with password. Web to set it up, open your excel file and head to the file menu. Web select file > info. Select the protect workbook box and choose encrypt with password. Web on the review tab, select unprotect sheet (in the protect group). Unlock any cells that needs to be. The first step is to unlock cells that others can edit, and then you can protect the worksheet with or without a password. Create a strong password to protect your excel workbook. Click the protect workbook button and then choose encrypt with password from the dropdown menu. Confirm the password in the reenter. Web protect an excel file.
