Course Module 2 Part 3 Lock Cells, Lock Worksheet, Lock Specific Area
Lock A Worksheet In Excel. If prompted, enter the password to unprotect the worksheet. In the ribbon, go to review > protect workbook.
Course Module 2 Part 3 Lock Cells, Lock Worksheet, Lock Specific Area
Web to set it up, open your excel file and head to the file menu. Web select file > info. Lock cells to protect them. Protect controls and linked cells on a worksheet. Select the protect workbook box and choose encrypt with password. Click the protect workbook button and then choose encrypt with password from the dropdown menu. Enter a password in the password box, and then select ok. Web on the review tab, select unprotect sheet (in the protect group). Web to completely lock a sheet for viewing, follow these steps: Lock or unlock specific areas of a protected worksheet.
You'll see the info category by default. Confirm the password in the reenter password box,. If prompted, enter the password to unprotect the worksheet. In the ribbon, go to review > protect workbook. Protect controls and linked cells on a worksheet. Web to completely lock a sheet for viewing, follow these steps: Web protect an excel file. Enter a password in the password box, and then select ok. Web select file > info. 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.
