Excel Double-Click Cell Shortcut: Use F2 to Edit Cells

In Excel for Microsoft 365 on Windows, double-click a cell to edit it in place; the keyboard equivalent is to select the cell and press F2. There is no separate keyboard command that performs a literal double-click, but F2 gets you into the cell’s contents without using the mouse.

The shortcut and what it does

Double-clicking a worksheet cell switches Excel from selecting the cell to editing its contents. Pressing F2 while the cell is selected does the same basic job: Excel enters Edit mode, and you can change the cell’s existing value or formula. The shortcut applies to the active cell, meaning the cell with the selection outline.

If a laptop’s function keys control brightness, volume, or other hardware features, you may need to press Fn+F2 instead. The exact Fn behavior depends on the computer’s keyboard settings. If F2 triggers a hardware action, try Fn+F2 or check whether the keyboard has a function-lock setting.

F2 is especially handy when you are working through a column of cells and want to correct one entry without reaching for the mouse. It also makes it easy to inspect or adjust a formula directly in its cell.

How to edit a cell with F2

To make a change using the keyboard, follow these steps:

Use the arrow keys, or click once, to select the cell.
Press F2. Excel enters Edit mode, and the insertion point appears in the cell’s contents.
Move the insertion point with the arrow keys, then type, delete, or replace the text you need to change.
Press Enter to keep the edit, or press Esc to cancel it and restore the cell’s previous contents.

For example, if a cell contains the text West Region and you need to change it to West Division, select the cell and press F2. Move the cursor to the end, remove Region, type Division, and press Enter. You have edited the existing entry rather than replacing the entire cell.

In a formula cell, F2 lets you work with the formula itself. For instance, if the selected cell contains a SUM formula, you can use the arrow keys to move through the formula text and correct a reference. Take care when navigating: Excel may interpret arrow-key movement as a request to insert a reference to another cell, depending on where the cursor is in the formula.

Where the cursor goes in Edit mode

F2 typically places the insertion point at the end of the cell’s existing contents. Double-clicking can put the insertion point closer to where you clicked, which is useful when you want to edit a particular word or part of a number. Either way, you are editing the contents of the selected cell, not typing into a different cell.

Excel’s status bar can help confirm what is happening. When a cell is selected, Excel is in a ready state; after F2 or a double-click, it enters Edit mode. In Edit mode, the arrow keys move the text cursor within the cell instead of moving the selection to a neighboring cell. That difference is a useful clue if the keyboard seems to behave unexpectedly.

A cell’s displayed value may not be the same as its underlying contents. A date, for example, can display in a short date format while Excel stores it as a date value. Editing the cell changes its contents; changing how the value appears is usually a formatting task. F2 is for editing, not for opening the number-format controls.

Keep, cancel, or move on after an edit

Enter commits an edit and ordinarily moves the selection down one cell. If you want to commit the edit and move in a different direction, use Tab to move right or Shift+Enter to move up. Pressing Esc while editing cancels the current, uncommitted change. These choices matter when making several corrections in sequence because they determine where Excel places the active selection next.

To add a new line inside a cell while editing, press Alt+Enter on Windows. This inserts a line break within the same cell; it does not commit the edit. The text may not appear on multiple lines until Wrap Text is enabled or the row is tall enough to show it. Use Enter by itself when you want to finish the edit.

Be aware that once you press Enter, the change is committed. You can usually undo a recent worksheet edit with Ctrl+Z, but Esc is the direct way to abandon a change before committing it. In a shared or automatically saved workbook, undo history and the effects on other users may depend on the workbook and Excel environment, so check important changes rather than assuming they were discarded.

Double-click actions that are not cell editing

Excel uses double-clicks for several jobs, and the target matters. Double-clicking inside a cell edits its contents, but double-clicking the small square at the lower-right corner of a selected cell—the fill handle—can copy a value or formula down alongside neighboring data. That is a fill operation, not the keyboard equivalent of F2.

Other common double-click actions include:

Double-clicking a worksheet tab can let you rename the sheet.
Double-clicking the boundary between column headings can AutoFit a column’s width to its contents.
Double-clicking the boundary between row headings can AutoFit a row’s height.
Double-clicking a cell itself enters Edit mode, unless workbook settings or the current interface change how direct editing works.

These actions are easy to confuse because they all begin with two mouse clicks. If the goal is to change a cell’s text or formula, first make sure the pointer is over the cell rather than its fill handle, a row or column boundary, or a worksheet tab.

Windows, Mac, and Excel for the web

This article’s main shortcut is for Excel for Microsoft 365 on Windows: select a cell and press F2. On some Windows laptops, use Fn+F2 if the function row is assigned to hardware controls. If you prefer the mouse, double-click the cell itself.

In Excel for Mac, Control+U is the standard keyboard shortcut to edit the active cell. Mac keyboards and settings differ, so if that combination does not behave as expected, use a double-click or check Excel’s current keyboard-shortcut help. Function-key behavior can also depend on whether macOS is using the keys for system functions.

In Excel for the web, double-clicking a cell is a straightforward way to edit in place. Keyboard shortcuts can be affected by the browser and its own key assignments, so F2 may not behave identically in every browser or setup. If the shortcut does not start editing, double-click the cell or use the formula bar to make the change.

Common problems and fixes

F2 changes the screen brightness or volume: Try Fn+F2, or adjust the laptop’s function-key behavior.
F2 does not let you type inside the cell: Confirm that the worksheet is not protected in a way that prevents editing and that you selected the intended cell. You can also try double-clicking or editing in the formula bar.
The arrow keys move between cells instead of through the text: You may still be in cell-selection mode. Press F2 again or double-click the cell to enter Edit mode.
The edit appears in the formula bar rather than inside the grid: Excel may be configured not to allow direct editing in cells. In Windows desktop Excel, check File > Options > Advanced and the Allow editing directly in cells setting. The formula bar can still be used to edit the selected cell.
The double-click does not edit the cell: Check that you double-clicked the cell body, not the fill handle or a row or column boundary. A slow or inconsistent double-click can also be treated as two separate clicks.

If a cell’s contents are long, the formula bar can be easier to work in than the narrow worksheet grid. Select the cell and click in the formula bar to edit there. This changes the same selected cell; it does not create a second copy of the entry.

Frequently Asked Questions

What is the Excel keyboard shortcut for double-clicking a cell?
There is no keyboard shortcut that literally simulates a double-click. To edit the selected cell, press F2 in Excel for Windows. On Mac, use Control+U.

Does F2 edit the cell or replace its contents?
F2 enters Edit mode so you can change the existing contents. It does not replace them by itself. Typing a character before entering Edit mode, by contrast, can replace the selected cell’s contents.

How do I stop editing a cell without saving the change?
Press Esc before committing the edit. Enter commits it, while Esc cancels the current uncommitted change.

Why does double-clicking the cell fill down instead?
You may be double-clicking the fill handle, the small square at the bottom-right corner of the selection. Double-click the cell itself to edit its contents.

Can I edit a cell without using F2 or double-clicking?
Yes. Select the cell and edit its contents in the formula bar. You can also start typing to replace the current contents, but that is different from editing the existing text in place.

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.