F2 in Excel for Mac: How to Edit a Cell (and Fix the Fn Key)

If you are used to Windows, F2 is the key that drops you straight into a cell so you can fix a formula without touching the mouse. On a Mac the same key exists, but it often seems to do nothing, because the F-keys on a MacBook are shared with system controls. This guide shows the Mac equivalent of F2 in Excel, how to make it work, and the other ways to edit a cell from the keyboard.

Quick answer: In Excel for Mac, F2 edits the active cell, the same as on Windows. On most MacBooks the top row defaults to brightness, volume and other system functions, so press Fn+F2, or turn on standard function keys in System Settings. You can also press Control+U to edit the active cell, or double-click the cell. If you also miss the Windows Alt sequences, the Mac Excel Shortcuts app adds them to Excel for Mac.

What F2 does in Excel for Mac

Pressing F2 puts the cursor inside the selected cell, at the end of its contents, so you can change a value or formula in place. It is the keyboard route to the same thing as double-clicking the cell or clicking in the formula bar. Microsoft lists F2 as the shortcut to edit the selected cell in Excel for Mac, and Control+U as another way to edit the active cell.

Once you are editing:

• Return commits the change and moves down.

• Tab commits the change and moves right.

• Esc cancels the edit and restores the original contents.

Why F2 seems not to work on a Mac

On most MacBooks, F2 is also the screen-brightness key. macOS treats the top row as system keys by default, so a bare F2 changes the brightness and never reaches Excel. The same problem affects F4, F5 and the rest of the row. There are two fixes:

1. Hold Fn. Press Fn+F2 each time. This needs no settings change, but it is easy to forget.

2. Use standard function keys. Open System Settings → Keyboard → Keyboard Shortcuts → Function Keys and turn on "Use F1, F2, etc. keys as standard function keys". Then F2 goes straight to Excel, and you hold Fn only when you want brightness or volume.

If the F-keys still do nothing, another app or a custom macOS shortcut may be using the key. Our guide to function keys in Excel for Mac and the Fn setting walks through the settings, and why Excel keyboard shortcuts don't work on Mac covers the rest.

Every way to edit a cell on a Mac

F2 and Control+U both leave your hands on the keyboard. Double-clicking is fine for a one-off but slow if you edit often.

F2 vs Control+U: which should you use?

Both edit the active cell. F2 is the habit you already have from Windows, and it is the one most guides mention, so use it if you have set up standard function keys. Control+U has the advantage of not depending on the Fn setting, which makes it the better choice on a laptop where you do not want to change the keyboard behaviour. Try both on a scratch cell and keep the one that feels natural.

F2 in a typical workflow

Here is where F2 saves the most time:

• Fixing a formula. Select the cell, press F2, correct the reference, press Return.

• Auditing a model. Move down a column with the arrow keys and press F2 on each suspicious formula to read it in the cell.

• Renaming labels. Select a header, press F2, and change one word without retyping the whole cell.

If you edit a formula and want to lock a reference, press ⌘T (or F4, with Fn) while the cursor is in the reference. We cover that in the absolute reference shortcut guide.

Related shortcuts that use the function row

The pattern is the same for all of them: if the bare key changes brightness or volume, add Fn or switch on standard function keys.

If you are coming from Windows

F2 is one of the few Windows shortcuts that carries over unchanged, apart from the Fn key. Most of the others do not. Windows Alt sequences such as Alt, E, S, V (Paste Values) have no equivalent in native Excel for Mac, and many Control shortcuts become Command shortcuts. The Mac Excel shortcut cheat sheet lists the Mac versions side by side with the Windows ones, and Mac Excel Shortcuts lets you type the Windows sequences in Excel for Mac if you want the muscle memory back.

Common mistakes

• Pressing F2 and changing brightness. Add Fn or enable standard function keys.

• Expecting Control+U to underline. In a cell you are not editing, ⌘U underlines text. Control+U edits the active cell.

• Editing the wrong cell. F2 acts on the active cell, so check which cell is highlighted first.

• Forgetting to commit. Press Return or Tab to keep the change, Esc to throw it away.

FAQs

What is the F2 equivalent in Excel for Mac?

F2 itself works in Excel for Mac and does the same job as on Windows. On most MacBooks you press Fn+F2, unless you have turned on standard function keys. Control+U also edits the active cell.

Why is F2 not working in Excel on my Mac?

The F-key is probably being used for a system function such as brightness. Press Fn+F2, or enable "Use F1, F2, etc. keys as standard function keys" in System Settings → Keyboard → Keyboard Shortcuts → Function Keys.

How do I edit a cell in Excel on a Mac without the mouse?

Select the cell with the arrow keys and press F2 (or Fn+F2), or press Control+U. Then type your change and press Return to commit it.

Is Control+U underline or edit on a Mac?

In Excel for Mac, Control+U edits the active cell. Underlining text is ⌘U.

Does F2 work on a Mac keyboard without a function row?

Compact keyboards may not have an F2 key. Use Control+U, or double-click the cell.

Related guides

• Function Keys in Excel for Mac: The Fn Setting and the F-Key Shortcuts

• Why Doesn't F4 Work in Excel on Mac?

• Why Excel Keyboard Shortcuts Don't Work on Mac (and How to Fix Them)

• Mac Excel Shortcuts: Cheat Sheet of 120 Commands

• What Are the Hidden Mac Excel Shortcuts?

Sources

• Microsoft: Keyboard shortcuts in Excel

• Apple: Change the function keys on your Mac