Excel Jump to Bottom of Data: Shortcuts That Actually Work

To jump to the bottom of your data in Excel, click any cell in the column and press Ctrl+Down Arrow (Command+Down Arrow on a Mac). To go to the last used cell of the whole sheet, the bottom-right corner of everything you have touched, press Ctrl+End.

Those two shortcuts cover most cases, but they behave differently around blank cells and stray formatting. Below is how each one works, when to use which, and what to do when Excel lands somewhere unexpected. Shortcuts here apply to current desktop versions of Excel as of November 2026; Microsoft occasionally changes menus, so wording may shift.

The quick answer: which shortcut to use

The Mac keys for small keyboards come from SumProduct’s Excel for Mac guide. If a Mac shortcut does nothing, macOS may have claimed that key combination for something else; check System Settings, then Keyboard, then Keyboard Shortcuts.

Ctrl+Down Arrow: bottom of the current data block

Ctrl+Down Arrow moves the active cell to the edge of the current data region in that direction. In practice:

• If you start inside a filled column, it jumps to the last filled cell before the next blank.
• If you start on a blank cell, it jumps down to the next filled cell.
• If there is nothing below, it goes to the very last row of the worksheet.

The other arrow keys work the same way: Ctrl+Up goes to the top of the block, and Ctrl+Right or Ctrl+Left go to the edges of the row.

When your column has gaps

The most common complaint is that Ctrl+Down “stops halfway.” It is doing exactly what it is designed to do: it treats a blank cell as the end of a block. You have a few options:

1. Press it again. Each press hops to the next boundary, so a few presses get you through scattered blanks.
2. Use a complete column. Move to a column that is always filled, such as an ID, date or name column, press Ctrl+Down there, then move sideways.
3. Come up from the bottom. Press Ctrl+Down until you reach the last row of the sheet, then press Ctrl+Up. That lands on the last filled cell in the column, regardless of gaps above it.

Option 3 is the most reliable way to find the true last entry in a column with blanks.

Selecting to the bottom

Add Shift to extend a selection instead of just moving: Ctrl+Shift+Down Arrow selects from the current cell to the bottom of the block. This is handy for copying a column or applying formatting to just the rows you have. It respects the same blank-cell boundaries, so check the selection before you act on it.

Ctrl+End: last used cell on the sheet

Ctrl+End goes somewhere different. According to Microsoft’s support article on the last cell, it moves to the last cell that contains data or formatting. That means the lowest used row and the rightmost used column, combined. So if your data ends at row 500 in column D, but someone once typed a note in column K, Ctrl+End takes you to row 500 of column K (or further, if anything sits lower).

Ctrl+Shift+End does the same jump while selecting everything from the current cell to that last cell.

Why Ctrl+End overshoots

Microsoft explains that when you save a workbook, Excel stores only the part of each sheet that contains data or formatting. Empty cells that still carry formatting, such as a fill color, border or number format applied to a whole column, count as used. Deleting values with the Delete key clears the contents but can leave that formatting, so Ctrl+End keeps landing in an “empty” area well below your real data.

How to reset the last cell

Microsoft’s documented fix, for Excel for Microsoft 365 and recent desktop versions, is:

1. Click anywhere in the worksheet and press Ctrl+End to see where Excel thinks the sheet ends.
2. Click the row heading of the first empty row below your real data, then press Ctrl+Shift+End to select every row down to that last cell.
3. On the Home tab, in the Editing group, click the arrow next to Clear and choose Clear All.
4. Repeat for columns: select the column heading of the first empty column to the right of your data, press Ctrl+Shift+End, and choose Clear All.
5. Save the workbook, close it and reopen it, then press Ctrl+End to check.

Work on a copy first if you are unsure, because Clear All removes formatting and comments as well as values in the selected cells.

Results from this process are not always consistent. In Microsoft Tech Community threads, some users report that the last cell only updated after saving, and others report it did not change at all on reopen. Older Microsoft guidance for legacy versions suggested deleting the excess rows and columns (right-click, Delete) instead of clearing them, which is worth trying if Clear All does not help.

Double-click a cell border (mouse method)

If you prefer the mouse, select a cell inside your data, point at its bottom border until the pointer turns into a four-headed arrow, and double-click. Excel moves the selection down to the last filled cell before a blank, just like Ctrl+Down Arrow, as described by How To Excel At Excel. Double-clicking the top, left or right border jumps in that direction instead. Hold Shift while you double-click to select the range along the way.

If you keep triggering this by accident, ExcelTips notes that turning off Enable fill handle and cell drag-and-drop in Excel’s Advanced options stops it. That setting also disables the fill handle, so you may not want to leave it off.

Go To and Go To Special

Two built-in dialogs are useful when shortcuts are not enough:

• Go To (F5 or Ctrl+G): type any address, such as A10000, in the Reference box and press Enter. You can also type an address straight into the Name Box to the left of the formula bar. Microsoft documents both in Select specific cells or ranges.
• Go To Special: in the Go To dialog, click Special and choose Last cell. Microsoft describes this option as selecting the last cell on the worksheet that contains data or formatting, so it lands in the same place as Ctrl+End (Find and select cells that meet specific conditions). It is mainly useful if your keyboard lacks an End key.

Which method should you use?

• Daily navigation in a list: Ctrl+Down Arrow. Fast, predictable, and it pairs with Shift for selections.
• Columns with blanks: jump to the sheet’s last row, then Ctrl+Up Arrow, or use a column that is always filled.
• Finding the extent of everything on the sheet: Ctrl+End, keeping in mind that formatting counts.
• Ctrl+End is clearly wrong: clear or delete the excess rows and columns, save and reopen.
• Mouse users or laptops without an End key: double-click the cell border, or use Go To Special, then Last cell.

Once you know that Ctrl+Down follows blocks of data and Ctrl+End follows anything Excel considers “used,” the odd landings start to make sense, and you can pick the right jump on the first try.