Excel Shortcut Key to Go to the Last Row in a Sheet

In Excel for Microsoft 365 on Windows, press Ctrl+Down Arrow to jump to the edge of the current data region in that column. If you mean the worksheet’s absolute last row, row 1,048,576, use Ctrl+G, type A1048576, and press Enter; Ctrl+Down does not always mean “go to the final worksheet row.”

The shortcut for the bottom of your data

Ctrl+Down Arrow is usually the quickest way to reach the bottom of a continuous block of data. Click a cell in the column you want to navigate, then press and hold Ctrl while pressing the Down Arrow. Excel moves to the edge of that block, which is often the last populated cell in the column. For example, if a list occupies A1:A250 with no blank cells, starting in A15 and pressing Ctrl+Down takes you to A250.

The shortcut follows the data around the active cell rather than searching the whole worksheet for a single, universal last row. That distinction matters if your worksheet has blank rows, separate tables, or data in other columns. The cell you land on depends on where you started and how the cells below it are populated.

To move to the bottom edge of a data block, use Ctrl+Down Arrow.
To select cells from your current position down to that edge, use Ctrl+Shift+Down Arrow.
To jump to the worksheet’s final row, use Go To and enter a cell address in row 1,048,576.
To reach the last cell Excel considers used, use Ctrl+End, but know that this is a different destination.

How Ctrl+Down behaves around blanks

Excel treats a contiguous run of occupied cells as a data region. A blank cell can divide one region from another, so pressing Ctrl+Down from inside a list may stop at the last occupied cell before the first blank. Pressing Ctrl+Down again can move across the blank area to the next occupied region, or to the bottom of the worksheet if there is no further data in that direction.

Consider a column with values in A1:A20, a blank A21, and more values in A22:A40. Starting at A5, Ctrl+Down takes you to A20, the edge of the first block. Press it again and Excel can jump to A22, the next block. It does not treat the two groups as one uninterrupted list just because both contain values.

Starting from a blank cell can also produce a different-looking jump: Excel may move to the next occupied cell or to the boundary of the blank region. If you land somewhere unexpected, look at the cells between your starting point and destination. A blank, a formula returning an empty string, or a gap in the chosen column can affect how navigation appears. For dependable movement, start inside the data block whose bottom you want.

Last row of data versus last row of the worksheet

People use “last row” to mean two different things. The last row of data is the final row containing a record in a particular list or table. Its number varies from workbook to workbook. The last row of the worksheet is a fixed limit in modern Excel: row 1,048,576. Ctrl+Down is designed for navigating data regions; it is not a reliable way to identify the last record across an entire sheet.

When you need the absolute worksheet boundary, Go To is direct. On Windows, press Ctrl+G (or F5), enter A1048576, and press Enter. Excel selects cell A1048576. You can use another column letter if that is more useful, such as D1048576. This goes to a cell on the final row; it does not add data or change the worksheet.

You can also click the Name Box, the small address field to the left of the formula bar, type A1048576, and press Enter. That is useful when keyboard shortcuts are being intercepted or when you prefer to see the destination address before moving. If you want to reach the end of the data rather than the worksheet boundary, use Ctrl+Down from within the relevant column instead.

What Ctrl+End does—and why it can mislead

Ctrl+End moves to the last cell Excel regards as used: generally the intersection of the lowest used row and the rightmost used column on that worksheet. It is not the same as moving to the last nonblank cell in the column where you are working, and it is not a command for the worksheet’s final row.

For example, suppose a list ends at B250, but a note or formatting exists in column H on row 600. Ctrl+End may take you to H600, even though your main list ends at row 250. Formatting applied far below or to the right of visible data can make the used area appear larger than expected. This is why Ctrl+End can seem to overshoot when you are trying to find the last record.

If Ctrl+End lands far beyond the data, inspect the area around its destination for old entries or formatting. Deleting genuinely unnecessary rows or columns and saving the workbook may help Excel update its used range, although it is wise to preserve anything that might still be needed. Do not use Ctrl+End as a substitute for checking the relevant data column.

Choosing the right method for a common task

The best shortcut depends on what you intend to do after navigating. For a quick review of the bottom of a list, Ctrl+Down is efficient. For selecting the remaining cells in a block, Ctrl+Shift+Down Arrow extends the selection as it moves. For an exact worksheet address, Go To or the Name Box is clearer. For a workbook’s used-area boundary, Ctrl+End provides a separate kind of navigation.

Find the last entry in a continuous column: click a filled cell in that column and press Ctrl+Down Arrow.
Select from the current cell to the block’s bottom: press Ctrl+Shift+Down Arrow. Check the highlighted range before editing or deleting it.
Go to the final worksheet row: press Ctrl+G, type A1048576, and press Enter.
Inspect Excel’s used area: press Ctrl+End, then compare the selected address with the actual extent of your data.

A practical example: if a sales list has headers in row 1 and records through row 873 in column A, click a record in column A and use Ctrl+Down to reach the data block’s lower edge. If the column contains a blank at row 400, the first jump may stop above that gap. If you only need to inspect the bottom of the worksheet, enter A1048576 through Go To instead.

Blank rows, formulas, and Excel tables

A blank row inside what looks like a list is one of the most common reasons Ctrl+Down stops earlier than expected. Before using the shortcut to determine the last record, check whether the relevant column has uninterrupted values. A row may look blank because its text is white, its value is hidden by a number format, or a formula displays an empty string; these cases can make the visible layout differ from what is actually stored.

Excel tables can make growing lists easier to manage, but Ctrl+Down still navigates according to the cells and region around the active position. A table does not make the shortcut a universal “last record” command for every column. If table columns have different blanks or the active cell is outside the table, the jump may not land where you expect. Click a populated cell in the specific table column first, and use the table’s visible final record as a cross-check.

For a list with gaps, decide what “last” means before navigating. You might mean the final populated cell in one column, the final row where every required field is present, or the lowest row containing anything anywhere on the sheet. Those are different checks. Ctrl+Down answers a local navigation question; it does not reconcile inconsistent records across several columns.

Windows, Mac, and Excel for the web

This guidance is for Excel for Microsoft 365 on Windows. In Excel for Mac, Command+Down Arrow is commonly used to move to the edge of the data region, while Windows uses Ctrl+Down Arrow. Mac keyboard layouts, macOS settings, and Excel versions can affect key behavior, so if the shortcut is intercepted, use the Name Box to enter an address. To go to the absolute last row on either desktop platform, use the Go To command or Name Box with A1048576.

In Excel for the web, Ctrl+Down Arrow also serves as a navigation shortcut in the grid, though browser or operating-system shortcuts can sometimes interfere. The exact behavior may depend on the browser and whether the worksheet is in cell-editing mode. If a key combination does not move the selection, click a cell rather than editing its contents, then try again or use the Name Box or Go To option available in the interface.

Common problems and quick checks

If Ctrl+Down seems to stop too early, first check for a blank in the column. If it jumps much farther than expected, check whether the active cell was blank or whether a later data block exists. Also confirm that Excel has focus: a cursor inside a cell’s formula or text is in edit mode, where arrow keys move within the content instead of moving the active cell through the worksheet.

Press Esc or Enter to leave cell-editing mode, then try the shortcut again.
Verify that you started in the column whose data boundary you want.
Look for blank cells or separate blocks between the starting cell and the destination.
Use Ctrl+G and an exact address when you need the worksheet boundary, not the data edge.
Use Ctrl+End only when you want Excel’s used-area endpoint, not the last record in a particular list.

Finally, remember that moving and selecting are different actions. Ctrl+Down changes the active cell; Ctrl+Shift+Down changes the active cell and extends the selection. If you plan to clear or replace values, inspect the selection first so that a gap or an unexpectedly large range does not cause you to alter more cells than intended.

Frequently Asked Questions

What is the Excel shortcut to go to the last row of data?
On Windows, press Ctrl+Down Arrow from a populated cell in the relevant column. It moves to the edge of the current data region, so blank cells can split the list and change where Excel stops.

How do I go to row 1,048,576 in Excel?
Press Ctrl+G, enter A1048576, and press Enter. You can also type that address into the Name Box and press Enter. This selects a cell on the worksheet’s final row.

Does Ctrl+End go to the last row?
No. Ctrl+End goes to the last cell Excel considers used, at the lowest used row and rightmost used column. That cell may be far from your data, and it is not necessarily in row 1,048,576.

How do I select everything down to the last data row?
On Windows, use Ctrl+Shift+Down Arrow from a cell in the list. The selection follows the data-region boundary, so check for blank rows and confirm the highlighted range before making changes.

What is the Mac shortcut for the bottom of a data region?
In Excel for Mac, Command+Down Arrow is commonly used to move to the edge of the current data region. If macOS or your keyboard setup intercepts it, enter a destination in the Name Box or use Go To.

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.