Excel Dollar Sign Shortcut: Fix Cell References in Formulas

In Excel for Microsoft 365 on Windows, press F4 while editing a formula and a cell reference is selected to add or cycle its dollar signs. The signs lock a column, a row, or both when you copy the formula; they do not change the value in the cell.

Use F4 to add dollar signs

Start typing a formula or edit one in the formula bar or a cell. Select the cell reference within the formula, such as A1, then press F4. Excel changes the reference type, adding dollar signs in front of the column letter, the row number, or both. Press F4 again to move to the next type.

You can also click or place the insertion point in the reference while editing. Selecting the reference itself is the clearest way to tell Excel which reference to change, especially in a formula containing several cell addresses. F4 acts on the reference being edited, not on every reference in the formula at once.

For example, if you are entering a formula that refers to A1, F4 first changes it to $A$1. If the key seems to do nothing, check that you are still editing the formula and that the reference is selected. Pressing F4 when you are not editing a formula has a different purpose and will not add a dollar sign to a cell address.

What F4 cycles through

Excel cycles a reference through four forms. Starting with the relative reference A1, the sequence is:

A1 — relative column and relative row.
$A$1 — fixed column A and fixed row 1.
A$1 — relative column and fixed row 1.
$A1 — fixed column A and relative row.

Pressing F4 once more returns the reference to A1. If you start with a different type, the cycle continues from that type. For instance, selecting B3 and pressing F4 changes it to $B$3; pressing F4 again changes it to B$3. This is useful when you want to choose a reference by keyboard rather than manually inserting each dollar sign.

The dollar sign is part of Excel’s reference notation. It sits immediately before the part it fixes: before the column letter to lock the column, and before the row number to lock the row. A reference such as $A1 therefore fixes column A, not row 1.

Relative, absolute, and mixed references

A relative reference adjusts when a formula is copied. If a formula in row 2 refers to A2 and you copy it down one row, Excel normally changes that reference to A3. This behavior is helpful when each row should use its own corresponding data.

An absolute reference, such as $A$1, keeps both its column and row fixed when copied. It is often used for a single input value that many formulas need to use, such as a tax rate, exchange rate, or commission percentage. The formula can move to another row or column while the reference still points to A1.

Mixed references lock only one direction. A$1 keeps row 1 fixed but lets the column change, which can help when copying a formula across columns while using a value in a header row. $A1 keeps column A fixed but lets the row change, which is useful when copying down while consistently referring to a label or input in column A.

“Absolute” does not mean that the value is frozen or protected from editing. It only controls how the address changes when the formula is copied or filled. If the content of the referenced cell changes, formulas that point to it can recalculate as usual.

Worked example: lock a rate cell

Assume B2 contains a taxable amount of 125, and F1 contains a rate of 8%. To calculate the tax in C2, use the following formula. The cell layout is B2 for the amount and F1 for the rate; enter the formula in C2:

=B2*$F$1

The result is 10, because 125 multiplied by 8% equals 10. The amount reference B2 is relative, so copying the formula down changes it to B3, B4, and so on. The rate reference $F$1 is absolute, so it remains pointed at F1 in every copied formula.

To build this formula with F4, type an equals sign, select B2, type the multiplication operator, then select F1. Press F4 until the reference reads $F$1, finish the formula, and press Enter. If the reference begins as F1, one press gives $F$1. This is a practical way to use the shortcut without having to remember where to type both dollar signs.

Choosing which part to lock

Choose the reference type according to the direction in which you will copy the formula and which parts of the address should stay put. Before filling a formula, ask whether it should keep using the same input cell, move down a list, or move across a table.

Use $A$1 when both the column and row must stay fixed, such as one shared rate cell.
Use A$1 when formulas will move across columns but should continue to use row 1.
Use $A1 when formulas will move down rows but should continue to use column A.
Use A1 when the reference should adjust in both directions as the formula is copied.

A useful check is to imagine where the formula will land after copying it. If it will move down five rows, a relative row reference moves down five rows too. If that would point to the wrong input, lock the row with a dollar sign. If you will copy sideways, consider whether the column should move. F4 makes the change, but the intended fill direction determines which reference type is right.

Copying and filling formulas

Once the reference is set, copy or fill the formula as needed. In Excel for Windows, you can copy and paste with Ctrl+C and Ctrl+V, or drag the fill handle at the lower-right corner of the selected cell. The dollar signs determine which parts of the address adjust in the copied formulas; they do not prevent the formula itself from being copied.

After filling, inspect a few results rather than assuming the references are correct. Select a destination cell and look at its formula in the formula bar. A relative reference should have moved in the expected direction, while an absolute part should still point to the intended row or column. If a calculation repeats an unexpected input or returns an error, checking the addresses is a good first step.

For a two-way table, mixed references can make a formula copy both across and down while holding one header direction fixed. These formulas take more thought to set up: decide which header should remain in a fixed row and which should remain in a fixed column. Test the formula in one adjacent cell horizontally and one vertically before filling a large range.

When F4 does not work

The most common cause is pressing F4 outside formula-editing mode. Click a formula cell and press F2, or click in the formula bar, then select the reference and press F4. You can also begin a new formula and press F4 after selecting a reference. If you have already pressed Enter, Excel is no longer editing that formula, so F4 will not cycle its reference.

On many laptops, the function-key row also controls hardware features such as volume or screen brightness. Depending on the keyboard and its settings, you may need to hold the Fn key while pressing F4. If the key changes a hardware setting instead, try Fn+F4 or check the computer’s function-key setting. The exact behavior depends on the device, not just Excel.

Make sure the reference, rather than another part of the formula, is active. If a formula contains multiple cell references, click or select the particular address you want to change. You can always type the dollar signs directly if keyboard behavior is inconvenient: change A1 to $A$1, A$1, or $A1 as required. Avoid editing the address in a way that removes a colon or other operator from a range reference.

Windows, Mac, and Excel for the web

This shortcut guidance is for Excel for Microsoft 365 on Windows. In Excel for Mac, use Command+T to cycle a selected reference through relative, absolute, and mixed forms while editing a formula. Mac keyboards and Excel versions can have different function-key behavior, so Command+T is the more direct alternative when F4 is being used for a system function.

Excel for the web runs in a browser, where keyboard shortcuts can depend on the browser and operating system. If F4 is intercepted or does not cycle the reference in your setup, edit the formula and type the dollar signs manually. The reference types themselves work the same way in workbook formulas; the difference is the keyboard interaction.

Shortcuts can also vary with keyboard layout and function-key settings. When helping someone using another computer, it is more reliable to explain the goal—lock the column, row, or both—than to assume the physical F4 key behaves identically on every keyboard.

Dollar signs are not currency formatting

A common misunderstanding is that typing a dollar sign into a formula reference formats a result as money. It does not. In $A$1, the signs control how the address behaves when copied. Currency formatting changes how a numeric value is displayed, such as showing a currency symbol and decimal places; it does not make a reference absolute.

Excel for Windows has a separate currency-format shortcut: Ctrl+Shift+$ applies the Currency format to selected cells. That shortcut is not the same as F4 and does not add dollar signs to a cell reference. Use F4 inside a formula when you want to lock a reference. Use a number format when you want a value to appear as currency. The underlying number can remain the same either way.

Frequently Asked Questions

What is the Excel shortcut for adding a dollar sign to a cell reference?

In Excel for Windows, edit a formula, select the reference, and press F4. Excel cycles the reference type, beginning with $A$1 when the selected reference is A1. On Mac, use Command+T.

Does F4 add dollar signs to every reference in a formula?

No. F4 changes the reference currently selected or active during formula editing. Select each address you want to change separately. Other references in the formula are left as they are.

How do I lock only a column or only a row?

Use a dollar sign before just the part you want to keep fixed. $A1 locks column A while the row can change; A$1 locks row 1 while the column can change. F4 cycles through these mixed forms as well as fully relative and fully absolute references.

Why does F4 change my laptop’s brightness instead?

Some laptops assign hardware controls to the function-key row. Try Fn+F4, or adjust the computer’s function-key setting. If that is not convenient, type the dollar sign directly into the formula reference.

Does a dollar sign in a reference format the result as currency?

No. In a reference such as $A$1, the dollar signs lock the row and column when copying a formula. To display a number as currency, apply a currency number format; formatting and reference locking are separate features.

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

More in Errors & fixes

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

Spotted an error in this guide? Let us know.