docs / articles / Excel Keyboard Shortcut: Lock Cell Reference Instantly

Excel Keyboard Shortcut: Lock Cell Reference Instantly

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

Ever found yourself wishing you could lock cell references in Excel without taking your hands off the keyboard? You're not alone. Excel's keyboard shortcuts can significantly boost your productivity, and one of the most useful ones is the ability to lock cell references. Let's dive into how you can do this efficiently.

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

Before we get started, ensure you're using Excel 2013 or later, as the keyboard shortcut we'll discuss was introduced in this version. If you're using an earlier version, you might want to consider upgrading for a smoother experience.

Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips

Understanding Absolute and Relative Cell References

Before we delve into the keyboard shortcut, let's quickly recap absolute and relative cell references. Absolute references, denoted by a dollar sign ($), lock the row and column, while relative references change as you copy or drag them.

Microsoft Excel Laminated Shortcut Card - Over 200 Keyboard Shortcuts for Windows and Mac Side-by...
Microsoft Excel Laminated Shortcut Card - Over 200 Keyboard Shortcuts for Windows and Mac Side-by...

Knowing the difference is crucial because the keyboard shortcut we're about to learn helps you switch between these reference types quickly.

Absolute Cell References

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

Absolute cell references are useful when you want to refer to the same cell regardless of where the formula is placed. For example, if you want to refer to cell A1 in every cell of a column, you would use the absolute reference $A$1.

To create an absolute reference, simply add a dollar sign before the row and column numbers. For instance, to create an absolute reference to cell B4, you would type $B$4.

Relative Cell References

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

Relative cell references, on the other hand, are useful when you want the reference to change as you copy or drag the formula. For example, if you have a formula in cell A1 that refers to cell B1, when you copy this formula to cell A2, the reference will automatically change to cell B2.

By default, Excel uses relative references. To create a relative reference, simply type the cell reference without the dollar signs. For instance, to refer to cell B4, you would type B4.

Excel Keyboard Shortcut to Lock Cell Reference

Excel shortcut ...✅
Excel shortcut ...✅

Now that we understand the difference between absolute and relative cell references, let's learn the keyboard shortcut to switch between them. The shortcut is simple: press the F4 key.

Here's how it works: when you have a cell reference selected, pressing F4 toggles between absolute and relative references. Here's a breakdown:

Microsoft Excel Shortcut key
Microsoft Excel Shortcut key
a poster with the words 70 important computer and excel shortcut keys
a poster with the words 70 important computer and excel shortcut keys
Top 21 Excel Formulas
Top 21 Excel Formulas
the excel keyboard shortcuts menu is shown in this screenshote screen shot
the excel keyboard shortcuts menu is shown in this screenshote screen shot
Most Useful Excel Shortcut Keys Every Student & Office Professional Should Know
Most Useful Excel Shortcut Keys Every Student & Office Professional Should Know
an image of a computer keyboard with the words excel ctrl shortcuts
an image of a computer keyboard with the words excel ctrl shortcuts
Computer tricks😉
Computer tricks😉
20 Excel Shortcut Keys Every Student & Professional Must Know | Excel Tips & Tricks
20 Excel Shortcut Keys Every Student & Professional Must Know | Excel Tips & Tricks
⌨️ Still using Excel without keyboard shortcuts? You're wasting hours every week!
⌨️ Still using Excel without keyboard shortcuts? You're wasting hours every week!
Excel shortcuts
Excel shortcuts
an excel shortcut key is shown in green and white
an excel shortcut key is shown in green and white
the ultimate guide to excel shortcut keys
the ultimate guide to excel shortcut keys
23 Excel important Shortcut Key's
23 Excel important Shortcut Key's
Tech Home
Tech Home
Excel Shortcut Keys Cheat Sheet
Excel Shortcut Keys Cheat Sheet
excel useful shortcuts
excel useful shortcuts
excel short cut key 🗝️
excel short cut key 🗝️
Excel shortcuts
Excel shortcuts
🔥 15+ Essential Excel Ctrl Key Shortcuts
🔥 15+ Essential Excel Ctrl Key Shortcuts
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
  • First press: Changes a relative reference to an absolute reference (e.g., B4 to $B$4).
  • Second press: Changes an absolute reference to a mixed reference (e.g., $B$4 to B$4).
  • Third press: Changes a mixed reference to a relative reference (e.g., B$4 to B4).
  • Fourth press: Changes a relative reference back to an absolute reference (e.g., B4 to $B$4).

Using the Keyboard Shortcut in Practice

Let's say you have the following formula in cell A1: =B1*2. If you want to copy this formula down to cell A10, but you want the reference to B1 to remain constant, you can use the F4 shortcut. Here's how:

1. Select the formula in cell A1.

2. Press F4 to change the relative reference B1 to the absolute reference $B$1.

3. Copy the formula down to cell A10. The reference to B1 will remain constant in each cell.

Tips for Using the Keyboard Shortcut

Here are a few tips to help you get the most out of this keyboard shortcut:

  • Practice using the shortcut in different scenarios to get a feel for how it works.
  • Remember that the shortcut only works when you have a cell reference selected.
  • If you accidentally press F4 too many times, simply press it again to cycle back to the reference type you want.

Mastering this keyboard shortcut can significantly improve your Excel productivity. It's a small change that can make a big difference in your workflow. So, the next time you find yourself reaching for your mouse to lock a cell reference, give the F4 shortcut a try. Your future self will thank you!