docs / articles / Lock Cells in Excel: Quick Formula Keyboard Shortcut

Lock Cells in Excel: Quick Formula Keyboard Shortcut

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

Ever found yourself accidentally editing a cell in Excel that contains a crucial formula? It's a frustrating experience, but there's a simple solution: locking cells in Excel. By doing so, you prevent unintentional changes, ensuring your formulas remain intact. Here's how to do it using keyboard shortcuts for a quick and efficient process.

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

Before we dive into the keyboard shortcuts, let's understand why locking cells is important. When you lock a cell, you're protecting its contents from being altered. This is particularly useful when you want to prevent users from changing formulas or important data. Now, let's explore how to lock cells in Excel using keyboard shortcuts.

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

Understanding Cell Locking in Excel

In Excel, cell locking is part of the Protection feature. When you protect a sheet, only unlocked cells can be edited. So, locking cells is the first step in protecting your sheet. Let's explore the keyboard shortcuts to lock cells.

Excel Keyboard Shortcuts Every Office User Should Know
Excel Keyboard Shortcuts Every Office User Should Know

Before we proceed, ensure that your Excel version supports keyboard shortcuts for locking cells. The method described here works in Excel 2013 and later versions, including Excel for Microsoft 365.

Selecting Cells to Lock

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

Before you can lock cells, you need to select them. You can select a single cell, a range of cells, or an entire row or column. Here are some keyboard shortcuts to help you select cells:

  • To select a single cell: Click on the cell.
  • To select a range of cells: Click and drag the mouse over the cells, or use the arrow keys to highlight the range.
  • To select an entire row: Click the row number at the left of the sheet.
  • To select an entire column: Click the column letter at the top of the sheet.

Locking Selected Cells

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

Once you've selected the cells you want to lock, you can use the following keyboard shortcut to lock them:

  • Windows: Press Ctrl + 1 to open the Format Cells dialog box, then click the Protection tab, check the Locked box, and click OK.
  • Mac: Press Cmd + 1 to open the Format Cells dialog box, then click the Protection tab, check the Locked box, and click OK.

Alternatively, you can use the mouse to lock cells:

How to Move Selected Cells in Excel with Keyboard (4 Methods)
How to Move Selected Cells in Excel with Keyboard (4 Methods)
  1. Select the cells you want to lock.
  2. Right-click (or Control-click on a Mac) and select Format Cells.
  3. In the Format Cells dialog box, click the Protection tab.
  4. Check the Locked box.
  5. Click OK.

Protecting the Worksheet

How to Fix Arrow Keys Scrolling in Excel
How to Fix Arrow Keys Scrolling 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 Lock Cells in Excel
🔐 How to Lock Cells in Excel
Management training, Soft skills, Power BI, Excel Learning solutions
Management training, Soft skills, Power BI, Excel Learning solutions
How to lock and protect formulas in Excel?
How to lock and protect formulas in Excel?
How to Copy a Cell in Excel Using Formula(7 Tricks)
How to Copy a Cell in Excel Using Formula(7 Tricks)
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Lock Cells that have Formulas in Excel (Easy Steps)
Lock Cells that have Formulas in Excel (Easy Steps)
Delete Blank Cells
Delete Blank Cells
173K views | Reel by Harkesh Kumar
173K views | Reel by Harkesh Kumar
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
⌨️ Still using Excel without keyboard shortcuts? You're wasting hours every week!
⌨️ Still using Excel without keyboard shortcuts? You're wasting hours every week!
How to Apply Cell Styles in Excel Step by Step
How to Apply Cell Styles in Excel Step by Step
Excel shortcuts and tips
Excel shortcuts and tips
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 Split Cells in Excel (6 Easy Tricks) - ExcelDemy
How to Split Cells in Excel (6 Easy Tricks) - ExcelDemy
Excel Shortcuts Every Professional Should Know
Excel Shortcuts Every Professional Should Know
11 basic Excel tricks that will change your life
11 basic Excel tricks that will change your life
How to lock or protect certain cells in Excel
How to lock or protect certain cells in Excel
Copy Only Visible Cells in Excel
Copy Only Visible Cells in Excel

Locking cells is only the first step. To prevent users from editing unlocked cells, you need to protect the worksheet. Here's how to do it using keyboard shortcuts:

Before you proceed, ensure that you've locked all the cells you want to protect. Once you've protected a worksheet, you can't select locked cells to unlock them.

Protecting the Worksheet

To protect the worksheet, you need to set a password. This password is required to unprotect the sheet and edit any cells. Here's how to protect a worksheet using keyboard shortcuts:

  • Windows: Press Alt + A + P to open the Protect Sheet dialog box. Enter a password in the Password field, confirm it, and click OK.
  • Mac: Press Cmd + Shift + P to open the Protect Sheet dialog box. Enter a password in the Password field, confirm it, and click OK.

Once you've protected the worksheet, only users who know the password can unprotect it and edit the unlocked cells.

In your Excel journey, locking cells and protecting worksheets are essential skills to master. They help maintain the integrity of your data and formulas, preventing accidental changes. So, the next time you want to lock cells in Excel, remember these keyboard shortcuts for a quick and efficient process.