How to Lock Cells in Microsoft Excel

When sharing a complex Microsoft Excel spreadsheet with colleagues or clients, the last thing you want is for someone to accidentally overwrite a crucial formula, delete a formatting rule, or change a fixed financial rate. Excel allows you to protect your hard work by locking specific cells, making them strictly read-only while leaving the rest of the sheet open for data entry.

The cell locking process in Excel can be slightly counterintuitive at first because, by default, every single cell in a new workbook is pre-formatted as “Locked.” However, this lock does nothing until you enable the master “Protect Sheet” switch.

Step 1: Unlock the Entire Spreadsheet

Because every cell is locked by default, turning on sheet protection immediately would freeze the entire document. To lock only specific formulas, you must first unlock the whole sheet.

1. Open your Excel document.
2. Select every cell in the spreadsheet by clicking the small triangle icon in the top-left corner of the grid (where row 1 and column A intersect), or simply press Ctrl + A.
3. Right-click anywhere on the highlighted spreadsheet and select Format Cells… from the context menu.
4. In the Format Cells dialogue box, click on the Protection tab at the far right.
5. Untick the checkbox next to Locked so that the box is completely empty.
6. Click OK.

Your entire spreadsheet is now completely unlocked and vulnerable to edits.

Step 2: Lock the Specific Cells You Want to Protect

Now that the canvas is open, you can selectively lock the specific data or formulas you want to safeguard.

1. Use your mouse to highlight only the specific cells, columns, or rows you want to protect from editing. (You can hold the Ctrl key to select multiple, non-adjacent cells).
2. Right-click on one of your highlighted cells and select Format Cells….
3. Go to the Protection tab again.
4. Tick the checkbox next to Locked so that a checkmark appears.
5. Click OK.

Step 3: Enable Sheet Protection

Your chosen cells are now primed for locking, but they can still be edited until you turn the master lock on.

1. Click on the Review tab in the main ribbon at the top of the Excel window.
2. In the “Protect” group, click the Protect Sheet button.
3. A dialogue box will appear. Ensure the box next to “Protect worksheet and contents of locked cells” is ticked.
4. Optional but recommended: Type a password in the text box. If you do not set a password, anyone can simply click the “Unprotect Sheet” button to bypass your locks.
5. Leave the default permission checkboxes as they are (allowing users to select locked and unlocked cells) and click OK.

If anyone attempts to type or delete data inside one of your protected cells, Excel will immediately block the action and display a warning message stating that the cell is read-only.