How to Freeze a Reference in Excel with Dollar Signs

To freeze a cell reference in an Excel formula, add dollar signs to the cell address—for example, change A1 to $A$1—or select the reference while editing the formula and press F4 on Windows. The dollar signs keep the chosen row, column, or both from changing when you copy or fill the formula. This is different from freezing panes, which keeps worksheet rows or columns visible while you scroll.

This guide covers Microsoft Excel for Microsoft 365 on Windows, with notes for Mac and Excel for the web. You do not need to change a workbook setting: you can make a reference absolute as you enter a formula, or adjust one that already exists.

What You’ll Need

An Excel workbook containing a formula, or a worksheet where you are ready to enter one.
A cell address you want the formula to keep pointing to, such as a tax rate, exchange rate, or fixed input.
For the keyboard method, a keyboard with an F4 key. On some laptops, you may need to hold Fn as well.

Step-by-Step

Identify what must stay fixed. Decide whether you need to lock both the column and row, just the column, or just the row. If a formula should always refer to cell B1, lock both parts. If it should stay in column B but move down through different rows, lock only the column. If it should stay on row 1 while moving across columns, lock only the row.
Enter or select a formula. To create a formula, click the destination cell and type an equals sign followed by the calculation. For an existing formula, click its cell and press F2 to edit it on Windows. You can also click in the formula bar. On Mac, double-click the cell or use the formula bar to edit; the F2 behavior can depend on keyboard settings.
Place the insertion point on the reference. In the formula, locate the cell address you want to freeze. Select the reference text, or place the cursor within that reference. If the formula has several references, make sure you are acting on the one you intend to lock. Do not select the entire formula unless you mean to replace it.
Cycle through reference types with F4. On Windows, press F4 while editing the reference. Each press cycles through four forms: A1, $A$1, A$1, and $A1, then back to A1. Stop when the dollar signs mark the part or parts you want to keep fixed. If you are using a laptop, try Fn+F4 if the function row controls brightness, volume, or another system feature.
Use the Mac shortcut if applicable. In Excel for Mac, select or position the cursor on the cell reference while editing, then press Command+T to cycle its reference style. Keyboard layouts and function-key settings vary, so if that shortcut does not work, type the dollar signs directly. The dollar-sign method works regardless of shortcut settings.
Enter dollar signs manually when needed. You can edit the address yourself: $A$1 locks the column and row; $A1 locks only column A; A$1 locks only row 1; and A1 has no locked part. This is also a reliable option in Excel for the web or when your keyboard intercepts F4.
Confirm the edit. Press Enter to accept the formula, or use the check mark beside the formula bar. If you were editing an existing formula, check that the calculation still has the intended references and operators. If Excel displays an error, review the formula before filling it into other cells.
Copy or fill the formula to test it. Drag the fill handle—the small square at the lower-right corner of the selected cell—or copy and paste the formula to another cell. A locked row or column should remain fixed, while any unlocked part should adjust to the new position. Check at least one copied result before filling a large range.

For example, with an 8% rate in B1, an item price of 50 in A2, and the calculation in C2, enter =A2*$B$1. The formula returns 4. If you fill it down to C3, the reference to A2 can change to A3, but $B$1 remains fixed. This is useful when one input cell is shared by many calculations.

Mixed references are useful for two-way tables. With a multiplier of 3 in A2 and a column heading of 10 in B1, the formula in B2 =$A2*B$1 returns 30. When copied across, $A keeps the multiplier column fixed while the heading column can change; when copied down, $1 keeps the heading row fixed while the multiplier row can change. This lets one formula adapt in two directions without rewriting its references.

Common Mistakes

Locking too much or too little. $A$1 freezes both dimensions. If only the column should stay the same, use $A1 instead. If only the row should stay the same, use A$1. Choosing the wrong form can make copied formulas repeat a value or move away from the intended range.
Confusing a frozen reference with frozen panes. Dollar signs affect how a formula changes when copied. The View > Freeze Panes command keeps worksheet headings visible while scrolling; it does not change formulas. Choose the feature that matches the problem you are trying to solve.
Pressing F4 when the reference is not active. F4 cycles reference types only when Excel is editing a formula and the cursor is on a cell reference. Outside formula editing, it may repeat an action or behave differently. Click the formula first and position the cursor on the address.
Assuming an absolute reference cannot ever change. The dollar signs stop relative adjustment during copying or filling. They do not protect the cell from being edited, deleted, or moved as part of other workbook changes. Keep important inputs clearly labeled and avoid deleting referenced cells.
Adding dollar signs to a sheet name or the wrong address. In a reference such as Sheet2!A1, the dollar signs belong with the column and row address, not the sheet name. If you intend the cell on that sheet to stay fixed, write Sheet2!$A$1.

Tips

Think in terms of movement. Before locking a reference, imagine copying the formula one cell right and one cell down. Decide which part of the address should move in each direction, then use dollar signs only on the parts that must not move.
Use the formula bar for long formulas. Clicking in the formula bar gives you more room to find and select a reference. This can be easier than editing directly in a narrow worksheet cell, especially when a formula contains several cell addresses.
Check the copied formula itself. Select a filled cell and inspect the formula bar. For instance, a formula copied down should normally change a relative A2 reference to A3, while a $B$1 reference should remain $B$1. This confirms the reference behavior, not just whether the displayed number looks plausible.
Use names for important inputs if helpful. Excel lets you assign a name to a cell or range, which can make formulas easier to read. A named cell reference does not use the same row-and-column dollar-sign notation, so use the name consistently and check how formulas behave when copied.
Use absolute references for shared assumptions. Rates, fixed thresholds, and conversion factors often belong in a clearly labeled input cell. Locking that address can make a calculation easier to update: change the input once, and formulas that refer to it recalculate.
Remember that Excel adjusts references by default. This is often desirable. In a row of calculations, you may want A2 to become A3 as the formula is filled down. Do not add dollar signs automatically to every reference; lock only the dimension that should remain constant.

Troubleshooting

F4 changes the computer’s brightness or volume. Your keyboard may reserve the function keys for hardware controls. Try Fn+F4, check whether your keyboard has an Fn Lock setting, or type the dollar signs into the address manually. You can also use the formula bar to edit the reference without relying on a shortcut.

F4 does not add dollar signs. Confirm that the cell is in formula-edit mode and that the insertion point is on the cell address. If you are not editing a formula, F4 will not cycle the reference. In Excel for Mac, try Command+T; in Excel for the web, shortcut behavior may depend on the browser and keyboard, so manual editing is a dependable fallback.

The formula gives the same result in every row. Check whether you accidentally made a changing reference absolute. If each row should use a different value from column A, the reference should usually be A2 rather than $A$2 or $A2. Keep the shared input fixed, but allow the row-specific input to adjust.

The formula changes to the wrong row or column after copying. Inspect the dollar signs in the original formula. A$1 keeps only row 1 fixed, while $A1 keeps only column A fixed. If both should stay fixed, change the reference to $A$1. Then copy the corrected formula again and verify a destination cell.

Excel shows a formula error after editing. Check for a missing operator, parenthesis, or reference separator, and make sure you did not delete part of the formula while selecting the address. Press Esc before confirming if you want to abandon an edit in progress, then reopen the original formula and make the change carefully. If the formula refers to a different worksheet, confirm that the sheet name and exclamation mark are still present.

You meant to keep headings visible while scrolling. That is a separate task. Use View > Freeze Panes in Excel for Windows, and select the appropriate option for the top row, first column, or panes. Freezing panes does not insert dollar signs or make a formula reference absolute.

Frequently Asked Questions

What does the dollar sign mean in an Excel reference?
A dollar sign makes the part immediately after it absolute when a formula is copied or filled. In $A$1, both the column and row stay fixed; in $A1 or A$1, only one part stays fixed.

How do I freeze only a column or only a row?
Use $A1 to keep column A fixed while the row can change. Use A$1 to keep row 1 fixed while the column can change. You can type the signs yourself or cycle through the formats with the shortcut while editing a reference.

Can I freeze a reference after I have copied a formula?
Yes. Select the formula cell, edit the reference in the formula bar or in the cell, add the needed dollar signs, and press Enter. Then copy or fill the corrected formula to the other cells again if they also need the adjustment.

Does F4 work in Excel for Mac?
Excel for Mac commonly uses Command+T to cycle reference styles while editing a formula. Function-key behavior can vary with the keyboard and system settings, so manually adding dollar signs is a straightforward alternative.

Does freezing a reference stop the referenced cell from changing?
No. It keeps the address from shifting when the formula is copied or filled. If someone changes the value in the referenced cell, formulas using that address will normally recalculate using the new value.

Is freezing a reference the same as Freeze Panes?
No. An absolute or mixed reference controls how an address behaves in formulas. Freeze Panes is a worksheet display feature that keeps selected rows or columns visible as you scroll.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.