F4 in Excel for Mac: Absolute References (Cmd+T) and Repeating Your Last Action
Quick answer: In Excel for Mac, click inside a cell reference while editing a formula and press F4 (with Fn if needed) or Command-T to cycle it between absolute and relative: $A$1, A$1, $A1 and A1. Microsoft lists Command-Y as Redo and gives no Mac shortcut for repeating your last action.
F4 is two shortcuts in one on Windows: it cycles references and it repeats the last action. On a Mac, Microsoft documents only the reference toggle for F4 and lists Command-Y as Redo.
How do I toggle between absolute and relative references on a Mac?
Edit the formula, put the cursor inside a reference such as A1, and press F4, Fn+F4 or Command-T. Each press moves to the next state: $A$1, A$1, $A1, then A1.
Double-click a cell that contains a formula, or select it and press F2.
Place the cursor inside or right after a reference such as A1.
Press F4 (or Fn+F4), or Command-T.
Keep pressing to cycle through the four states.
| Presses | Reference | Behaviour when copied |
|---|---|---|
| 0 | A1 | Row and column both change |
| 1 | $A$1 | Row and column both stay fixed |
| 2 | A$1 | Row stays fixed, column changes |
| 3 | $A1 | Column stays fixed, row changes |
Use $A$1 when a formula copied elsewhere must always point to the same cell, such as a tax rate.
Why do I need dollar signs in a formula?
Dollar signs lock part of a reference so it does not move when a formula is copied. Without them, copying a formula down shifts each reference by one row and can hit an empty cell.
Imagine a tax rate of 8% in cell B1 and prices down column A. In B3 you write the formula =A3B1. Copy it down and Excel shifts the reference, so B4 becomes =A4B2, which points at an empty cell and returns the wrong answer. The numbers here are illustrative.
Click inside B1 in the formula and press F4 (or Command-T) so it reads $B$1. Now every copy keeps pointing at B1 while A3 still moves down the column.
What are mixed references, and when do I use them?
A mixed reference locks only the row or only the column. Use A$1 to lock the row and $A1 to lock the column, in tables where one reference moves one way only.
In a multiplication grid with numbers down column A and across row 1, the formula =$A2*B$1 works in every cell. The $A part locks the column so it always reads column A, and B$1 locks the row so it always reads row 1. Press F4 repeatedly until each reference shows the combination you want.
What tips help when editing references?
Click inside the reference first, because the key changes the reference where the cursor sits. You can also type dollar signs by hand when neither key works on your keyboard.
Click inside the reference first. The key changes the reference where the cursor sits.
Select a whole range reference such as A1:B5 inside the formula. On Windows this changes both ends at once; we did not retest it on Mac.
Type the dollar signs if neither key works on your keyboard.
What if F4 does nothing?
Two causes cover most cases: the key needs Fn because function keys are not set as standard, or you are not in edit mode. The fixes are one click away.
Fix the first in Function Keys in Excel for Mac: The Fn Setting and the F-Key Shortcuts That Matter, and see Why Doesn't F4 Work in Excel on Mac? for the full troubleshooting list.
Why does Command-T sometimes create a table?
Microsoft lists Command-T both for toggling references and for creating a table. While you edit a formula it toggles the reference. Outside edit mode, the same combination can create a table.
Does F4 repeat the last action on a Mac?
Not as Microsoft documents it. Command-Y is listed as Redo, and the Mac list gives no shortcut for Repeat Last Action. Open the Edit menu to see whether Excel offers Repeat for your last step.
FAQs
What is F4 on Mac Excel?
F4 toggles absolute and relative references while you edit a formula. Command-T does the same, and it works without the Fn key on keyboards where F-keys run system features.
Why does F4 not work in Excel for Mac?
Usually the key needs Fn, or you are not editing a formula. Click inside a reference in a formula first, then press Fn+F4 or Command-T and see whether the reference cycles.
What does the dollar sign do in Excel?
A dollar sign locks the row, the column or both, so that part of the reference does not change when you copy the formula to another cell. Use F4 or Command-T to add them.
Can I use F4 on a whole range like A1:B5?
On Windows, selecting the whole range reference inside the formula and pressing the key applies the dollar signs to both ends. We did not retest this on Excel for Mac.
Why did my formula break when I copied it?
The reference was relative, so it moved when copied. Make it absolute with F4 or Command-T before copying, so it keeps pointing at the same cell, such as a tax rate.
Do I need to press F2 first?
Not if you are already editing the formula. F2 is a quick way to start editing the active cell, though on many MacBooks it needs the Fn key as well.
Sources
Microsoft's Excel for Mac shortcut list (F4, Command-T, Command-Y): quoted from our earlier fact-check, plan/evidence-factcheck-live-posts-2026-11-02.md. The Microsoft page could not be reopened on 2026-11-03.