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

Excel Guide

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

Locking columns in Excel is an effective way to safeguard data from accidental edits or deletions. Although Excel cells are initially locked by default, you can easily unlock specific cells or ranges to allow for modifications. To lock cells in Excel, follow these straightforward steps.

Step 1: Select the Cells to Lock

Begin by selecting the cells or range of cells you want to lock. Click on the desired cell, drag to select a range, or use the "Ctrl+A" keyboard shortcut to select all cells in the worksheet.

Step 2: Right-Click and Choose "Format Cells"

Right-click on any of the selected cells, and from the context menu, choose "Format Cells." Alternatively, you can press "Ctrl+1" to open the Format Cells dialog box.

Step 3: Go to the "Protection" Tab and Check "Locked"

Within the Format Cells dialog box, navigate to the "Protection" tab. Check the "Locked" box to lock all the selected cells. Click "OK" to apply the changes and close the dialog box.

Step 4: Save Your Workbook

After locking the cells, it's essential to save your workbook. Click the "Save" button on the Quick Access Toolbar or use the "Ctrl+S" keyboard shortcut. If it's the first save, you'll need to provide a name for the file.

Step 5: Protect Your Worksheet

If you want to prevent others from unlocking and editing the locked cells, you can protect your worksheet. Go to the "Review" tab, click "Protect Sheet" in the "Changes" group, enter an optional password, and click "OK."

That's it! Now you've successfully locked cells in Excel. Remember to save your workbook and protect your worksheet if you wish to restrict access to the locked cells.