F4 Dollar Sign in Excel Not Working? Causes and Fixes

If F4 will not add dollar signs to a cell reference in Excel for Microsoft 365 on Windows, first make sure you are editing a formula and that the cursor is inside a reference such as A1; then press F4. On many laptops, you may need Fn+F4 instead. F4 cycles the reference through relative, absolute, and mixed forms—it does not insert a dollar sign wherever the cursor happens to be.

What F4 does to an Excel reference

Excel cell references can change when you copy or fill a formula. A relative reference such as A1 adjusts to the formula’s new position. An absolute reference such as $A$1 keeps both the column and row fixed. The dollar signs are the markers that tell Excel which parts should stay put.

When you edit a formula and place the insertion point within a cell reference, F4 cycles through four forms:

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

Press F4 again to continue cycling. The exact starting form depends on the reference you selected. For example, if the formula contains A1, the first press usually changes it to $A$1. If the cursor is not within a reference, Excel has nothing to convert, so the shortcut may appear not to work or may perform another F4 action.

Use F4 in the right place

F4 works on a reference inside a formula, not simply because a cell is selected. You can use it while building a formula or while editing one that already exists. The insertion point matters: select the reference itself, rather than leaving the cursor at the end of the formula or inside a function name.

Start a formula or select a formula cell and press F2 to edit it. You can also click in the formula bar.
Use the arrow keys or mouse to position the cursor within a cell reference, such as A1. If the reference is part of a range, position the cursor in the endpoint you want to change.
Press F4 until the dollar-sign pattern you need appears.
Press Enter to commit the formula, then check that it calculates as intended.

For example, if a formula contains =A2*F1 and you want the F1 rate to stay fixed when the formula is filled down, put the cursor in F1 and press F4 until it becomes $F$1. The other reference, A2, can remain relative so it changes to A3, A4, and so on.

Check laptop function-key settings

A common reason F4 seems unresponsive is that the keyboard sends a hardware command instead of a function key. On some laptops, the top row controls brightness, volume, or other device features by default. Try Fn+F4, or press Fn Lock if your keyboard has that feature. The key labels and Fn Lock behavior vary by computer manufacturer, so check the laptop’s keyboard markings or documentation.

If Fn+F4 works but F4 alone does not, Excel’s formula editing is probably fine; the keyboard is prioritizing its media-key action. Some computers let you change this behavior in firmware or keyboard settings, but the setting name and location differ by model. Avoid changing system settings until you have confirmed that the function-key mode is the cause.

Also check that Excel has focus. If another window, dialog box, or browser tab is active, its keyboard shortcuts may receive the key instead. Click the worksheet or formula bar, return to editing the formula, and try again. On Windows, F4 outside formula editing can repeat a previous action, so seeing a different result does not necessarily mean the key is broken.

Mac and Excel for the web differences

In Excel for Mac, the usual shortcut for cycling a reference is Command+T rather than the Windows F4 key. Select or place the cursor in the reference while editing the formula, then use Command+T repeatedly to cycle the reference styles. Depending on the Mac keyboard and its function-key settings, you may need Fn with a function key for other F-key actions, but Command+T is the key difference to try for reference locking.

Excel for the web runs inside a browser, and browser or operating-system shortcuts can affect how function keys behave. If F4 is intercepted or does not cycle the reference in your setup, try editing the formula and typing the dollar signs yourself, or open the workbook in the desktop Excel app. The desktop app is also a useful way to determine whether the issue is the browser environment rather than the formula.

Do not confuse F4 with Ctrl+4 on Windows or Command+4 on Mac. Those are different key combinations and do not perform the same reference-cycling action. If you use a nonstandard keyboard layout or remote desktop, the function key may also be remapped before Excel receives it.

Type dollar signs manually when needed

F4 is a convenience, not a requirement. You can edit a formula directly and type $ before the column letter, row number, or both. For example, change F1 to $F$1 to lock both parts. This is often the quickest workaround when a laptop key is intercepted or you are editing in a browser.

Use the reference type that matches the way the formula will be copied:

Use $F$1 when both the rate column and row must remain fixed.
Use F$1 when formulas should move across columns but keep pointing to row 1.
Use $F1 when formulas should move down rows but keep pointing to column F.
Leave the reference as F1 when both row and column should adjust as the formula moves.

Consider this layout: prices are in A2:A4, the fixed multiplier is in F1, and calculated results go in B2:B4. Put 1.08 in F1 and 20 in A2. In B2, enter =A2*$F$1. The result in B2 is 21.6. When you fill the formula down, A2 changes to A3 and A4, while $F$1 remains fixed. If F1 were left unlocked, it would shift to F2 and F3, which could produce incorrect results or a reference to an empty cell.

Understand absolute and mixed references

A dollar sign locks a reference component during copying; it does not protect a cell from being edited, deleted, or overwritten. Absolute references are particularly useful for assumptions, rates, constants, and lookup locations that many formulas share. They make a formula’s intended relationship clearer when it is copied across a worksheet.

Mixed references are useful in two-direction tables. Suppose row 1 contains column headings, column A contains row headings, and a calculation in B2 needs to keep using the heading in column A while copying horizontally, and the heading in row 1 while copying vertically. A formula might use $A2*B$1: the column A is fixed in the first reference, while row 1 is fixed in the second. As the formula is copied, the unlocked parts change to follow the table position.

A frequent misconception is that every reference in a formula should be absolute. That can make a copied formula repeat the same calculation instead of following each row. Decide separately for each reference whether its row, column, both, or neither should move. Then use F4 or manual dollar signs to express that choice.

References F4 may not change as expected

F4 is designed for ordinary A1-style cell references in formulas. It may not behave like a simple toggle for every item that looks like a reference. Structured table references, such as references to a table column or the current row, use their own syntax and do not use the same row-and-column dollar-sign pattern. Named ranges also have their own names rather than an A1 address to lock.

Check these details if the reference still does not change:

Confirm the formula is in edit mode and the cursor is inside the A1-style reference.
For a range such as A1:B10, place the cursor in the endpoint you intend to change; each endpoint can have its own reference type.
Check whether you are editing a table formula or a named range instead of a standard cell reference.
Make sure the key is reaching Excel rather than changing volume, brightness, or another application setting.
Look at the formula bar after pressing the shortcut; a change to the reference text is easier to verify than the displayed result alone.

If you are editing a formula that uses sheet names, such as Sheet2!A1, focus on the cell address portion when changing its reference style. A sheet name does not become absolute just because the cell address has dollar signs. The $ characters control the row and column reference, not whether the worksheet itself is renamed or moved.

A practical troubleshooting sequence

Try the following sequence before changing Excel or keyboard settings. It separates a formula-position issue from a key or platform issue.

Click a formula cell, press F2, and use the arrow keys to put the cursor within a clear reference such as A1.
Press F4 once and inspect the formula text. On a Windows laptop, repeat the test with Fn+F4 if nothing changes.
If the reference changes, continue pressing the shortcut until it reaches the required pattern, then press Enter.
If neither key combination works, type the dollar signs directly and see whether the formula accepts the edited reference.
If manual editing works, check function-key behavior, keyboard focus, and whether you are using Excel desktop, Mac, or a browser.

This test avoids a common false alarm: pressing F4 while a cell is merely selected, without editing the formula, does not tell you whether reference cycling works. Similarly, if you press Enter before changing the reference, you have left formula editing and the shortcut will no longer act on that formula.

Frequently Asked Questions

Why does F4 open or control something instead of adding dollar signs?
Excel may not be editing a formula, or the cursor may not be inside a cell reference. On a laptop, F4 may also be assigned to a hardware function. Edit the formula and try Fn+F4, or type the dollar signs manually.

What is the correct F4 order in Excel?
For a reference starting as A1, repeated presses cycle through $A$1, A$1, $A1, and A1. Press until the row and column locking pattern matches how you plan to copy the formula.

How do I lock only a row or only a column?
Use A$1 to lock row 1 while allowing the column to change, or $A1 to lock column A while allowing the row to change. F4 cycles through these mixed-reference options, and you can also type the dollar sign in the formula.

What is the F4 equivalent in Excel for Mac?
Use Command+T while editing a formula with the cursor in its cell reference. The Windows shortcut is F4; keyboard function-key settings can affect other F-key behavior on either platform.

Does F4 work with table references such as Sales[Amount]?
Not in the same way as an A1 reference. Structured table references use table-specific syntax, so F4 does not cycle their row and column locks like it does for references such as A1. Edit the structured reference according to the table formula you need.

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.