To change a cell reference in Excel for Mac, edit the formula, select the reference, and press Cmd+T or F4. If your keyboard sends a Mac system command instead, try Fn+F4. Use the shortcut while editing the reference inside the formula.
That's different from pressing F4 on an ordinary worksheet selection. Start with the task you want to perform before changing any shortcut assignments.
Switch a reference between relative, absolute, and mixed
Suppose B2 contains an amount of 80, and F1 contains a rate of 7.5%. Enter this formula in C2:
=B2*$F$1FormulaThe result is 6. The dollar signs keep F1 fixed when you copy the formula to another cell.

$F$1 are fixed.To change the reference style:
- Select C2, then click inside the formula bar to edit the formula.
- Select the
$F$1part of the formula, including its dollar signs. - Press Cmd+T or F4. Keep the reference selected and repeat the shortcut to move through the available styles.
- Press Return when you have the style you want.

$F$1 to F$1, which keeps only row 1 fixed.Microsoft lists both shortcuts for reference switching in the macOS section of its Excel keyboard shortcut guide.
| Reference | What stays fixed when you copy the formula |
|---|---|
F1 | Neither the column nor the row |
$F$1 | Both column F and row 1 |
F$1 | Row 1 |
$F1 | Column F |
All four forms still point to F1 in the original cell, so C2 still returns 6. The difference appears when you copy the formula. If Cmd+T opens a table dialog, return to the formula bar and select the reference text first.
For more context, see switching relative and absolute references in Excel for Mac. Its Excel 2008 and 2011 observations are historical; the current documented shortcut includes F4.
Repeat an action or redo an undone change?
These are separate jobs. Repeat performs an eligible previous action again. Redo restores a change you've undone; Undo reverses a change.
If you're coming from Windows, you may expect F4 to repeat the last action. Microsoft's shortcut guide documents that Windows behavior with the qualification “if possible.” Its Mac table explicitly lists F4 for reference switching, but does not list F4 alone as a repeat shortcut. Don't assume that the Windows assignment, or an old Mac customization, applies to your installation.
For an undone change, use Excel's Redo command. For a repeated action, check which repeat command and shortcut your version offers, and try it on a spare cell. A command that cannot be repeated won't become repeatable through a different key assignment.
If F4 triggers a Mac feature or does nothing
Work through these checks in order:
- Check the selection. For reference switching, select the reference text inside the formula. If a dialog or another app has focus, click back into Excel first.
- Try Cmd+T in the same formula. If it switches the reference, the formula is ready and the F4 key path needs attention.
- Try Fn+F4. On some keyboards the Fn key also carries a globe symbol. Whether you need it depends on your keyboard and function-key settings.
- Check macOS keyboard settings. Look for the option to use the F1, F2, and other keys as standard function keys. Its location depends on macOS and the keyboard; changing it affects other apps too.
- Check existing shortcut assignments. If your Excel version offers keyboard customization, inspect the command currently assigned to F4 before replacing it. A shortcut you customized years ago may explain today's behavior.
The older function-key setup article for Excel 2011 shows the historical setting and interface. Use it as background, rather than as a picture of today's macOS settings.
| Your goal | Where the focus belongs | What to try | If it fails |
|---|---|---|---|
Add or remove $ signs | Reference text selected inside a formula | Cmd+T or F4; Fn+F4 if needed | Recheck the selection and function-key setting |
| Repeat an eligible action | Worksheet, outside formula editing | The repeat command available in your Excel version | Check whether that action supports repeating |
| Restore an undone change | Worksheet, outside formula editing | Redo | Check that there is an undone change to restore |
Why the original article reassigned F4
This article originally described an Excel 2011 for Mac setup where F4 was assigned to Paste. The workaround used Tools > Customize Keyboard, selected Edit > Redo, and added F4. Gregory also noted that the change did not affect his separate Excel 2008 installation.
That explains the old instructions and comments below. It isn't a general rule that F4 means Paste on a Mac, and assigning it to Redo isn't a fix for selecting a formula reference. For that task, start with the formula-bar example above.