Excel Shortcut to Edit a Cell: F2 and Other Methods

In Excel for Microsoft 365 on Windows, select the cell you want to change and press F2 to edit its existing contents. Make your change, then press Enter to keep it; press Esc to cancel the edit.

What the F2 shortcut does

F2 switches the selected cell into editing mode, allowing you to change its current entry instead of replacing the whole entry. If the cell contains text or a number, Excel places the insertion point in the cell’s contents. If it contains a formula, you can edit the formula and its cell references. This is useful for fixing a typo, changing part of a label, or adjusting one argument in a long formula.

The shortcut applies to the active cell: the cell with the selection border. If you have selected a range, only the active cell within that selection is edited. F2 does not open a separate dialog or make a copy of the cell. It lets you work on the contents already stored there.

That distinction matters because simply typing while a cell is selected normally replaces its entire contents. For example, if a cell contains North Region and you select it and type South, Excel replaces the whole entry. To change only North to South while keeping Region, select the cell, press F2, place the insertion point in the word, and edit it.

How to edit a cell with F2

Use this sequence for a typical edit in the Windows desktop version of Excel:

Click the cell, or navigate to it with the arrow keys.
Press F2. The cell is ready for editing, with the insertion point in its contents.
Use the arrow keys, Home, End, or the mouse to position the insertion point, then type, delete, or select the characters you want to change.
Press Enter to commit the change. Press Esc instead if you want to discard the edit you have made since entering edit mode.

For example, if A1 contains Qtr 1 Sales and the label should say Qtr 2 Sales, F2 lets you move to the 1, replace it with 2, and leave the rest of the text intact. Pressing Enter saves the revised label. If you had typed Qtr 2 Sales without first pressing F2, the entire existing entry would have been replaced anyway, but that approach is less convenient when you need to preserve most of a long value.

On some keyboards, the top-row keys have media or brightness functions by default. If pressing F2 changes volume or does something unrelated, try holding the keyboard’s Fn key while pressing F2, or change the keyboard’s function-key behavior in its system settings. The exact Fn behavior depends on the computer and keyboard, not on the workbook.

Editing text and formulas inside a cell

F2 is particularly helpful when editing a formula because it exposes the formula in the cell and allows you to adjust its parts. For instance, if a formula refers to the wrong column, you can use F2 and revise the reference rather than typing the entire formula again. Excel typically highlights referenced cells in different colors while a formula is being edited, making it easier to see which range each reference points to.

When a formula is being edited, pressing the arrow keys may insert or change a cell reference rather than move the insertion point through the text. Excel has a point mode for selecting references, so the result depends on where the cursor is and how the formula is being edited. To move through formula characters without accidentally selecting a new reference, use the mouse to click the intended position or use the relevant navigation keys carefully. You can also make the change in the formula bar, where the formula is displayed above the worksheet.

Editing directly in the grid and editing in the formula bar change the same cell value; they are two ways to work with it. The formula bar can be easier for long formulas or long text because it provides more room to see the entry. If the formula bar is not visible, turn it on from the View tab by selecting Formula Bar. The exact layout of the ribbon can vary with the Excel window size, but the setting is on that tab.

Do not confuse changing a formula with changing its displayed result. A cell may show a rounded value because of its number format while the formula bar shows a more precise underlying value or the formula itself. F2 edits the stored entry; it does not merely change how the result is displayed. To change rounding or date appearance, adjust the number format instead.

Moving within an edit and committing the change

While editing, the arrow keys move the insertion point through the entry in ordinary text-editing situations. Home and End can move to the beginning or end of a line of content. You can also use the mouse to click near the characters you want to change. If you select characters before typing, the new text replaces that selection; Backspace or Delete removes selected characters or characters next to the insertion point.

Enter commits an edit and normally moves the active selection down one cell. Tab commits the edit and moves the selection to the cell on the right. These keys are useful when entering or correcting a sequence of adjacent cells. If you want to commit the edit while keeping the active cell in place, click the check mark beside the formula bar; clicking another cell can also commit an edit, so do that only when you intend to finish.

Pressing Esc while a cell is still being edited abandons the uncommitted changes and restores the value that was present when you began that edit. Once you have pressed Enter or otherwise committed the change, Esc does not roll it back. Use Ctrl+Z on Windows to undo a committed change, provided no later action has made that undo inappropriate. Undo affects the most recent workbook action, so check the result rather than assuming it has reverted only the edit you intended.

Other ways to edit the active cell

F2 is usually the quickest keyboard method, but it is not the only option. Choose a method based on whether you are correcting a small part of an entry, working with a long formula, or using a touch-oriented device.

Double-click the cell: This puts the insertion point in the cell’s contents when direct in-cell editing is enabled.
Use the formula bar: Select the cell and click in the formula bar to edit its entry in the area above the worksheet.
Type a replacement: Select the cell and start typing when you intend to replace the entire contents rather than preserve part of them.
Use the ribbon: The Home tab includes the Find & Select menu, but it is not a dedicated replacement for F2. For ordinary cell editing, the keyboard shortcut, formula bar, and double-click are more direct.

To control whether double-clicking edits a cell directly, go to File > Options > Advanced and look under Editing options for Allow editing directly in cells. If this option is cleared, double-clicking does not enter the cell’s text in the same way; the formula bar remains an alternative. F2 remains the familiar keyboard shortcut for editing the selected cell. This setting is useful when accidental double-clicks cause unwanted edits, although changing it also changes the normal in-cell editing behavior.

Common problems and what to check

If F2 appears not to work, first confirm that a worksheet cell is selected and that the workbook is not in a state that prevents editing. A protected worksheet may restrict changes to locked cells. Check the Review tab for the sheet protection controls, or ask the workbook owner whether editing is allowed. A cell can also be part of a table, merged range, or other structure where the intended change requires attention to the surrounding layout.

If F2 triggers a hardware function, try Fn+F2. If Excel’s status bar or interface indicates that you are already editing a cell, you may have entered edit mode by double-clicking or clicking the formula bar; pressing F2 again is not necessarily the action you need. Finish with Enter or cancel with Esc, then select the intended cell and try again.

If typing replaces the whole value unexpectedly, the cell was probably selected but not in edit mode. Undo immediately with Ctrl+Z if the replacement was just made, then select the cell and press F2 before changing only part of its contents. If Excel will not accept the edit, check for sheet protection, a read-only workbook, or a prompt indicating that the file must be saved or enabled for editing. Avoid changing workbook protection or file permissions unless you are authorized to do so.

Windows, Mac, and Excel for the web

This article uses the Windows desktop version of Excel for Microsoft 365 as its default. On a Mac, the shortcut to edit the active cell is generally Control+U. Mac keyboards and system settings can affect how function keys behave, so F2 may also require the Fn key if you are using a keyboard or configuration that assigns another function to the top row. The formula bar and double-click are alternatives on Mac as well.

Excel for the web runs in a browser, so keyboard shortcuts can interact with browser or operating-system commands. F2 is commonly used to edit a selected cell there too, but if the shortcut is intercepted or does not behave as expected, click the formula bar or double-click the cell. The web interface and available options can differ from the Windows desktop app, and a workbook opened in a browser may also be read-only or restricted by its sharing permissions. Check that you have edit access before troubleshooting the shortcut itself.

Keyboard shortcuts can also vary with keyboard layout, accessibility settings, remote-desktop software, and laptop function-key settings. The reliable principle is to select the cell, enter editing mode with the shortcut available in your version, make the change, and commit or cancel it deliberately. If a shortcut is unavailable, editing through the formula bar works without relying on the same key combination.

Frequently Asked Questions

What is the shortcut to edit a cell in Excel?

In Excel for Microsoft 365 on Windows, select the cell and press F2. On a Mac, Control+U is the usual shortcut. A laptop may require Fn with a function key if its top-row keys are assigned to hardware controls.

How do I edit a cell without deleting its existing contents?

Select the cell and press F2 before typing. This lets you move the insertion point and change part of the entry. Typing while the cell is merely selected normally replaces the entire contents.

How do I cancel an edit in Excel?

Press Esc before committing the edit to discard the changes made during that editing session. If you already pressed Enter, use Ctrl+Z on Windows to undo the committed change, as long as it is still the most recent action you want to reverse.

Why does F2 change my laptop’s volume or brightness?

Your keyboard may assign media or hardware actions to the function-key row. Try Fn+F2, or adjust the keyboard’s function-key setting. The required key combination depends on the device and its configuration.

Can I edit a cell from the formula bar instead?

Yes. Select the cell, then click in the formula bar and make the change there. This can be easier for a long formula or text entry, and it changes the same cell as editing directly in the worksheet.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.