How to Enter a Cell in Excel with Keyboard
To enter a cell in Excel with the keyboard, move to the cell with the arrow keys (or type its address in the Name Box) and press F2 to start editing inside it. To put a new line within the same cell, press Alt + Enter on Windows or Control + Option + Return on a Mac instead of the plain Enter key.
That two-line summary covers the two things people usually mean by “enter a cell”: (1) getting into a cell to edit what is already there, and (2) typing a line break so text continues on a new line inside the cell. Below, every variation is covered step by step for both Windows and Mac, plus the keyboard navigation, edge cases, and fixes for when these keys do not behave the way you expect.
What “enter a cell” actually means
The phrase is used three different ways, and the right keystroke depends on which one you want:
| Goal | Windows | Mac |
|---|---|---|
| Move to a cell (select it) | Arrow keys, or Name Box | Arrow keys, or Name Box |
| Get inside a cell to edit | F2 | F2 (or Control + U) |
| Start a new line inside a cell | Alt + Enter | Control + Option + Return |
| Confirm and exit the cell | Enter | Return |
If you only remember one shortcut, make it F2 — it is the universal “edit this cell” key and behaves identically across Excel versions.
How to navigate to a cell with the keyboard
Before you can enter a cell, you have to land on it. You never need the mouse for this.
Use the arrow keys
The arrow keys move the active selection one cell at a time — up, down, left, and right. This is the simplest way to move from cell to cell without lifting your hands from the keyboard.
Jump straight to any cell with the Name Box
The Name Box sits at the far left of the formula bar and shows the address of the current cell (for example, B7).
- Press Ctrl + G (Windows) or Control + G (Mac) to open the Go To dialog, or click into the Name Box.
- Type the cell address you want, such as
D42. - Press Enter. The selection jumps directly to that cell.
The Name Box is the fastest way to cross a large sheet — far quicker than scrolling. It also accepts named ranges, so typing a range name and pressing Enter selects the whole range.
Move across data quickly
| Shortcut | Action |
|---|---|
| Ctrl + Arrow (Win) / ⌘ + Arrow (Mac) | Jump to the edge of the current data region |
| Home | Go to column A in the current row |
| Ctrl + Home | Go to cell A1 |
| Ctrl + End | Go to the last used cell on the sheet |
| Page Down / Page Up | Move one screen down or up |
| Tab | Move one cell to the right |
| Shift + Tab | Move one cell to the left |
The Tab key is especially useful when filling a row of data — press Tab after each entry and Excel walks you rightward, then Enter drops you back to the start of the next row.
How to enter (edit) a cell with the keyboard
Selecting a cell is not the same as entering it. When a cell is merely selected, anything you type replaces its contents. To get inside and edit what is already there, you need edit mode.
Method 1: Press F2 (the standard way)
- Use the arrow keys or Name Box to select the cell.
- Press F2. The cursor appears at the end of the existing content and Excel switches to Edit mode (you will see “Edit” in the bottom-left status bar).
- Use the Left/Right arrow keys, Home, and End to move the cursor within the text.
- Type your changes, then press Enter to confirm.
F2 is the cornerstone shortcut for editing a cell using the keyboard and works on Windows and Mac alike.
Tip: Press F2 a second time while editing a formula to toggle between Edit mode (arrow keys move the text cursor) and Enter/Point mode (arrow keys select cell references).
Method 2: Just start typing (to overwrite)
If you want to replace the entire contents rather than edit them, do not press F2. Simply select the cell and start typing. The old value disappears and your new text takes its place. Press Enter when done. This is the quickest path when you are entering fresh data rather than editing existing cells.
Method 3: Edit from the formula bar
You can also press F2 and then move your edit point into the formula bar, which gives you more room to read long formulas or wrapped text. The keyboard shortcut to jump focus there is not fixed, but once you are in Edit mode the formula bar updates live as you type.
On a Mac
Every method above works on macOS. The one extra option Mac users have is Control + U, which also toggles cell editing — handy if your keyboard’s F2 is mapped to a hardware function (brightness, volume) and requires the fn key. On many Macs you must press fn + F2 to send a true F2 keystroke.
How to enter a new line within a cell
This is the single most-searched version of the question: how to press “enter” inside a cell without jumping to the next cell. By default, Enter confirms the entry and moves down — it does not create a line break. To force a line break inside the same cell:
Windows
- Double-click the cell or press F2 to enter edit mode.
- Place the cursor where you want the break.
- Press Alt + Enter. A new line begins inside the same cell.
- Press Enter when finished to commit the entry.
Mac
- Enter edit mode with F2 (or double-click).
- Position the cursor.
- Press Control + Option + Return (some Excel for Mac builds also accept ⌘ + Option + Return).
- Press Return to finish.
This is how you create stacked text, addresses, or bullet-style lists in one cell. For a deeper walkthrough see how to start a new line in an Excel cell, creating a new line in a cell, and entering a new line in Excel. When you add manual line breaks, Excel automatically turns on Wrap Text for that cell so the lines display; if they do not, turn on Wrap Text from the Home tab. Stacking text this way is also the basis for building readable paragraphs inside Excel cells.
Entering data into a range fast
When you are filling many cells, a few habits keep your hands on the keyboard:
- Tab then Enter: Tab across a row entering values, then press Enter to wrap to the first column of the next row automatically.
- Fill a selection at once: Select a range, type a value, and press Ctrl + Enter (Windows) or Control + Return (Mac) — the value drops into every selected cell simultaneously.
- Repeat the cell above: Press Ctrl + D to copy the cell directly above into the current cell, or Ctrl + R to copy from the left.
- Use the fill handle equivalent: For patterned data, the fill handle extends a series, though that one typically needs the mouse or the Fill command on the ribbon.
Selecting cells with the keyboard
Holding Shift while you move turns navigation into selection:
- Shift + Arrow extends the selection one cell at a time.
- Ctrl + Shift + Arrow (Win) / ⌘ + Shift + Arrow (Mac) extends to the edge of the data.
- Shift + Space selects the entire row; Ctrl + Space selects the entire column.
For more, see how to select cells in Excel and, when you overshoot, how to deselect cells. Note that merged cells can interrupt arrow-key navigation, so keep that in mind on heavily formatted sheets.
Troubleshooting: when the keys don’t work
F2 does something else (brightness/volume)
On most laptops the F-keys double as media keys. Press fn + F2 to send a real F2, or flip the “Use F1, F2, etc. as standard function keys” setting in your system keyboard preferences.
Alt + Enter just confirms the cell
You must be in Edit mode first. If a cell is only selected (not being edited), some setups treat Alt + Enter differently. Press F2 first, then Alt + Enter. On a Mac, remember the combination is Control + Option + Return, not Alt + Enter.
Enter moves the wrong direction
By default Enter moves down, but this is configurable. Go to File → Options → Advanced (Windows) or Excel → Preferences → Edit (Mac) and change the “After pressing Enter, move selection” direction, or uncheck it to stay put.
Typing replaces my whole cell instead of editing it
That is expected behavior when the cell is selected but not in edit mode. Press F2 before typing to edit in place rather than overwrite.
The cursor won’t move inside a formula
While editing a formula, the arrow keys may be inserting cell references instead of moving the cursor. Press F2 to switch from Point mode back to Edit mode, and the arrows will move the text cursor again.
Quick reference: the shortcuts that matter
| Action | Windows | Mac |
|---|---|---|
| Edit the selected cell | F2 | F2 / Control + U |
| New line inside a cell | Alt + Enter | Control + Option + Return |
| Confirm and move down | Enter | Return |
| Confirm and stay put | Ctrl + Enter | Control + Return |
| Fill whole selection | Ctrl + Enter | Control + Return |
| Cancel the edit | Esc | Esc |
| Jump to a cell address | Ctrl + G | Control + G |
Frequently Asked Questions
How do I enter in an Excel cell without going to the next cell?
Press Alt + Enter (Windows) or Control + Option + Return (Mac) while you are editing the cell. This inserts a line break inside the same cell instead of confirming the entry and moving to the cell below. The plain Enter/Return key always commits the entry and jumps to the next cell.
How do I enter within a cell in Excel?
First get into edit mode by pressing F2 (or double-clicking the cell). Once you see “Edit” in the status bar, the cursor sits inside the cell and you can type, use the arrow keys to reposition, or press Alt + Enter / Control + Option + Return to add a new line. Press Enter when you are finished. See editing a cell with the keyboard for the full method.
How do I go into a cell with the keyboard?
Navigate to the cell using the arrow keys or by typing its address in the Name Box and pressing Enter, then press F2 to open the cell for editing. F2 is the standard “enter this cell” shortcut on both Windows and Mac.
Why does pressing Enter move me down instead of into the cell?
Because Enter is the confirm key, not the edit key. To get inside a cell, press F2 instead. If you want to change which direction Enter moves afterward, adjust it under File → Options → Advanced (Windows) or Excel → Preferences → Edit (Mac).
What is the Mac equivalent of Alt + Enter in Excel?
On a Mac, use Control + Option + Return to add a line break inside a cell. Some Excel for Mac versions also accept ⌘ (Command) + Option + Return. Both do the same thing as Alt + Enter on Windows.
Do I need the fn key to use F2 on a Mac?
Often yes. On many Mac keyboards the function-key row controls brightness and volume by default, so you press fn + F2 to send a true F2. You can change this in System Settings → Keyboard if you would rather use the F-keys directly, or use Control + U as an alternative way to enter edit mode.
