Excel Function Keys: What F1–F12 Do

In Excel for Microsoft 365 on Windows, the function keys F1–F12 open Help, edit cells, repeat actions, move between interface areas, calculate formulas, and perform other tasks. Their exact effect can depend on whether you press a modifier such as Ctrl or Shift, whether you are editing a formula, and whether your keyboard requires the Fn key.

Excel F1–F12 at a glance

Here is what the function keys do in a typical Windows desktop installation of Excel. Use the plain key first; modified versions are covered below.

F1: Opens Excel Help. If the Help pane is already open, F1 can place focus in its search box.
F2: Edits the active cell. The insertion point appears in the cell’s contents or formula bar, so you can change the entry without replacing it.
F3: Opens the Paste Name dialog when the workbook contains defined names. It lets you insert a name into a formula; with no names available, it may have no useful action.
F4: Repeats the last command or action when Excel can repeat it. While editing a formula, it cycles the reference at the insertion point through relative and absolute forms.
F5: Opens the Go To dialog, where you can enter a cell address or select a named range.
F6: Moves focus among the worksheet, ribbon, task pane, and zoom controls. Press Shift+F6 to cycle in the reverse direction.
F7: Opens spelling checks for the worksheet or selected text. It checks spelling, not the accuracy of calculations or data.
F8: Turns Extend Selection mode on or off. With it on, arrow keys expand the selection instead of moving the active cell. Shift+F8 lets you add a separate range to the current selection.
F9: Calculates formulas in all open workbooks. The exact scope and recalculation behavior are explained below.
F10: Turns on KeyTips, the letters and numbers that let you navigate ribbon commands from the keyboard. Shift+F10 opens the context menu for the selected item, much like a right-click.
F11: Creates a chart sheet from the selected data, placing the chart on its own sheet rather than embedding it in the current worksheet.
F12: Opens the Save As dialog so you can save the workbook under a different name, location, or file type.

Useful combinations with function keys

Modifiers change what a function key does. These Windows combinations are useful when you want to control the ribbon, workbook windows, sheets, or files without reaching for the mouse.

Ctrl+F1: Shows or hides the ribbon.
Alt+F1: Creates an embedded chart from the selected data. Unlike plain F11, it places the chart on the current worksheet.
Shift+F11: Inserts a new worksheet.
Ctrl+F2: Opens the print preview area on the Print screen.
Ctrl+F3: Opens Name Manager, where you can review, edit, or delete defined names.
Ctrl+Shift+F3: Creates names from labels in the selected range, such as row or column headings.
Shift+F12: Saves the workbook. It is an alternative to Ctrl+S.
Ctrl+F4: Closes the active workbook window. Save changes first if you want to keep them.
Alt+F4: Closes Excel itself, or the active application window if Excel is not the only open window.
Ctrl+F12: Opens the Open dialog for choosing a workbook.

Some other Ctrl+function-key combinations manage workbook windows: for example, Ctrl+F6 moves to the next open workbook window, while Ctrl+F5 restores a workbook window from its maximized size. These are window-management commands, so what you see depends on how many workbooks are open and how their windows are arranged.

How F4 changes formula references

F4 is especially useful when building formulas because it changes a cell reference between relative and absolute forms. A relative reference such as B2 can adjust when a formula is copied. An absolute reference such as $F$1 keeps both the column and row fixed. The mixed forms $F1 and F$1 lock only the column or row.

For example, with a quantity of 12 in B2 and a price factor of 1.5 in F1, enter this formula in C2 to multiply them:

With 12 in B2 and 1.5 in F1, enter =B2*F1 in C2; it returns 18.

While editing that formula, place the cursor in or next to the F1 reference and press F4 repeatedly. Excel cycles through F1, $F$1, F$1, and $F1. If you copy the formula down to C3, locking F1 as $F$1 keeps the factor cell fixed while the relative B2 reference changes to B3. On many Mac keyboards, Command+T cycles reference styles while editing a formula; the actual key may also depend on the keyboard’s function-key setting.

F9 and recalculation

F9 is not just a general refresh button. Its variations determine how much of the workbook Excel recalculates. In a workbook set to automatic calculation, Excel normally updates dependent formulas when their inputs change, so you may not need to press F9 at all.

F9: Calculates formulas in all open workbooks.
Shift+F9: Calculates the active worksheet.
Ctrl+Alt+F9: Forces calculation of all worksheets in all open workbooks, including cells Excel may not otherwise consider needing recalculation.
Ctrl+Alt+Shift+F9: Rechecks formula dependencies and then recalculates all cells in all open workbooks.

These stronger commands can take longer in large workbooks. They can help diagnose stale results, but they do not repair a wrong formula or incorrect source data. Check the calculation setting under Formulas > Calculation Options if results are not updating as expected. Choosing Manual means formulas may wait for a recalculation command.

Function keys versus Excel functions

The phrase function keys means the physical keyboard keys labeled F1 through F12. It does not mean Excel worksheet functions such as SUM or IF. Function keys are keyboard commands: F2 edits a cell, for instance. Worksheet functions are entered into cells as part of formulas and calculate results from data.

This distinction matters when searching for help. A request for an Excel function key list is about keyboard shortcuts; a request for a function list is usually about formulas. There is a connection, though: F4 can edit the reference syntax inside a formula, and F9 can recalculate formulas. Neither key inserts a worksheet function by itself.

Why a function key may not work

On many laptops, the top row doubles as controls for volume, screen brightness, or media playback. The keyboard may send those actions instead of F1–F12 unless you hold Fn, press an Fn Lock key, or change the keyboard’s function-key setting. The setting and its name vary by computer manufacturer, so check the computer’s keyboard instructions rather than assuming Excel is at fault.

If pressing F2 changes brightness instead of editing a cell, try Fn+F2.
If the key works only while holding Fn, look for an Fn Lock control or a keyboard setting that makes the F-key actions primary.
If F4 does not change a reference, first confirm that you are editing a formula and that the insertion point is on a cell reference.
If a shortcut behaves differently in Excel for the web, check whether the browser is intercepting the key.
If a command is unavailable, consider the current selection and context. F3, for example, depends on defined names being present.

Windows, Mac, and Excel for the web

The list above describes Excel for Microsoft 365 on Windows. On Mac, the top-row keys may control system features unless macOS is set to use them as standard function keys or you hold Fn. Some Excel shortcuts also use different modifier keys. For example, Command+T cycles reference styles while editing a formula in Excel for Mac, where Windows users typically press F4. Check Excel Help for the Mac-specific shortcut when a Windows combination does not apply.

Excel for the web runs inside a browser, and browser shortcuts can compete with function keys. The web version may also handle some commands differently from the desktop app. If F1–F12 triggers a browser feature or has no effect, try the ribbon command or the browser’s keyboard-shortcut guidance. For repeated keyboard-heavy work, the Windows or Mac desktop app generally provides the more predictable environment for Excel-specific function-key commands.

Frequently Asked Questions

What does F2 do in Excel?
F2 edits the active cell. It lets you modify the existing cell entry rather than replacing it, and it is particularly useful for correcting part of a formula.

What does F4 do in Excel?
F4 repeats a repeatable last action, or, while a formula is being edited, cycles the selected cell reference through relative, absolute, and mixed-reference forms.

How do I recalculate an Excel workbook with a keyboard shortcut?
Press F9 to calculate formulas in all open workbooks, or Shift+F9 to calculate only the active worksheet. Use the Ctrl+Alt combinations for a more complete recalculation when needed.

How do I insert a new worksheet using a function key?
Press Shift+F11 in Excel for Windows to insert a worksheet. If a laptop uses its top row for media or hardware controls, you may need to press Fn as well.

Why do my F keys control brightness instead of Excel?
Your keyboard may be set to use its top row for hardware features by default. Try Fn with the function key or change the computer’s function-key or Fn Lock setting.

Does F11 make a chart in the worksheet?
Plain F11 creates a chart on a separate chart sheet. To create an embedded chart on the current worksheet, select the data and press Alt+F1.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.