docs / articles / Master Excel: Dollar Sign Shortcut for Locked Cells

Master Excel: Dollar Sign Shortcut for Locked Cells

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

In the realm of Microsoft Excel, keyboard shortcuts are a lifesaver, enabling users to navigate and manipulate data with remarkable speed and efficiency. One such shortcut that's particularly useful yet often overlooked is the one involving the dollar sign ($) for creating absolute cell references, also known as the 'lock formula' in Excel.

Computer tricks😉
Computer tricks😉

Absolute cell references are crucial in Excel as they allow you to lock a cell reference, ensuring that when a formula is copied or filled, the reference to that specific cell remains constant. This is particularly handy when you want to apply a formula across a range of cells but only want to change a specific part of the formula.

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

Understanding Absolute Cell References

Before delving into the shortcut, it's essential to grasp the concept of absolute cell references. In an Excel formula, an absolute cell reference is denoted by placing a dollar sign ($) before the row and/or column reference. For instance, $A$1 refers to the cell at the intersection of column A and row 1, regardless of where the formula is placed.

short computer keys
short computer keys

When you want to lock only the row or the column, you can do so by placing a dollar sign before the respective reference. For example, A$1 locks the row 1, while $A1 locks the column A.

Creating Absolute Cell References Manually

an excel shortcut keys diagram with text and numbers on the bottom right corner,
an excel shortcut keys diagram with text and numbers on the bottom right corner,

To create an absolute cell reference manually, you simply need to type the dollar sign before the row and/or column reference in the formula bar. For instance, if you want to refer to cell A1, you would type =A$1.

However, this method can be time-consuming and prone to errors, especially when dealing with complex formulas involving multiple cell references. This is where the shortcut comes into play.

The Dollar Sign Shortcut

Top 21 Excel Formulas
Top 21 Excel Formulas

The dollar sign shortcut in Excel allows you to toggle between absolute and relative cell references with just a keystroke. Here's how it works:

1. Place your cursor in the cell reference within the formula bar. For example, if you're typing the formula =A1*B1, place your cursor in the 'A1' part.

2. Press the F4 key. This will toggle the cell reference between absolute, relative, absolute with a mixed reference, and relative with a mixed reference.

the excel all shortcut keys are shown
the excel all shortcut keys are shown

For instance, pressing F4 once will change A1 to $A$1 (absolute reference), pressing it again will change it to A$1 (absolute row reference), and so on.

Applying the Shortcut in Formulas

the excel shortcut keys are shown in black and white, as well as an image of
the excel shortcut keys are shown in black and white, as well as an image of
ms excel shortcut keys part 2 - screenshote for windows and macs
ms excel shortcut keys part 2 - screenshote for windows and macs
the top 70 excel shortcuts for finance, including an image of a green background and
the top 70 excel shortcuts for finance, including an image of a green background and
the top 50 excel shortcut keys for each player in the game, including an additional number
the top 50 excel shortcut keys for each player in the game, including an additional number
Excel Keyboard Shortcuts Every Office User Should Know
Excel Keyboard Shortcuts Every Office User Should Know
a poster with the words 70 important computer and excel shortcut keys
a poster with the words 70 important computer and excel shortcut keys
the excel shortcut keys are shown in green
the excel shortcut keys are shown in green
excel short cut key 🗝️
excel short cut key 🗝️
the excel shortcuts wheel is shown with words in different colors and numbers on it
the excel shortcuts wheel is shown with words in different colors and numbers on it
the excel keyboard shortcuts menu is shown in this screenshote screen shot
the excel keyboard shortcuts menu is shown in this screenshote screen shot
the excel shortcut keys are displayed in this screenshote screengrafion
the excel shortcut keys are displayed in this screenshote screengrafion
a poster with instructions for how to use excel shortcut keys in microsoft office 2010
a poster with instructions for how to use excel shortcut keys in microsoft office 2010
ms excel formula
ms excel formula
Excel F1 To F12 Use
Excel F1 To F12 Use
the excel shortcut keysheet sheet
the excel shortcut keysheet sheet
an image of a list of excel shortcuts on a black background with green lettering
an image of a list of excel shortcuts on a black background with green lettering
the microsoft excel shortcut key tricks manual is shown in this image, with instructions to use
the microsoft excel shortcut key tricks manual is shown in this image, with instructions to use
the poster shows how to use excel shortcut keys
the poster shows how to use excel shortcut keys
excel shortcut keys
excel shortcut keys
an excel shortcut key is shown in this screenshoto screen shot from the computer
an excel shortcut key is shown in this screenshoto screen shot from the computer

The dollar sign shortcut is particularly useful when you're copying a formula down a column or across a row. For example, let's say you have the following formula in cell A1: =A1*B1. If you want to copy this formula down to cell A2, you would typically have to change the formula to =A2*B2.

However, if you use the dollar sign shortcut, you can lock the reference to cell B1 by changing the formula to =A1*$B$1. When you copy this formula down, the reference to cell B1 will remain constant, while the reference to cell A1 will change to A2, A3, and so on.

Using the Shortcut with Mixed References

You can also use the dollar sign shortcut with mixed references. For instance, if you have the formula =A1*B$1 in cell A1, pressing F4 will toggle the reference to B$1 between absolute and relative row references.

This can be particularly useful when you want to apply a formula across a range of cells but only want to change a specific part of the formula. For example, if you have a formula in cell A1 that multiplies the value in cell A1 by the value in cell B1, you can use the shortcut to lock the reference to cell B1 while copying the formula down the column.

Tips for Using the Dollar Sign Shortcut

Here are a few tips to help you make the most of the dollar sign shortcut:

  • Use the shortcut judiciously. While it can save time, using absolute cell references excessively can make your formulas more difficult to understand and maintain.
  • Be mindful of the scope of your absolute cell references. If you copy a formula with an absolute cell reference to a different sheet or workbook, the reference will change.
  • Use the shortcut in conjunction with other Excel features, such as the fill handle, to apply formulas quickly and efficiently.

Incorporating the dollar sign shortcut into your Excel workflow can significantly enhance your productivity and efficiency. By mastering this simple yet powerful tool, you'll be able to navigate and manipulate data with ease, making your work in Excel smoother and more enjoyable.