As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Lock Cells in Excel: Step-by-Step Guide

Locking cells in Excel is a crucial step to safeguard your data and prevent unwanted changes. Here's a step-by-step guide on how to lock cells in Excel.

Step 1: Select the Cells You Want to Lock

  • Click on the cell or range of cells you want to lock. For example, select cells A1:A5.

Step 2: Click the Format Tab

  • Navigate to the Format tab at the top of the Excel window. This action will open the Format Cells dialog box.

Step 3: Select "Protection" in the Format Cells Dialog Box

  • In the Format Cells dialog box, choose "Protection" from the options on the left-hand side. This will reveal the Protection options on the right-hand side.

Step 4: Check the "Locked" Box

  • Check the "Locked" box to lock the cells you selected in Step 1.

Step 5: Click "OK"

  • Click "OK" to close the Format Cells dialog box. The selected cells are now locked.

How to Lock a Sheet in Excel: Step-by-Step Guide

Locking a sheet in Excel is an effective way to protect your workbook from unintended changes. Follow this step-by-step guide to lock a sheet:

Step 1: Click the Review Tab

  • Go to the Review tab at the top of the Excel window. This will open the Review ribbon.

Step 2: Click "Protect Sheet"

  • Click "Protect Sheet" in the Changes group. This will open the Protect Sheet dialog box.

Step 3: Enter a Password (Optional)

  • In the Protect Sheet dialog box, you can enter an optional password. This password will be required to unprotect the sheet.

Step 4: Select Protection Options

  • Choose the options you want to protect. For example, you can protect the sheet from insertions, deletions, and formatting.

Step 5: Click "OK"

  • Click "OK" to close the Protect Sheet dialog box. Your sheet is now locked.

How to Unlock a Sheet in Excel: Step-by-Step Guide

Unlocking a sheet in Excel allows other users to make changes to your workbook. Here's a step-by-step guide on how to unlock a sheet:

Step 1: Click the Review Tab

  • Navigate to the Review tab at the top of the Excel window. This will open the Review ribbon.

Step 2: Click "Unprotect Sheet"

  • Click "Unprotect Sheet" in the Changes group. This will open the Unprotect Sheet dialog box.

Step 3: Enter the Password

  • In the Unprotect Sheet dialog box, enter the password if one was set.

Step 4: Click "OK"

  • Click "OK" to close the Unprotect Sheet dialog box. Your sheet is now unlocked.