docs / articles / Excel Shortcut: Lock Cells in Formula

Excel Shortcut: Lock Cells in Formula

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

Ever found yourself wishing you could lock a cell's value in an Excel formula, preventing it from changing even as other cells in the formula update? You're in luck! Excel provides a simple shortcut to achieve this, and it's surprisingly easy to use. Let's dive into the world of absolute cell references and discover how to lock a cell in an Excel formula.

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

Before we get started, let's ensure we're on the same page. When we talk about 'locking' a cell in a formula, we're referring to converting a relative cell reference into an absolute one. This means that the cell's address won't change, even if the formula is copied or filled into other cells. Now, let's explore how to do this.

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

Understanding Relative and Absolute Cell References

To grasp the concept of locking a cell, it's crucial to understand the difference between relative and absolute cell references. Relative references change when a formula is copied or filled, while absolute references remain constant.

Excel Shortcut Keys #viral #trick #computer #exceltricks #ExcelTips
Excel Shortcut Keys #viral #trick #computer #exceltricks #ExcelTips

Relative references are denoted by a single letter or a combination of letters (e.g., A1, B2, C3). When you copy a formula containing a relative reference, the reference moves with the formula. For instance, if you have a formula in cell B1 that references cell A1, copying this formula to cell C1 will result in the formula now referencing cell B1 instead of A1.

Converting Relative References to Absolute

How to Fix Arrow Keys Scrolling in Excel
How to Fix Arrow Keys Scrolling in Excel

To lock a cell's reference, you need to convert the relative reference into an absolute one. Absolute references are denoted by adding a dollar sign ($) before the row and/or column reference (e.g., $A$1, $B$2, $C$3). When you copy a formula containing an absolute reference, the reference remains constant.

For example, if you have a formula in cell B1 that references cell A1 with an absolute reference ($A$1), copying this formula to cell C1 will still result in the formula referencing cell A1, not B1.

Partial Absolute References

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

You can also create a partial absolute reference by adding a dollar sign only before the row or column reference (e.g., $A1, A$1). This locks either the row or the column, but not both. When you copy a formula containing a partial absolute reference, only the locked part remains constant.

For instance, if you have a formula in cell B1 that references cell A1 with a partial absolute reference (A$1), copying this formula to cell C1 will result in the formula now referencing cell A2, not B2. The column reference (A) remains locked, while the row reference (1) changes.

Using Shortcut Keys to Lock Cells in Excel

Computer tricks😉
Computer tricks😉

Now that we understand the concept of absolute and partial absolute references let's explore how to use shortcut keys to lock cells in Excel formulas.

Excel provides a simple shortcut to convert relative references into absolute or partial absolute references. Here's how to do it:

How to Lock Cells in Excel: A Step-by-Step Guide | MyExcelOnline
How to Lock Cells in Excel: A Step-by-Step Guide | MyExcelOnline
Microsoft Excel Shortcut key
Microsoft Excel Shortcut key
How to lock and protect formulas in Excel?
How to lock and protect formulas in Excel?
Most Useful Excel Shortcut Keys Every Student & Office Professional Should Know
Most Useful Excel Shortcut Keys Every Student & Office Professional Should Know
How to lock, hide cells and protect worksheet in Excel
How to lock, hide cells and protect worksheet in Excel
short computer keys
short computer keys
Excel important Shortcut Key's
Excel important Shortcut Key's
173K views | Reel by Harkesh Kumar
173K views | Reel by Harkesh Kumar
the excel shortcut keys chart sheet is shown in green and has instructions for how to use
the excel shortcut keys chart sheet is shown in green and has instructions for how to use
20 Excel Shortcut Keys Every Student & Professional Must Know | Excel Tips & Tricks
20 Excel Shortcut Keys Every Student & Professional Must Know | Excel Tips & Tricks
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
excel useful shortcuts
excel useful shortcuts
🔐 How to Lock Cells in Excel
🔐 How to Lock Cells in Excel
Excel shortcut ...✅
Excel shortcut ...✅
the excel shortcuts list is shown with green and black numbers on it, which are
the excel shortcuts list is shown with green and black numbers on it, which are
Excel Home Tab Shortcuts for Beginners & Professionals
Excel Home Tab Shortcuts for Beginners & Professionals
244 reactions · 81 shares | ✅️✰ Excel 50 Shortcuts....💯  #Excel #exceltricks #ExcelTraining exceltips msexcel msexceltraining msexcelformulas msexcelshortcutkeys viralchallenge viralphotochallenge viralpost reels fblifestyle microsoftexcel windows worksheets excelformulas Harkesh harkeshkumar excelunlocked Microsoft Excel Boss Excel  Excel Unlocked  Excel By Vikal @facebook @instagram | Harkesh Kumar | Facebook
244 reactions · 81 shares | ✅️✰ Excel 50 Shortcuts....💯 #Excel #exceltricks #ExcelTraining exceltips msexcel msexceltraining msexcelformulas msexcelshortcutkeys viralchallenge viralphotochallenge viralpost reels fblifestyle microsoftexcel windows worksheets excelformulas Harkesh harkeshkumar excelunlocked Microsoft Excel Boss Excel Excel Unlocked Excel By Vikal @facebook @instagram | Harkesh Kumar | Facebook
⌨️ Still using Excel without keyboard shortcuts? You're wasting hours every week!
⌨️ Still using Excel without keyboard shortcuts? You're wasting hours every week!
ms excel formula
ms excel formula
Excel shortcut keys
Excel shortcut keys

Converting to Absolute Reference

1. Select the cell containing the formula with the relative reference you want to lock. 2. Press the F2 key to enter Edit mode. 3. Move the cursor to the cell reference you want to lock. 4. Press the F4 key. This will add a dollar sign before both the row and column references, converting the relative reference into an absolute one. 5. Press Enter to exit Edit mode.

For example, if you have the formula "=A1*B1" in cell C1, pressing F4 after selecting A1 will convert the formula to "=A$1*B$1".

Converting to Partial Absolute Reference

1. Follow steps 1-3 from the previous section. 2. Press the F4 key repeatedly. Each press will cycle through the available reference types: * First press: Converts to an absolute reference ($A$1). * Second press: Converts to a partial absolute reference with the column locked (A$1). * Third press: Converts to a partial absolute reference with the row locked ($A1). * Fourth press: Returns to a relative reference (A1). 3. Press Enter to exit Edit mode once you've reached the desired reference type.

For instance, if you have the formula "=A1*B1" in cell C1, pressing F4 twice after selecting A1 will convert the formula to "=A$1*B1".

Using the Keyboard to Navigate Cell References

Excel also provides keyboard shortcuts to navigate through cell references in a formula. This can be helpful when you want to lock multiple cell references in a single formula.

1. Press the F2 key to enter Edit mode. 2. Use the arrow keys to navigate to the desired cell reference. 3. Press the Tab key to move to the next cell reference. 4. Once you've selected the cell reference you want to lock, press the F4 key to convert it to an absolute or partial absolute reference. 5. Repeat steps 2-4 to lock additional cell references. 6. Press Enter to exit Edit mode.

Mastering the art of locking cells in Excel formulas can significantly enhance your productivity and accuracy. By understanding and utilizing absolute and partial absolute references, you can create more dynamic and reliable formulas. So go ahead, give it a try, and watch your Excel skills soar!