Shortcut to go to the last row, column or cell in Excel
The keys
| Shortcut | Windows | Mac |
|---|---|---|
| Jump to the edge of the dataStops at the last filled cell before a blank, so a gap in the data stops it early. | Ctrl+an arrow key | Command+an arrow key |
| Go to the last used cell on the sheetThe lowest used row of the rightmost used column. On a MacBook without an End key, use Ctrl+Fn+Right. | Ctrl+End | Control+End or Control+Fn+Right arrow |
| Go to the beginning of the sheet (A1)With frozen panes, it goes to the first cell below and right of them. | Ctrl+Home | Control+Home or Control+Fn+Left arrow |
| Select to the edge of the data How to: Shortcut to select an entire row or column in Excel Like Ctrl+Arrow, it stops at a blank cell. | Ctrl+Shift+an arrow key | Shift+Command+an arrow key |
Checked against Microsoft's official lists on . Where Microsoft lists a key for one platform only, the other column says so instead of guessing.
Ctrl+Arrow vs Ctrl+End
Ctrl+Down arrow moves down the current column until the next change between filled and empty. In a column with no gaps, that is the last row of data. Ctrl+Right arrow does the same along a row.
Ctrl+End ignores the active column and goes to the corner Excel thinks the sheet uses: the lowest used row and the rightmost used column. That cell can be empty.
Why Ctrl+Down stops early
A blank cell stops it. Press it again to jump over the gap, or use a column that has no blanks, such as an ID column, to find the true last row. Stopping at a gap is useful too: it shows you exactly where your data has a hole.
Why Ctrl+End goes too far
Excel remembers cells you used and then cleared. Deleting the contents is not enough; delete the extra rows and columns entirely (select them and press Ctrl+-), then save the workbook. Excel resets the last cell when the file is saved.
On a MacBook
- Command+Down arrow and Command+Up arrow jump to the edge, like Ctrl+Arrow on Windows.
- There is no End key, so Ctrl+End becomes Ctrl+Fn+Right arrow and Ctrl+Home becomes Ctrl+Fn+Left arrow.
- Add Shift to any of them to select on the way.
Why a shortcut sometimes does nothing
macOS shortcuts that get there first
Microsoft marks a few Mac shortcuts as clashing with macOS: Shift+F11 and F11 with Show Desktop, and Ctrl+Space with switching input sources. Control with the arrow keys moves between Spaces and opens Mission Control by default too. If macOS reacts instead of Excel, open System Settings > Keyboard > Keyboard Shortcuts and turn the macOS one off.
Excel for the web: the browser takes some keys
In a browser, a few keys belong to the browser first: F1 opens the browser's help, Ctrl+O opens a file, Ctrl+W closes the tab, and F6 moves around the browser. Excel for the web uses Ctrl+F6 instead of F6, Ctrl+Alt+Page Down for the next sheet in Chrome, and Alt+Windows key with a letter for ribbon tabs. To get desktop behavior back, go to Help > Keyboard Shortcuts and select Override browser shortcuts. If the file opened in Viewing mode, editing shortcuts do nothing until you switch to Editing.
Related shortcuts
| Shortcut | Windows | Mac |
|---|---|---|
| End mode: press End, then an arrow key, to jump to the next filled cellNot in Microsoft's Mac list. End mode shows in the status bar until you press the arrow key. | End, an arrow key | —No Mac shortcut in Microsoft's list |
| Extend the selection to the last used cell | Ctrl+Shift+End | Control+Shift+End or Control+Shift+Fn+Right arrow |
| Go to a cell or range (Go To) How to: Shortcut to select visible cells only in Excel Type a reference such as B14 or a range name, then press Enter. | Ctrl+G or F5 | Control+G or F5 |
FAQ
How do I go to the last row in Excel?
Click a cell in a column without gaps and press Ctrl+Down (Cmd+Down on a Mac).
How do I go to the last column?
Ctrl+Right on Windows or Cmd+Right on a Mac, from a row without gaps.
How do I select from here to the last row?
Ctrl+Shift+Down on Windows, Shift+Cmd+Down on a Mac.
Why does Ctrl+End go to an empty cell?
Excel still counts rows and columns you used and cleared. Delete those rows and columns and save the file to reset it.
Related guides
- How to find the last value in a column in ExcelFor the last entry for a specific item, use XLOOKUP with search_mode -1, which searches from the bottom up: =XLOOKUP(G1,B2:B9,C2:C9,,0,-1).
- How to freeze panes in ExcelTo keep the header row visible, go to View > Freeze Panes > Freeze Top Row.
Related functions
In the glossary: Active cellBlank cell