Why Doesn't F4 Work in Excel on Mac?

Quick Answer: F4 toggles absolute and relative references in Excel for Mac while you edit a formula, but on many Mac keyboards the bare F-keys run system functions, so Excel never receives the keypress. Press Fn+F4, or turn on standard function keys in System Settings. Command-T does the same toggle without Fn. Microsoft's Mac shortcut list gives no shortcut for repeating the last action.

Coming from Windows, F4 is muscle memory for two jobs: repeating your last action, and cycling a cell reference between absolute and relative. The reference toggle exists on Mac. The problem usually sits between the keyboard and macOS, not inside Excel.

What does F4 do in Excel for Mac?

F4 cycles a cell reference through $A$1, A$1, $A1 and A1 while you edit a formula. Microsoft lists no Mac shortcut for repeating the last action, and lists Command-Y as Redo.

The fuller walk-through of the four reference states is in F4 in Excel for Mac: Absolute References (Cmd+T) and Repeating Your Last Action.

What does Microsoft document for F4 on Windows and on Mac?

Microsoft's Excel pages list F4 for cycling references on both systems, but only Windows gets F4 as repeat-last-action, and Command-Y on Mac means Redo, not Repeat.

What Microsoft lists for F4 on Windows and on Mac
Task in ExcelWindows listMac list
Cycle absolute and relative referencesF4Command-T or F4
Repeat the last actionF4 alone, or Ctrl+YNo entry
RedoNot what Ctrl+Y doesCommand-Y, Control-Y or Command-Shift-Z
Where F4 is listedFunction keys sectionFormula table only, not the Mac function key table

Microsoft's keyboard shortcuts page, opened 2026-11-03, puts the Mac reference toggle in its Work in cells or the Formula bar table as Command-T or F4. The same page leaves F4 out of its Mac function key table and gives no Mac entry for repeating the last action.

Ctrl+Y shows the gap most clearly. The Windows list uses Ctrl+Y to repeat the last action, while the Mac list uses Command-Y, Control-Y or Command-Shift-Z for Redo, so a Windows habit of pressing Ctrl+Y does something different on a Mac.

Why does F4 not work on my Mac?

Five causes cover most cases: macOS runs a system function on the key, you are not editing a formula, the keyboard is external, remapping software intercepts it, or you expect it to repeat an action.

Why F4 fails in Excel for Mac
What you seeLikely causeFix
F4 changes brightness or opens a system featureThe top row is set to system functionsHold Fn or Globe, or turn on standard function keys
F4 does nothing to a referenceNot editing a formula, or the cursor is not in a referenceDouble-click the cell or press F2, then click the reference
F4 fails on an external keyboard onlyExternal keyboards can have a separate setting, or a non-Apple board may lack itUse the external-keyboard option, or try Command-T
F4 stopped after installing a key toolRemapping software intercepts the keyPause the tool and retest
F4 does not repeat the last actionMicrosoft lists F4 on Mac only as the reference toggleCheck the Edit menu; Redo is Command-Y

How do I make F4 work with the Fn key?

Hold Fn, or the Globe key, while pressing F4. Apple says this sends the standard function key action instead of the printed system feature. If you have no Fn key, hold Control instead.

The icon printed on the F4 key shows what it does by default, and it varies by keyboard. Apple's function keys page does not say what F4 does on every model, so check the key itself. Apple names F3 as Mission Control, not F4.

How do I turn on standard function keys in System Settings?

On macOS Ventura or later, open System Settings, click Keyboard, click Keyboard Shortcuts, choose Function Keys and turn on Use F1, F2, etc. keys as standard function keys. Brightness and media keys then need Fn.

  1. Open the Apple menu and choose System Settings.

  2. Click Keyboard in the sidebar, then Keyboard Shortcuts.

  3. Choose Function Keys and turn on Use F1, F2, etc. keys as standard function keys.

Apple says the option may be missing on a keyboard not made by Apple, which can need a third-party utility or the maker's guidance. Some Macs show a separate option for external keyboards.

What did one Mac report for the function key setting?

A read-only Terminal check on a 14-inch 2021 MacBook Pro running macOS 26.6.2 returned 0 for the function key preference, the value that corresponds to standard function keys being off, so F4 needs Fn there.

defaults read -g com.apple.keyboard.fnState

Output 0 means the top row runs its printed system features and F4 needs the Fn key. Output 1 is the community-reported value for standard function keys on. An error saying the pair does not exist means the preference has not been written on that Mac, so open System Settings instead.

Apple does not document this preference, so the System Settings switch stays the supported way to change it. The reading above was taken on 2026-11-03 from one Mac, and F4 was not pressed in Excel on it.

Am I in the right mode for F4 to change a reference?

F4 changes a reference only while you edit a formula with the cursor inside or right after the reference. Selecting the cell alone is not enough. Double-click the cell or press F2 first.

  1. Double-click the cell, or select it and press F2.

  2. Click inside the reference, such as A1, or right after it.

  3. Press Fn+F4, F4 or Command-T repeatedly to cycle $A$1, A$1, $A1 and A1.

How do I find out whether macOS or Excel is taking the key?

Run quick tests in order: try Fn+F4, check the standard function keys setting, try F4 in another app, then try an external keyboard. The first test that changes the result shows the cause.

Troubleshooting order for F4 in Excel for Mac: a schematic of the tests to run, starting with Fn plus F4
Troubleshooting order for F4. Schematic, not a screenshot.
  • Press Fn+F4 instead of F4 and see whether the reference cycles.

  • Check System Settings ▸ Keyboard ▸ Keyboard Shortcuts ▸ Function Keys for the standard function keys setting.

  • Press F4 in another app to see whether a system feature opens, which means macOS takes the key first.

  • Try an external keyboard if you normally use the built-in one, because settings can differ per keyboard.

  • Quit Excel fully, relaunch it, then restart the Mac and retest.

Can remapping software block F4?

Yes. Tools such as Karabiner-Elements or BetterTouchTool can intercept F-keys before Excel sees them. Pause or quit the tool, retest F4, and add a rule back only after the plain key works.

Does F4 repeat the last action on a Mac?

Not as Microsoft documents it. Its Mac list gives F4 only as the reference toggle and lists Command-Y as Redo. Open the Edit menu to see whether Excel offers Repeat for your last step.

Why do some guides say Fn+F4 repeats the last action?

One third-party guide tells Mac users to format a cell and press Fn+F4 to repeat it, but Microsoft's Mac list has no such entry, so the claim stays unverified until tested.

A web search on 2026-11-03 found one guide making that claim and several others, including a Microsoft Q&A answer, giving only the Command-T reference toggle. Microsoft's own Mac list agrees with the second group.

A fair test takes under a minute: apply a fill colour to one cell, select another cell, press Fn+F4, and see whether the fill repeats. Note the Excel version from Excel, About Excel, when reporting the result.

Can I use Command-T instead of F4?

Yes, while editing a formula. Microsoft lists Command-T for toggling references, and it needs no Fn key. Outside edit mode the same combination can create a table, so click into a reference first.

How can Mac Excel Shortcuts help with F4?

Mac Excel Shortcuts, which we make, is built around keeping Windows shortcut habits on a Mac. We have not documented F4 handling here, so check the app's covered list before relying on it for F4.

The trial lasts 7 days or 10 shortcut uses, then it costs $49 once or $4.99 per month. See Mac Excel Shortcuts for the current list.

FAQs

Does F4 repeat the last action on Mac like it does on Windows?

Not as Microsoft documents it. Its Excel list gives F4 only as the reference toggle on Mac and lists Command-Y as Redo. Check the Edit menu for a Repeat command for your last step.

Why does F4 do something else instead of working in Excel?

macOS can reserve the bare F-keys for system features, so the printed icon on the key runs instead. Hold Fn, or turn on standard function keys in System Settings, to send the real F4.

Where is the F4 key on a Mac for Excel?

F4 is in the top row of the keyboard, between F3 and F5. On many MacBooks the printed icon is a system function, so press Fn+F4 to send the real F4 to Excel.

What is the equivalent of F4 in Excel for Mac?

For toggling absolute and relative references, the Mac equivalent is Command-T, and F4 also works, with Fn on most MacBooks. Microsoft documents no Mac shortcut for repeating the last action.

Does F4 work differently on an external keyboard?

Yes. Function key behaviour is a setting, and some Macs list a separate option for external keyboards. A keyboard not made by Apple may not show the setting at all.

Does F4 work in Excel for Mac without the Fn key?

Yes, once standard function keys are turned on in System Settings, because the bare key then sends F4 to Excel. With the setting off, Fn+F4 or Command-T does the job.

Why does Command-T create a table instead of cycling references?

Microsoft lists Command-T for both jobs on Mac. Reference toggling works only while a formula is being edited with the cursor in a reference; outside formula editing, Command-T creates a table instead.

Sources

← Back to all articles

Mac Excel Shortcuts: Excel shortcuts not working on Mac? Alt E S V, Paste Values, the Windows way. Try it free for 7 days.