docs / articles / Lock Excel Cells: Step-by-Step Guide

Lock Excel Cells: Step-by-Step Guide

Sara Jul 09, 2026 2026-07-09 04:40:45

Ever found yourself in a situation where you wanted to prevent changes to specific cells in your Excel worksheet? Perhaps you want to protect important data or formulas from accidental modifications. Excel provides a simple yet powerful feature to lock cells, ensuring they remain untouched. Let's delve into how you can lock Excel cells to maintain data integrity.

How to Lock Cells in Excel: A Step-by-Step Guide | MyExcelOnline
How to Lock Cells in Excel: A Step-by-Step Guide | MyExcelOnline

Before we dive into the steps, it's crucial to understand that locking cells in Excel doesn't make them invisible or hide their contents. Instead, it restricts users from editing the cell's value or formatting. Now, let's explore the process of locking cells in Excel.

How to Lock a Cell in Excel
How to Lock a Cell in Excel

Locking Individual Cells

If you need to lock only a few cells in your worksheet, follow these steps:

How to lock and protect formulas in Excel?
How to lock and protect formulas in Excel?

1. Select the cell(s) you want to lock. You can select multiple non-adjacent cells by holding down the Ctrl key while clicking.

Using the Format Cells Dialog Box

How to lock some cell with password in excel | Excel Tips and Tricks #05
How to lock some cell with password in excel | Excel Tips and Tricks #05

1. Right-click on the selected cell(s) and choose Format Cells from the context menu.

2. In the Number tab, click on the Protection section, then check the Locked box.

3. Click OK to apply the changes. The selected cells are now locked, and their contents cannot be edited.

How to lock, hide cells and protect worksheet in Excel
How to lock, hide cells and protect worksheet in Excel

Using the Home Tab

1. Select the cell(s) you want to lock.

2. Go to the Home tab in the ribbon.

🔐 How to Lock Cells in Excel
🔐 How to Lock Cells in Excel

3. In the Styles group, click on Format as Table.

4. In the Create Table dialog box, ensure the data range is correct, then check the My table has headers box if your table has headers.

How to LOCK (Protect) Cells in Excel - An Easy Step-by-Step Guide
How to LOCK (Protect) Cells in Excel - An Easy Step-by-Step Guide
the text lock cells and protect sheets in excel
the text lock cells and protect sheets in excel
How to LOCK (Protect) Cells in Excel - An Easy Step-by-Step Guide
How to LOCK (Protect) Cells in Excel - An Easy Step-by-Step Guide
How to Set Character Limit in Excel Cells (+ video tutorial)
How to Set Character Limit in Excel Cells (+ video tutorial)
How to Fix Arrow Keys Scrolling in Excel
How to Fix Arrow Keys Scrolling in Excel
How to Lock Formula Cells & Hide Formulas in Excel
How to Lock Formula Cells & Hide Formulas in Excel
Unleashing Potential Locked cells in Excel | Vocab Computer Education
Unleashing Potential Locked cells in Excel | Vocab Computer Education
How to lock or protect certain cells in Excel
How to lock or protect certain cells in Excel
Lock Cells that have Formulas in Excel (Easy Steps)
Lock Cells that have Formulas in Excel (Easy Steps)
Excel Count Cells with Text - Text and Values, Count any Text, Occurrence of specific Text
Excel Count Cells with Text - Text and Values, Count any Text, Occurrence of specific Text
Lock Cells & Protect Excel Worksheet - EVEN by Cell Color!
Lock Cells & Protect Excel Worksheet - EVEN by Cell Color!
How to Copy Formulas Without Changing Cell References in Excel
How to Copy Formulas Without Changing Cell References in Excel
an image with the text excel lock specific cells protect cells from editing
an image with the text excel lock specific cells protect cells from editing
Delete Blank Cells
Delete Blank Cells
LOCK CELLS TO AVOID EDITING, HIDE FORMULAS
LOCK CELLS TO AVOID EDITING, HIDE FORMULAS
Excel Keyboard Shortcuts Every Office User Should Know
Excel Keyboard Shortcuts Every Office User Should Know
Lock Image with a Cell in Excel
Lock Image with a Cell in Excel
How to Lock Cells in Microsoft Excel - Make Tech Easier
How to Lock Cells in Microsoft Excel - Make Tech Easier
Copy Only Visible Cells in Excel
Copy Only Visible Cells in Excel
How to Lock Cells in Excel
How to Lock Cells in Excel

5. Click OK. The Format as Table pane appears on the right side of the screen.

6. Under Table Styles Options, click on the Table Style Options arrow, then check the Total Row box. This will lock the header row.

7. Click OK to apply the changes. The header row is now locked, and its contents cannot be edited.

Locking an Entire Worksheet

If you want to lock an entire worksheet to prevent any changes, follow these steps:

1. Right-click on the worksheet tab at the bottom of the screen and choose Protect Sheet from the context menu.

Setting a Password (Optional)

1. In the Protect Sheet dialog box, you can choose to set a password to unlock the sheet. If you do, enter the password in the Password field and confirm it in the Re-enter password field.

2. Check the Structured references box if you want to allow users to use structured references (like Excel table names) to refer to cells on the protected sheet.

3. Click OK. The worksheet is now protected, and users cannot make any changes without the password (if set).

Remember, locking cells or a worksheet in Excel doesn't hide the contents. To hide data, you can use the Hide feature or apply filters to show only relevant data. Locking cells is an essential aspect of maintaining data integrity and preventing accidental modifications in Excel.

Now that you know how to lock Excel cells, you can confidently protect your important data and formulas from unwanted changes. Happy Exceling!