Excel Shortcut to Go to the Last Row With Data Quickly

In Excel for Microsoft 365 on Windows, press Ctrl+Down Arrow from a filled cell to jump to the bottom of that continuous block of data in the same column. If you need to find the worksheet’s last used cell instead, press Ctrl+End—but that cell may be below your actual data.

Which shortcut should you use?

The best shortcut depends on what you mean by “last row.” If you have a column that is filled consistently down to the final record, Ctrl+Down Arrow is usually the quickest way to reach the bottom of its data block. Excel moves to the edge of the continuous region, so you can see the row number of its last cell.

For example, if customer IDs are in A2:A500 with no blank cells in between, select a cell in that list and press Ctrl+Down Arrow. Excel moves to A500. The row number 500 is the last row in that uninterrupted block.

Use Ctrl+End when you want to inspect the last cell Excel considers used anywhere on the worksheet. It can be a useful overview, but it is not a guaranteed shortcut to the final row containing meaningful information. Formatting or old edits farther down the sheet can affect the result.

Last row in a continuous column: Use Ctrl+Down Arrow from a filled cell in that column.
Last used cell on the worksheet: Use Ctrl+End, then check its row number and contents.
Last row in a column with gaps: Use Ctrl+End as a starting point, or search the column for the actual final entry; Ctrl+Down Arrow stops at gaps.

How Ctrl+Down behaves around blank cells

Ctrl+Down Arrow follows the boundaries of a data region in the active column. When the current cell contains data and the cells below it are filled without interruption, Excel moves to the last filled cell before the first blank. This is why the shortcut works especially well in a column such as an ID, date, or account number column that has one entry for every record.

A blank cell changes the result. Suppose A2:A20 contains IDs, A21 is blank, and A22:A30 contains more IDs. Starting at A2 and pressing Ctrl+Down Arrow takes you to A20, not A30. The blank marks the end of the first continuous block. Press the shortcut again to move through the gap to the next block, or use a different method to identify the final entry across the column.

Starting position matters, too. If you start in a blank cell within a list, Excel moves toward the next boundary or filled cell according to the surrounding region. The destination may therefore not be the end of the list you had in mind. For a predictable result, click a known filled cell in the column first, then use the shortcut and inspect the row number.

The shortcut navigates within the current column; it does not evaluate every column in a table to decide which row contains the final record. Pick a column that should be populated for every record. If that column has missing values, a different column may provide a more reliable endpoint.

Ctrl+End versus Ctrl+Down

These shortcuts answer different questions. Ctrl+Down Arrow moves within the active column’s current data region. Ctrl+End moves to the last cell in the worksheet’s used range—the area Excel has recorded as used. That range can extend beyond the cells that currently contain visible values.

For instance, imagine a list ending at row 500, but a border or fill color was once applied to cell H900. Ctrl+End may take you to H900, even though the records stop at row 500. The row number at the destination is not proof that the intervening rows contain data. Look at the destination cell and the surrounding area before treating it as the final record.

Conversely, if the final records occupy different columns and there is no single uninterrupted column to follow, Ctrl+End can help you locate the lower-right edge of the used range. Check the cells in that area to determine which row actually contains the last relevant information. For a quick move to a specific row or cell, press Ctrl+G, enter a reference such as A500, and press Enter.

Find the last row when the data has gaps

A gap in the column you are navigating can make Ctrl+Down Arrow appear to stop too early. First decide what counts as a record and which column best represents one. If every record should have an ID but some records legitimately have a blank date, use the ID column to find the endpoint rather than the date column.

If there are gaps even in the ID column, you can use Ctrl+End to reach the used-range boundary, then inspect upward for the final populated row. Another option is to use Excel’s Find feature: press Ctrl+F, search for a value you know is in the relevant column, and use the search options to narrow the search if needed. Find is more useful when you know what to look for than as a universal “last nonblank cell” command.

For a large, well-structured list, turning the range into an Excel table can make navigation and data management easier. Select a cell in the range and press Ctrl+T, then confirm the range and whether it has headers. A table gives the data a defined structure and can expand when you add records. It does not change the basic behavior of Ctrl+Down Arrow: blank cells and the selected column still matter when you navigate to a boundary.

Select the rows as well as moving to them

If your goal is to select the remaining cells from your current position to the bottom of a continuous block, use Ctrl+Shift+Down Arrow. For example, click A2 and press that shortcut to extend the selection to the lower edge of the contiguous data region. This selects cells; it does not merely move the active cell.

Selection can be useful before copying or applying formatting, but check the highlighted range before acting. A blank cell can stop the selection early, just as it stops navigation. If you need to select through multiple blocks separated by blanks, you may need to select each block separately or specify the range directly in the Name Box, left of the formula bar. Enter a reference such as A2:A500 there and press Enter to select that exact range.

When you only need to reach the last row, avoid adding Shift. The non-selection shortcut, Ctrl+Down Arrow, moves the active cell while leaving the rest of the sheet unselected. This distinction matters when you are about to type, delete, or copy: an accidental range selection can make an edit affect more cells than intended.

Keyboard and platform notes

The Windows shortcuts above apply to desktop Excel for Microsoft 365. On a Mac, Excel also supports Control+Down Arrow for moving to the edge of a data region, and Control+End for moving to the last used cell. Depending on the Mac keyboard, you may need to use Fn with an arrow or End key to produce the required key press. Mac system or keyboard settings can also affect shortcuts involving Control and the arrow keys.

Excel for the web runs in a browser, where browser or operating-system shortcuts can sometimes compete with spreadsheet shortcuts. If a key combination does not behave as expected, click a worksheet cell and try again, or use the Name Box to enter a cell address directly. The Name Box is also a practical option when you know the row number but do not want to navigate through the sheet.

On either platform, the row numbers along the left edge show where the active cell landed. If the worksheet is filtered or has hidden rows, remember that the displayed records are not necessarily the only rows present. Keyboard navigation may reach cells in rows that are not currently visible, so verify the destination rather than assuming it is the last visible record.

Fix an unexpectedly low or high destination

If Ctrl+Down Arrow stops too soon, check for a blank cell in the active column. A formula that returns an empty string is different from a truly blank cell for some spreadsheet operations, but it can still make a column look empty; inspect the formula bar if the result is confusing. Also confirm that you started in the column you intended to follow.

If Ctrl+End lands far below or to the right of the visible dataset, old formatting or edits may have enlarged the recorded used range. Review the cells near that destination. If they contain formatting you no longer need, select the genuinely unused rows or columns, clear the unwanted formatting or contents, save the workbook, and check the endpoint again. Avoid clearing entire rows or columns unless you have confirmed they contain nothing you need.

If the destination looks correct but the answer still seems wrong, clarify whether you mean the last nonblank row in one column, the last row with any content in the worksheet, or the last visible row after filtering. Those are different tasks. Choosing the definition first prevents the common mistake of treating “last used cell” and “last row with data” as interchangeable.

Frequently Asked Questions

What is the shortcut to go to the last row in Excel?
For the bottom of a continuous data block in the current column, press Ctrl+Down Arrow from a filled cell. For the worksheet’s last used cell, press Ctrl+End.

Why does Ctrl+Down stop before the bottom of my list?
Excel stops at the edge of the current continuous block. A blank cell in the active column can divide the list into separate blocks, so the shortcut may stop at the first gap.

Does Ctrl+End always go to the last row with data?
No. It goes to the last cell in Excel’s recorded used range. Formatting or previous edits can extend that range beyond the last meaningful entry, so check the destination.

How do I select to the last row instead of just moving there?
Use Ctrl+Shift+Down Arrow to extend the selection to the edge of the current data region. The selection can stop at a blank cell.

What is the Mac shortcut for the last row in a data block?
In Excel for Mac, use Control+Down Arrow to move to the edge of the current data region. Some keyboards require Fn for particular arrow or End-key combinations.

A reliable way to choose

For a clean list with one value on every record row, start in that column and press Ctrl+Down Arrow; the row number gives you the bottom of its continuous block. If blanks might interrupt the list, or you are looking across a whole worksheet, use Ctrl+End as a navigation aid and verify the actual contents. When you know the address already, entering it in the Name Box or using Ctrl+G is often the most direct route.

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.