Excel keyboard shortcuts to move around a sheet
Last updated
Hold Ctrl and press an arrow key to jump to the edge of the data in that direction: Ctrl + ↓ goes from the top of a column to its last filled cell, Ctrl + → to the end of a row. Ctrl + End goes to the last used cell of the sheet and Ctrl + Home back to A1. On a Mac, use ⌘ + arrow.
The navigation shortcuts
Ctrl + ↑ ↓ ← → · Ctrl + End · Ctrl + Home
- Ctrl + ↓ / Ctrl + ↑
- Jumps down or up to the last filled cell before an empty one. From an empty cell, it jumps to the next filled cell; with nothing below, to the last row of the sheet, row 1,048,576.
- Ctrl + → / Ctrl + ←
- The same along a row: to the last filled column of the data, or back to the first. Past the data, it stops at the edge of the sheet, column XFD.
- Ctrl + End
- Goes to the last used cell: the bottom row and the rightmost column that hold anything. That corner cell itself can be empty.
- Ctrl + Home
- Goes back to A1, wherever you are in the sheet.
- On a Mac
- ⌘ + arrow works like Ctrl + arrow. On a keyboard without Home and End keys, press Fn + Ctrl + ← for Ctrl + Home and Fn + Ctrl + → for Ctrl + End.
Practise moving with the keyboard here
Click the grid so it has the focus, then press the shortcut as you would in Excel. The sheet checks where the active cell lands.
Jump to the bottom of the data
This sheet holds 24 orders, and real sheets often hold thousands. Instead of pressing ↓ again and again, press Ctrl + ↓ to jump from A1 straight to the last order.
| Order | Region | Product | Qty | Unit price ($) | Total ($) |
| 1001 | North | Notebook | 1 | 2.50 | 2.50 |
| 1002 | South | Desk lamp | 8 | 32.00 | 256.00 |
| 1003 | East | Pen box | 6 | 6.90 | 41.40 |
| 1004 | West | Paper ream | 4 | 5.75 | 23.00 |
| 1005 | North | Stapler | 2 | 14.00 | 28.00 |
| 1006 | South | Notebook | 9 | 2.50 | 22.50 |
| 1007 | East | Desk lamp | 7 | 32.00 | 224.00 |
| 1008 | West | Pen box | 5 | 6.90 | 34.50 |
| 1009 | North | Paper ream | 3 | 5.75 | 17.25 |
| 1010 | South | Stapler | 1 | 14.00 | 14.00 |
| 1011 | East | Notebook | 8 | 2.50 | 20.00 |
| 1012 | West | Desk lamp | 6 | 32.00 | 192.00 |
| 1013 | North | Pen box | 4 | 6.90 | 27.60 |
| 1014 | South | Paper ream | 2 | 5.75 | 11.50 |
| 1015 | East | Stapler | 9 | 14.00 | 126.00 |
| 1016 | West | Notebook | 7 | 2.50 | 17.50 |
| 1017 | North | Desk lamp | 5 | 32.00 | 160.00 |
| 1018 | South | Pen box | 3 | 6.90 | 20.70 |
| 1019 | East | Paper ream | 1 | 5.75 | 5.75 |
| 1020 | West | Stapler | 8 | 14.00 | 112.00 |
| 1021 | North | Notebook | 6 | 2.50 | 15.00 |
| 1022 | South | Desk lamp | 4 | 32.00 | 128.00 |
| 1023 | East | Pen box | 2 | 6.90 | 13.80 |
| 1024 | West | Paper ream | 9 | 5.75 | 51.75 |
How to move around a sheet, step by step
- Click a cell inside your data, for example
A1at the top of a list. - Hold Ctrl and press ↓ once: you land on the last filled cell of the column.
- Press Ctrl + → to reach the last column of that row, or Ctrl + ↑ and Ctrl + ← to come back.
- Press Ctrl + End to see where the data ends, then Ctrl + Home to go back to A1.
Navigation examples
Last row of a list
Ctrl + ↓
From A1 in a list of 24 orders, one key press lands on A25, the last order. It’s still one key press with 24,000 rows.
Total at the end of a row
Ctrl + →
From the order number in A12, jump straight to its total in F12 instead of scrolling sideways.
Spot a missing value
Ctrl + ↓
In a column with a gap, Ctrl + ↓ stops on the cell right above the empty one. If it stops before the end of the list, something is missing below.
Back to the header
Ctrl + ↑
From anywhere in a column of data, Ctrl + ↑ goes back up to the first cell of the block, usually the header.
How big is this sheet?
Ctrl + End
Lands on the bottom-right corner of the used range. Its address in the Name Box tells you how many rows and columns the sheet uses.
Common problems and how to fix them
| Problem | Cause | Fix |
|---|---|---|
| Ctrl + ↓ stops halfway down | There’s an empty cell in the column: Ctrl + arrow stops at the edge of each block of data. | Press Ctrl + ↓ again to jump over the gap to the next block, or fill in the missing value. |
| Ctrl + ↓ goes to row 1,048,576 | The cells below the active cell are all empty, so there’s no data to stop at. | Press Ctrl + ↑ to come back to the last filled cell, and start from a column that holds data. |
| Ctrl + End lands beyond the data | Excel remembers cells that once held data or formatting, even after you cleared them. | Delete the extra rows and columns (not just their contents) and save the file: the last cell is reset. |
| Ctrl + Home doesn’t go to A1 | Panes are frozen: Ctrl + Home goes to the first cell below and to the right of the frozen rows and columns. | That’s by design, so the headers stay visible. Use the arrow keys to reach A1, or unfreeze the panes. |
| On a Mac, Ctrl + arrow switches desktops | macOS uses Control + arrow keys for Mission Control and Spaces. | Use ⌘ + arrow in Excel instead. |
Ctrl + arrow or Ctrl + End?
Ctrl + arrow follows the data from the active cell and stops at the first gap, so it answers “where does this column or row end?”. Ctrl + End ignores gaps and goes to the corner of everything the sheet uses, so it answers “how big is this sheet?”. On a clean list both lead to the same last row. When they don’t, there’s a gap or leftover data worth a look.
Frequently asked questions
What’s the shortcut to go to the last row in Excel?
Click a cell in a column that holds data and press Ctrl + ↓ (⌘ + ↓ on a Mac). To reach the last used row and column of the whole sheet, press Ctrl + End.
How do I go back to cell A1 quickly?
Ctrl + Home takes you to A1 from anywhere. On a Mac keyboard without a Home key, press Fn + Ctrl + ←.
Why does Ctrl + arrow jump past a cell that looks empty?
Ctrl + arrow runs over every filled cell to the edge of the block. A cell that holds a space, or a formula that returns "", counts as filled even though it looks empty.
Do these shortcuts work on a Mac?
Yes, with ⌘ instead of Ctrl for the arrows: ⌘ + ↓, ⌘ + → and so on. For Ctrl + Home and Ctrl + End, press Fn + Ctrl + ← and Fn + Ctrl + → on keyboards without those keys.