Excel Absolute Reference Shortcut (F4 / ⌘T)
While editing a formula, click on a cell reference and press F4 on Windows or ⌘T (Command+T) on the Mac. Excel adds dollar signs ($A$1) to lock the reference; press again to cycle through $A$1 → A$1 → $A1 → A1.
| Action | Mac | Windows | |
|---|---|---|---|
| Toggle absolute / relative ($) | ⌘T | F4 | |
| Cycle $A$1 → A$1 → $A1 → A1 | ⌘T (repeat) | F4 (repeat) | |
| Edit active cell / enter formula | ⌃U | F2 |
Lock a reference while you type the formula
Start a formula and click (or arrow to) the cell reference you want to freeze, then press F4 (Windows) / ⌘T (Mac). Excel wraps it in dollar signs — $A$1 — so it won't shift when you copy the formula down or across. Pressing the key again cycles through the mixed forms: A$1 (lock row), $A1 (lock column), then back to A1.
Windows vs Mac
Windows uses the single F4 key; if your laptop maps F-keys to media controls, press fn+F4. Excel for Mac uses ⌘T instead, because F4 on macOS is often intercepted by the system. Both do exactly the same cycle through absolute and mixed references.
Absolute references in Google Sheets
Google Sheets uses the same F4 key: start the formula, put the cursor on the reference, and press F4 to toggle through $A$1 → A$1 → $A1 → A1. On a Mac in Sheets, F4 also works directly in the browser — you do not need ⌘T there, that substitution is only for the Excel desktop app.
Why the reference moves when you copy a formula
By default Excel uses relative references, so copying =A1*2 one row down becomes =A2*2. Locking with the $ signs is what stops that drift: =$A$1*2 keeps pointing at A1 no matter where you paste it. Type the $ by hand or let F4/⌘T insert it for you.
Working in a long table? Keep headers visible with the Freeze Panes shortcut.
Need another line in the range? See the Insert Row shortcut.
FAQ
What is the absolute reference shortcut in Excel?
Press F4 on Windows or ⌘T (Command+T) on the Mac while editing a formula with a cell reference selected. It adds the $ signs to lock the reference.
Why doesn't F4 work on my Mac?
Excel for Mac uses ⌘T for absolute references instead of F4. On Windows laptops you may need fn+F4 if function keys are set to media.
How do I get a mixed reference like A$1?
Press F4 (Windows) or ⌘T (Mac) repeatedly. It cycles $A$1 → A$1 → $A1 → A1 so you can lock just the row or just the column.
Does F4 work for absolute references in Google Sheets?
Yes. In Google Sheets press F4 while editing a formula to cycle a reference through $A$1, A$1, $A1 and A1 — the same cycle as Excel on Windows.