Absolute Cell Reference Excel Shortcut: F4 Explained

In Excel for Microsoft 365 on Windows, press F4 while editing a formula and the insertion point is on a cell reference to make that reference absolute. Press F4 again to cycle through mixed and relative reference styles; on a Mac, use Command+T.

Use F4 to lock a reference

Enter or edit a formula, then put the text cursor inside the cell reference you want to change. Press F4: Excel adds dollar signs to lock both the column and row. For example, a reference written as A1 becomes $A$1. Press F4 repeatedly if you need a different style. You can do this as you build a formula, before pressing Enter, or later by editing a formula that is already in a cell.

A practical sequence is:

Start a formula by typing an equals sign and a reference, such as =A1.
Before finishing the formula, make sure the insertion point is within A1.
Press F4 until the reference has the dollar signs you want.
Finish the formula and press Enter.

If the formula is already in a worksheet cell, select it and press F2 to edit it. Move the cursor onto the relevant reference, then press F4. You can also select the cell and edit the formula in the formula bar. The shortcut changes the reference under the cursor, not necessarily every reference in the formula. If a formula contains the same cell reference more than once, check each occurrence that needs locking.

What an absolute cell reference means

A cell reference has a column part and a row part. In A1, A identifies the column and 1 identifies the row. A dollar sign before a part tells Excel to keep that part fixed when the formula is copied or filled to another location. In $A$1, both parts are fixed, so the reference continues to point to A1 when the formula moves.

By contrast, A1 is a relative reference. If a formula containing A1 is copied one column to the right, Excel ordinarily changes it to B1. If copied one row down, it changes to A2. That adjustment is useful when each row should refer to its own data, but not when each calculation must use the same tax rate, exchange rate, or other fixed input.

The dollar signs affect how a reference adjusts during copying; they do not change the value in the referenced cell or prevent someone from editing that cell. They also do not make the cell physically fixed in the worksheet. They simply tell Excel how to interpret that reference in a formula as the formula is moved or copied.

The four reference styles F4 cycles through

Pressing F4 with a reference selected cycles through four forms. Starting with A1, the sequence is A1, $A$1, A$1, $A1, and back to A1. The first press after a relative reference makes both the row and column absolute.

A1: relative column and relative row. Both can adjust when copied.
$A$1: absolute column and absolute row. Neither adjusts.
A$1: relative column and absolute row. The row stays fixed, while the column can adjust.
$A1: absolute column and relative row. The column stays fixed, while the row can adjust.

These last two styles are called mixed references because only one part is locked. The order matters: the dollar sign goes immediately before the letter or number it locks. F4 changes the style in sequence, so keep pressing it until the reference displays the required dollar signs. You do not have to memorize the cycle if you can read the resulting reference before confirming the formula.

A worked example with a fixed input

Suppose A2 contains a quantity of 3 and F1 contains a unit price of 12.50. You want column B to multiply each row’s quantity by that one shared price. With those values in place, enter this formula in B2:

With quantity in A2 and the fixed unit price 12.50 in F1, enter =A2*$F$1 in B2; the result is 37.50.

The quantity reference A2 is relative because it should change for each row. The unit-price reference $F$1 is absolute because every row should use the same input. If A3 contains 5, copying the formula down to B3 gives this formula:

With A3 containing 5 and F1 still containing 12.50, the copied formula in B3 is =A3*$F$1; it returns 62.50.

Excel adjusted A2 to A3 but kept $F$1 unchanged. That is the core reason to use an absolute reference: it lets one formula combine changing row-by-row data with a shared value. This is often more convenient than typing the same constant directly into every formula, because changing the input in F1 updates all calculations that refer to it.

When to use absolute, relative, or mixed references

Choose the reference style based on what should change when you copy the formula. Use an absolute reference for a value that must remain at one worksheet address. Use a relative reference when the formula should follow its data. Use a mixed reference when the formula needs to keep either a row or a column fixed, but not both.

For example, suppose B2 contains 4 hours and C1 contains an hourly rate of 2.50. If the rate is arranged across the top of a table and should remain in row 1 while the formula is copied downward, the mixed reference C$1 locks the row but leaves the column relative. With those cell values, enter =B2*C$1 in D2; the result is 10. If copied down one row while B3 contains 6, the reference adjusts to B3*C$1 and returns 15.

A mixed reference is especially useful in a two-way table. For instance, a formula copied both across columns and down rows may need to keep a header row fixed while changing the selected column, or keep a label column fixed while changing the row. Before choosing a style, consider the direction in which you will copy the formula. A reference that is correct when filling down may not behave as intended when filling across.

How copying and filling affect references

Excel updates relative references according to how far a formula moves. Copying a formula one row down usually increases a relative row reference by one; copying it one column right usually advances a relative column reference by one. Absolute parts stay at their stated row or column. Mixed references combine these behaviors, which is why they are useful in formulas filled across a grid.

F4 changes the reference style in the formula; it does not copy the formula or fill a range. To apply a completed formula elsewhere, use the fill handle, copy and paste, or another suitable fill command. Before filling a large range, test the formula in one nearby cell and inspect the adjusted reference. This catches mistakes such as locking the wrong input cell or making both parts absolute when only the row needed to stay fixed.

Absolute references are also helpful when a formula points to a single assumption stored elsewhere, such as a commission rate or target. Keeping the assumption in a cell makes it easier to update and audit than embedding a number repeatedly in formulas. However, if the formula is intentionally meant to use a different rate for each row, locking the rate reference would be an error; the correct choice depends on the worksheet layout and intended calculation.

Windows, Mac, and Excel for the web

In Excel for Microsoft 365 on Windows, F4 is the standard shortcut while editing a formula reference. On some laptops, the function-key row controls hardware features by default. If F4 changes volume or brightness instead of the reference, try Fn+F4, or check whether the keyboard has a function-lock setting. The exact key behavior depends on the computer’s keyboard configuration.

In Excel for Microsoft 365 on Mac, press Command+T while editing the reference to cycle its styles. Mac keyboards and system settings can affect function-key behavior, so Command+T is the useful alternative to the Windows F4 instruction. In Excel for the web, keyboard behavior can depend on the browser and keyboard. If the shortcut is intercepted or does not change the reference, edit the formula and type the dollar signs directly, then check the resulting reference in the formula bar.

Common shortcut problems

F4 repeats an action instead: F4 can repeat the last action when Excel is not editing a formula reference. Enter formula-edit mode first and place the cursor on the reference.
The wrong part changes: Check where the cursor is and look at the full reference after each press. A1, A$1, and $A1 lock different parts.
The formula changes only one instance: F4 affects the reference at the insertion point. Move to another occurrence and change it separately if needed.
The shortcut controls a laptop feature: Try Fn+F4 on Windows or use the keyboard’s function-lock setting. On a Mac, use Command+T.
The copied formula still gives an unexpected result: Verify both the source cell and the reference style, then check the direction and distance the formula was filled. The shortcut cannot decide which cell should be fixed; that depends on the formula’s purpose.

One common misconception is that F4 always locks the cell containing the formula. It does not. It cycles the reference currently selected within the formula, which might point to an entirely different cell. Another is that absolute references protect data from changes; they only control how references adjust when formulas are copied. They do not lock a worksheet cell against editing.

Frequently Asked Questions

What is the shortcut for an absolute reference in Excel?

In Excel for Microsoft 365 on Windows, press F4 while editing a formula and the cursor is on the reference. On a Mac, use Command+T. The first cycle from a relative reference makes both its row and column absolute.

Does F4 lock both the row and the column?

Starting from a relative reference such as A1, the first F4 press changes it to $A$1, locking both parts. Further presses cycle to mixed references, so check the displayed reference before you finish editing.

How do I make only the row absolute?

Use a reference such as A$1: the dollar sign before the row number keeps that row fixed, while the column can adjust. Press F4 until the reference has that form, or type the dollar sign directly.

Why is F4 not working in Excel?

It may not be working because the formula is not being edited, the cursor is not on a reference, or a laptop function key is controlling a hardware feature. Try F2 and Fn+F4 on Windows, or Command+T on a Mac.

Can I type dollar signs instead of using the shortcut?

Yes. Enter the dollar signs directly in the reference, such as $A$1, A$1, or $A1. F4 is a faster way to cycle through the same reference styles, but it is optional.

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.