Move Around Excel With the Keyboard: The Complete Guide

Good Excel keyboard navigation comes down to a few keys: the arrow keys, Enter and Tab while you type, Ctrl+Arrow to jump to the edge of your data, and Ctrl+Home and Ctrl+End for the corners. This guide gives every shortcut for Windows and for Mac, including the fn key you need on most Mac laptops. It is written for beginners and for anyone who still scrolls with the mouse.

Excel keyboard navigation cheat sheet#

These are the movement keys worth learning first. On a Mac, Excel uses Control (⌃) for some shortcuts and Command (⌘) for others, so check the right column carefully.

How to move with Enter, Tab and the arrow keys#

Each arrow key moves one cell. When you type data, Enter confirms and moves down, and Tab confirms and moves right. Add Shift to go the other way: Shift+Enter moves up and Shift+Tab moves left.

Tab and Enter work well together. Type a value in A2, press Tab, type in B2, press Tab, type in C2, then press Enter. Excel goes back to A3, the start of the next row, ready for the next record. That makes typing a list row by row much faster.

Be careful with Shift and the arrow keys: Shift+Arrow selects instead of moving. Shift with Enter or Tab still moves. The select ranges fast guide explains selection.

How to jump to the edge of your data with Ctrl+Arrow#

Hold Ctrl (⌘ on a Mac) and press an arrow key to jump to the last filled cell in that direction. On a list of 18 orders starting in A1, Ctrl+Down jumps from A1 to A19. Ctrl+Right then jumps to D19, the right edge. Ctrl+Up and Ctrl+Left take you back to A1.

The jump stops just before an empty cell. If someone deleted the customer in B10, Ctrl+Down from B1 stops at B9. That makes the jump a quick way to find gaps in a column. Fill the gap, press Ctrl+Down again, and you go all the way to the last row.

How to jump to A1 and the last cell#

Ctrl+Home goes to A1. Ctrl+End goes to the last used cell: the lowest used row in the rightmost used column. On a stock list in A1:D15, Ctrl+End lands on D15.

On a Mac, use Control, not Command: ⌃Home and ⌃End. Most Mac laptops have no Home or End key, so hold fn as well: ⌃fn← for A1 and ⌃fn→ for the last cell. Some Windows laptops also put Home and End on other keys, so you may need Fn there too.

One thing to know: "last used" can include cells that are now empty. If you once typed or formatted something in row 500 and then cleared it, Ctrl+End may still go to row 500. Delete those unused rows and save the file, and Excel usually resets the last cell.

How to move a screen at a time and between sheets#

Page Down and Page Up move one screen down or up. On a Mac laptop, press fn↓ and fn↑. Home goes to column A in the current row (fn← on a Mac laptop).

To switch worksheets, press Ctrl+Page Down for the next sheet and Ctrl+Page Up for the previous one. On a Mac, ⌥→ and ⌥← (Option and the arrow keys) also work, which is easier on a laptop.

How to go to any cell by typing its name#

To go straight to a cell, type its name. Click the Name Box (above column A), type D12 and press Enter. You can type a range such as C2:C15 to select it, too. See six Name Box tricks for more.

Ctrl+G or F5 (⌃G on a Mac) opens the Go To box, which does the same thing. Type the cell, such as D12, and press Enter.

Why the Mac shortcuts are different#

Excel for Mac uses ⌘ for many shortcuts that use Ctrl on Windows, like ⌘+Arrow and ⌘C. But some navigation shortcuts keep Control, like ⌃Home and ⌃End. On top of that, Mac laptops hide Home, End, Page Up and Page Down behind the fn key, and the top-row F keys often control brightness and volume unless you hold fn.

If a shortcut does nothing on your Mac, try it with Control instead of Command, then try adding fn. The Excel on Mac vs Windows guide lists the other differences.

Common keyboard navigation problems#

When the keys don't do what you expect, one of these is usually the cause:

• Arrow keys scroll the sheet but the cell stays put. Scroll Lock is on. The status bar says Scroll Lock. Press the Scroll Lock key to turn it off.
• Arrow keys move inside the cell text. You are in edit mode (after F2 or a double-click). Press Enter to confirm or Esc to cancel, then the arrows move between cells again.
• Ctrl+Arrow jumps to row 1,048,576. The column is empty below the active cell, so Excel jumps to the bottom of the sheet. Press Ctrl+Up to come back.
• "End Mode" in the status bar. On Windows, pressing End on its own turns on End mode, and the next arrow key jumps like Ctrl+Arrow. Press End again to turn it off.

Moving without the mouse is one of the Excel shortcuts interviewers notice when you work in front of them.

Practise moving around Excel#

You learn navigation by doing it. Open the move around the sheet lesson to practise Enter, Tab, Ctrl+Home, Ctrl+End and the Name Box in a real stock list. Then try the jump to the edge of your data lesson to find a gap with Ctrl+Arrow. Once you can get anywhere fast, write your first Excel formula and learn to fill it down with Ctrl+D. When formulas get longer, Excel's order of operations explains which part Excel calculates first.