How to Put an Absolute Cell Reference in Excel Formulas

To make a cell reference absolute in Excel, add a dollar sign before both its column letter and row number, such as $A$1. While editing a formula, you can also select the reference and press F4 on Windows to cycle through absolute and mixed-reference formats. An absolute reference stays fixed when you copy or fill the formula into other cells.

What You’ll Need

A workbook in Microsoft Excel for Microsoft 365 on Windows, with a formula you want to copy or a cell address you want to keep fixed.
A basic understanding of the cell address you need to lock. For example, A1 means column A, row 1.
A keyboard with an F4 key, or the ability to type dollar signs into a formula. On some laptops, you may need to hold Fn while pressing F4.

You do not need to change an Excel setting or turn on a special mode. Absolute references are part of a formula’s cell address, and you can use them in ordinary worksheets.

Step-by-Step

Identify the cell that should stay fixed. Absolute references are useful when a formula repeatedly needs the same input, such as a tax rate, discount percentage, exchange rate, or fixed target. Suppose a worksheet has item prices in column B and a tax rate in F1. When calculating tax for multiple rows, the price reference should change by row, but the tax-rate reference should remain F1.
Start or edit the formula in the cell where the result belongs. Select that cell and type an equals sign to begin a formula, or select a cell that already contains a formula and edit it. For the example, assume the price is in B2, the tax rate is in F1, and you want the tax amount in C2. With those cell locations, the formula is =B2*$F$1. If B2 contains 80 and F1 contains 8%, the result in C2 is 6.4.
Turn the reference into an absolute reference. In the formula, place a dollar sign immediately before the column letter and another immediately before the row number. The tax-rate reference F1 therefore becomes $F$1. The first dollar sign locks the column; the second locks the row. You can type both signs yourself, or use the shortcut in the next step.
Use F4 to add the dollar signs quickly. While editing the formula, click or move the insertion point into the cell reference you want to change. In this example, put the cursor in F1, then press F4. Excel changes that reference to $F$1. If the laptop uses its function keys for brightness or volume, try Fn+F4. You must be editing the formula and have the cursor within the reference; pressing F4 while merely selecting a worksheet cell may not change the reference.
Check that the whole formula is correct, then press Enter. Make sure the dollar signs are attached to the intended reference and that the formula still begins with an equals sign. For the example, it should read =B2*$F$1, not =$B$2*F1 if you want the price to adjust as you copy the formula and the tax rate to stay fixed. Press Enter to calculate the result.
Copy or fill the formula to the other rows. Select C2 and drag its fill handle—the small square at the lower-right corner of the selection—down the column. You can also copy the cell and paste it into the destination cells. In the next row, Excel adjusts the relative price reference to B3, while $F$1 remains unchanged. This is the main benefit of the absolute reference: every row uses the same tax-rate cell without you having to rewrite the formula.
Inspect a copied formula to confirm the reference behavior. Select a filled cell such as C3 and look at the formula bar. The price reference should have moved to B3, and the tax-rate reference should still be $F$1. If either part behaves differently, edit the original formula and fill the range again.

F4 cycles through four reference styles when the cursor is on a cell reference: $A$1 locks both the column and row; A$1 locks only the row; $A1 locks only the column; and A1 is relative, so both can change when copied. Press F4 repeatedly to move through the styles. Stop when the dollar signs are in the right places.

On Excel for Mac, select the reference while editing and use Command+T to cycle reference styles in current versions. Depending on your keyboard and Excel setup, F4 or Fn+F4 may also work. In Excel for the web, try F4 while editing; if the browser or keyboard intercepts the shortcut, type the dollar signs directly. The dollar-sign method works regardless of shortcut differences.

Common Mistakes

Locking the wrong reference. A formula may contain several cell addresses. F4 changes the reference where the cursor is positioned, not every reference in the formula. Check the formula bar and apply the shortcut separately to each address that needs to stay fixed.
Locking both parts when only one should be fixed. A mixed reference is sometimes the right choice. For example, when a formula is copied down a column but should always use row 1, A$1 keeps the row fixed while allowing the column to change. Use $A1 when the column should stay fixed but the row should change.
Leaving out one dollar sign. $F1 locks column F but allows the row to change; F$1 locks row 1 but allows the column to change. If both the column and row must remain fixed, use $F$1.
Assuming the dollar sign changes the cell’s value. It does not. It only controls how the reference adjusts when a formula is copied or filled. The referenced cell’s contents and the calculation itself are unaffected.
Using an absolute reference when you need a moving range. Locking every address in a formula can make copied formulas repeat the same calculation instead of adapting to each row. Decide which inputs should move before adding dollar signs.

Tips

Choose the reference style based on how the formula will be copied. If copying down should change the row but not the column, lock only the column. If copying across should change the column but not the row, lock only the row. If neither part should change, lock both.
Use a clear input cell for shared values. Keep a rate or constant in a labeled cell, such as Tax rate in E1 and its value in F1, rather than typing the same number into many formulas. That way, changing the value in F1 updates all calculations that refer to it.
Check references before filling a large range. Fill a few rows first, then inspect one of the copied formulas. This catches an incorrectly locked row or column before it affects a long worksheet.
Remember that absolute references work in either direction. The same rules apply when copying a formula down, up, left, or right. A locked row stays fixed in every direction, and a locked column stays fixed in every direction.
Consider Excel table references for table formulas. Formulas in Excel tables can use column names, such as a Sales column, rather than ordinary A1-style addresses. Those structured references often adjust automatically as table rows are added. For a standard cell address that must stay fixed, use dollar signs.

Troubleshooting

F4 inserts a character or changes a computer setting. Make sure you are actively editing a formula and that the cursor is inside the reference. On a laptop, try Fn+F4. If the shortcut still does not work, type the dollar signs directly around the column and row portions of the address.
The formula changes the wrong cell after you copy it. Compare the original and copied formulas in the formula bar. If the supposed fixed address changed, add dollar signs to the missing part of the reference in the original formula, press Enter, and fill the destination cells again.
The result repeats instead of changing by row. Check whether the changing input was accidentally made absolute. If the price cell should move from B2 to B3 as the formula is copied down, use a relative reference such as B2, not $B$2.
Excel shows the formula text instead of a result. Check whether the cell is formatted as Text. Change its number format to General, edit the cell, and press Enter. Also check that the formula begins with an equals sign and that Show Formulas is not turned on. On Windows, Ctrl+` toggles the display of formulas and results.
The formula returns an error or an unexpected number. Confirm that the fixed address points to the intended cell, that the cell contains a usable value, and that the formula uses the correct arithmetic operator. Absolute references do not prevent errors caused by blank, text, or incorrect input values.

Frequently Asked Questions

What does an absolute reference mean in Excel?

It is a cell address with a dollar sign before both the column and row, such as $A$1. When you copy a formula, Excel keeps that reference pointing to the same cell.

How do I make a reference absolute without using F4?

Edit the formula and type a dollar sign before the column letter and the row number. For example, change F1 to $F$1. This works on Windows, Mac, and Excel for the web.

What is the difference between $A$1 and A$1?

$A$1 fixes both the column and row. A$1 fixes only row 1, so the column can adjust when the formula is copied horizontally.

Can I use an absolute reference in any formula?

Yes. You can use one anywhere an ordinary cell reference is accepted, including in arithmetic formulas and many functions. The dollar signs affect how the reference moves when copied, not how the function calculates.

Why does Excel change my reference when I copy the formula?

References without dollar signs are relative by default, so Excel adjusts them based on where the formula is pasted. Add dollar signs to the row, column, or both to keep the relevant part fixed.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.