Back to articles
Intermediate
2011-01-055 min read

What Does F4 Do in Excel for Mac?

Table of Contents

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$1
Formula

The result is 6. The dollar signs keep F1 fixed when you copy the formula to another cell.

Excel for Mac editing the formula =B2*$F$1 in C2 with the absolute reference $F$1 highlighted
Edit the reference inside the formula bar. Here, both the column and row in $F$1 are fixed.

To change the reference style:

  1. Select C2, then click inside the formula bar to edit the formula.
  2. Select the $F$1 part of the formula, including its dollar signs.
  3. Press Cmd+T or F4. Keep the reference selected and repeat the shortcut to move through the available styles.
  4. Press Return when you have the style you want.
Excel for Mac showing the formula =B2*F$1 in C2 after F4 changed the reference style
In this Excel for Mac example, F4 changes $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.

ReferenceWhat stays fixed when you copy the formula
F1Neither the column nor the row
$F$1Both column F and row 1
F$1Row 1
$F1Column 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:

  1. 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.
  2. Try Cmd+T in the same formula. If it switches the reference, the formula is ready and the F4 key path needs attention.
  3. 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.
  4. 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.
  5. 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 goalWhere the focus belongsWhat to tryIf it fails
Add or remove $ signsReference text selected inside a formulaCmd+T or F4; Fn+F4 if neededRecheck the selection and function-key setting
Repeat an eligible actionWorksheet, outside formula editingThe repeat command available in your Excel versionCheck whether that action supports repeating
Restore an undone changeWorksheet, outside formula editingRedoCheck 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.

Enjoyed this guide?

Join our newsletter to get the latest Excel tips delivered to your inbox.

You can unsubscribe anytime. See our Privacy Policy.

Archived comments

Comments migrated from the previous version of the site. Adding new comments is disabled.

Select1January 29, 2011 at 07:53 PM
Unfortunately this does not work as repeat in Excel 2011. The Command Y function is not quite the same as redo (which the above process outlines how to assign F4 to Redo). I often use the F4 key (Repeat Command) in the Windows version to quickly delete rows and columns. The Command Y function (I believe Repeat Command) is not customizable - cannot be assigned using the Tools - Customize Keyboard.
Gregoryexcelsemipro.comJanuary 29, 2011 at 08:13 PM
You're right, the Cmd+6 keyboard shortcut is really the Repeat command, but since I'm use to Windows where the F4 button in Excel is either a Repeat or Redo (Cmd+Y) command, it really irks me that Excel for Mac setup F4 to be a Paste command so I wanted to change it. I wrote a new post showing how to put the the Repeat command icon on the toolbar, which works even better.
Ray DMay 3, 2011 at 05:56 PM
What about F2 for editing the contents of a cell? Is there any way to make that happen? I can't even fins a command for anything like that...
Gregoryexcelsemipro.comMay 3, 2011 at 06:07 PM
Use CONTROL+U instead of F2 in Excel for Mac. A pain in the you-know-what, but what's a fella supposed to to?
Ray DMay 3, 2011 at 06:48 PM
https://excelsemipro.com/2011/02/f2-in-excel-for-mac/ Awesome little addition to the system prefs!
SaraApril 23, 2013 at 08:14 PM
also, i just found out that if you're using a mouse, then double click in the cell = same as keyboard shortcut control+U (which is the same as the windows F2) for editing contents of a cell
Gregoryexcelsemipro.comApril 25, 2013 at 04:33 AM
Thanks for the reminder. I don't think I've mentioned that tip.
A GordonMay 29, 2011 at 03:46 AM
I normally do not comment on sites too often (extremely busy) but I had to here. YOU HAVE SAVED MY LIFE!!!! I am in the process of setting up some excel sheets for a client of mine that includes hundreds and hundreds of rows of information and changing this has saved me loads of time adding in hundreds of new information! Thank you again so much!
Saritha PeruriJuly 7, 2011 at 09:59 PM
Hey Greg, What about using F4 to lock cells (i.e., what typically allows you to toggle dollar signs in the cell). Thanks! Saritha
Gregoryexcelsemipro.comJuly 7, 2011 at 11:33 PM
Use COMMAND+T to toggle through the absolute/relative reference combinations. Or use the Switch Reference on the Formulas tab of the Ribbon.
Federico PratMay 3, 2013 at 12:00 PM
What if I want to assign F4 as a CMD+T alias? I would like F4 to act as in Windows Excel for cycling on reference types, but I cannot find the appropriate command in the dialog box for keyboard customisation.
Gregoryexcelsemipro.comMay 4, 2013 at 01:46 PM
I'm on a bit of a holiday and don't have access to my iMac, but you could pick a key and try to set the shortcut and then maybe Excel will tell you what key is reserved. Cmd+T may be a OS X shortcut so you might want to look in the Mac Preferences > Keyboard to see if the operating system would prevent you from using that keyboard combination. Sorry I couldn't be of more help.