How to Jump to the Last Row With Data in Excel and Google Sheets

Press Ctrl + Down Arrow in Excel, Google Sheets or LibreOffice Calc to jump to the last cell with data in the current column; on a Mac, press Command + Down Arrow. Ctrl + End jumps to the last used cell of the whole sheet instead, and Ctrl + Shift + Down Arrow selects everything from the current cell down to the last row with data.
The shortcuts below work in current versions of all three spreadsheet apps. The table at the end of the first section lists the equivalents side by side.

The shortcut: Ctrl + Down Arrow
Ctrl + Down Arrow moves the cursor to the edge of the current data block in a column. Click any cell in the column you want to check, press the shortcut, and the cursor lands on the last filled cell before the next empty cell. Press it again to jump to the next block of data, or to the very last row of the sheet if nothing follows.
The same logic works in all four directions:
| Action | Windows (Excel, Sheets, Calc) | Mac (Excel, Sheets) |
|---|---|---|
| Last row with data in the column | Ctrl + Down Arrow | Command + Down Arrow |
| First row with data in the column | Ctrl + Up Arrow | Command + Up Arrow |
| Last column with data in the row | Ctrl + Right Arrow | Command + Right Arrow |
| Last used cell of the sheet | Ctrl + End | Control + End, or Fn + Control + Right Arrow (Excel) |
| Back to cell A1 | Ctrl + Home | Control + Home, or Fn + Control + Left Arrow (Excel) |
Ctrl + Down vs Ctrl + End: which you need
Use Ctrl + Down Arrow when you want the last entry of one column, and Ctrl + End when you want the bottom-right corner of everything you have used in the sheet. Ctrl + End goes to the last row and last column that contain data or formatting, so it can land in an empty cell far right of the column you care about.
In Excel, Ctrl + End can also point past your data when cells once held content or formatting that was deleted. Save the workbook and Excel usually resets the used range; deleting the empty rows and columns below and to the right of your data fixes it if it does not.
Select everything down to the last row
Add Shift to any jump shortcut to select instead of move. Ctrl + Shift + Down Arrow selects from the current cell to the last filled cell of the column, which is the quickest way to copy a column or apply a format to it. Ctrl + Shift + End selects everything from the current cell to the last used cell of the sheet. On a Mac, use Command + Shift + Down Arrow in Excel and Google Sheets.
Mac shortcuts
Mac keyboards replace Ctrl with Command for these jumps: Command + Down Arrow moves to the last row with data, Command + Up Arrow to the first. MacBook keyboards have no End or Home keys, so Excel for Mac uses Fn + Control + Right Arrow for the last used cell and Fn + Control + Left Arrow for cell A1.
Google Sheets and LibreOffice Calc
Google Sheets uses the same shortcuts as Excel: Ctrl + Down Arrow on Windows and ChromeOS, Command + Down Arrow on a Mac. If a shortcut does nothing in Sheets, check that the browser or an extension is not using it.
LibreOffice Calc follows the Excel behavior: Ctrl + Down Arrow jumps to the edge of the data block, and Ctrl + End jumps to the last cell that contains data.
When the shortcut stops early, and how to fix it
Ctrl + Down Arrow stops at the first empty cell, so a column with gaps needs several presses. Three ways around it:
- Start from the bottom: press Ctrl + Down Arrow until you reach the last row of the sheet, then press Ctrl + Up Arrow once. You land on the real last entry, regardless of gaps.
- Use the Name Box (Excel) or Go To (F5 or Ctrl + G): type a cell address such as A100000 to jump directly.
- Fill the gaps, or convert the range to a table (Ctrl + T in Excel), so the data is one continuous block.
Cells that look empty but contain a space or an empty formula result also count as data, which can make the jump stop in an unexpected place.
Find the last row with a formula
A formula returns the last row number or value without moving the cursor, which is useful in dashboards and templates:
- Last value in column A:
=LOOKUP(2,1/(A:A<>""),A:A) - Row number of the last value in column A:
=LOOKUP(2,1/(A:A<>""),ROW(A:A)) - Number of filled cells in column A (no gaps):
=COUNTA(A:A)
The LOOKUP formulas work in Excel. In Google Sheets, use =INDEX(A:A,MAX(FILTER(ROW(A:A),A:A<>""))) for the last value in column A.
FAQ
Why does Ctrl + End go past my data?
Excel remembers cells that once held content or formatting. Delete the empty rows and columns after your data and save the workbook to reset the used range.
How do I go back to the top of the sheet?
Press Ctrl + Home to jump to cell A1, or Ctrl + Up Arrow to jump to the first row with data in the current column.
Does Ctrl + Down Arrow work on a laptop?
Yes. The arrow keys are enough. Only Ctrl + End and Ctrl + Home need the End and Home keys, which some laptops place under the Fn key.
How do I jump to the last column with data?
Press Ctrl + Right Arrow in the row you want to check, or Command + Right Arrow on a Mac.
Related: undo and redo shortcuts on Windows and Mac, how to type special characters on any keyboard and draw.io, a free flowchart maker.
Doesn’t one have staff?
I can’t say about Excel but for Google sheets the response to CTRL-DN seems to depend on what is in the column corresponding to the cell that’s currently selected. If the number of entries in your columns is not uniform (mine rarely are), then the result may not be what you intended.
I am on a new job and have never used Excel in my previous job of where I retired with 22 years. This is very helpful. Thank you.
These shortcuts are not right. End by by itself does nothing for instance.
For many year’s I’ve been hoping to find a particular keyboard shortcut. Highly doubtful that it exists in Excel but it never hurts to ask. To describe it briefly…
Sometimes we need to copy the contents of a filled range to a blank area — but the new range will be of a different size. Maybe a single formula is to be copied to a matrix of various rows and columns, say. If you’re using a mouse it’s dead simple. Click and drag to highlight what you want. Highlight, copy, highlight, paste. Done.
Except that it doesn’t work so well with ranges that are very large and can’t be viewed all at once on the screen. Really big ranges should be highlighted with keyboard shortcuts like those discussed here.Terribly inefficient to use a mouse.
So then, are there any Excel shortcuts to define new ranges in blank areas of your worksheet?
The old programs had them. In Lotus 1-2-3, you first highlighted a range and then tapped the dot/period key (.). Then you could move the highlight region around with arrow keys and such. You weren’t moving any of the the cell content, mind you, but rather the defined size-shape of the highlight area.
For this to really speed-up your work, you needed to (already) have a filled range somewhere in your worksheet of the desired size. You used it as a size template, and you quickly highlighted it with the other handy keyboard shortcuts available.
This may be hard to explain, but believe me, it was an extremely helpful feature. You grew to rely on it in a hurry. Not sure if I made myself clear, but on the off-chance that I did… Does anybody know if you can do this in Excel? Again, we’re talking about quickly highlighting an area within a set of BLANK cells.
And you don’t think people with large spreadsheets already know that? Come to that ones who haven’t. Just useless filler which is becoming common on here these days.
Page Up and Down is like scrolling on steroids, Home, End, Ctrl they all basically work in both Word and Excel. I learned Office 2000 and surprisingly most of the basics are still the same today, though with a lot more bells and whistles of course.
Using the Shift key in combination with the above helps to quickly highlight cells.
For instance, to highlight all cells, use Ctrl-End to get to the bottom right most cell, then Shift-Ctrl-Home to highlight all cells.
From there, I find it very useful to use the Shift – arrow key combo to unhighlight a row or column (or several).
Hi I am old school too. Yes Ctrl & the arrow keys are good for jumping. Most of the older folks would know that. Less commonly known is that in Excel there is a shortcut method to jump using the mouse.
Left double-clicking on the border of a cell when you get a 4 prong arrow will allow you to jump (in the direction the border is facing) to the last filled cell of a continuous data range or last blank cell if the data range is not continuous.
You can jump down, up, right or left depending on the border you click on when you get the 4 prong arrow.
I did not know that one about the 4-prong arrow jumping. Very convenient for when your hand is already on the mouse. Thanks.
Is there a keyboard combo for jumping to leftmost cell of the row you are in?
Yes it is the Home key. You may also use Ctrl-Left if there are no blank cells.
Ctrl+End can jump too far in Excel after you have deleted rows. Saving the file correctly resets the last-row index, so you won’t need to Ctrl+Up after Ctrl+End.
That is a good tip, thanks!
I cannot believe the blog post I just read. Back in the olden days everybody knew this stuff inside-out. What’s next, a how-to on using dollar signs to toggle between relative and absolute cell addressing?
Tip: Place your cursor over the cell address in a formula. Then tap the F4 key to cycle through the various combinations of leading $’s to the column/row. You can make either the row or column reference absolute, or both, or neither. (As in: A1, $A$1, A$1, $A1) This affects the result when you copy and paste the formula.
I have no idea if that is another example of nearly-lost knowledge or not, or if these are as well.
Tip: The key combination of Ctrl-F6 will cycle through your open spreadsheets.
Tip: Hitting the Enter key will complete the paste operation while clearing the memory buffer.
Tip: Ctrl-; inserts today’s date into the active cell.
And endless examples like that.
Did computer users know and use keyboard shortcuts and other tricks more in the past? I don’t know, but the trend to “optimize” and “streamline” products likely plays a role in computer users not knowing about these handy shortcuts anymore.
In the days of MS DOS, keyboard shortcuts were just what everybody did naturally. When we transitioned to the Windows GUI world there was no reason to abandon them. For example, highlighting a block of filled cells by holding down Shift-Ctrl and moving the arrow keys — is that not how everybody normally does it any more? Serious question. The larger the block, the more kludgy it is to use the mouse.
Every day I feel like more of a dinosaur.
Thanks for the head up on this highlighting column option. To be honest the only intent of this blog would have been how to pop to the last row in excel, however Ctrl + D. + Arrow won`t be working properly unless you already have the cursor on the last row (which doesn`t make any sense as it means you have already been there at some point lol..) However if you highlight the whole column it doesn`t matter when you or your cursor are you will get for sure to the last row.
@Martin: Absolutely. And you can still see this old-school approach in macOS, which has a much stronger emphasis on keyboard shortcuts for pretty everything – even though it actually originated the graphic UI. Windows also used to highlight keyboard shortcuts for many activities, but that’s been shelved since Windows 95.
Martin,
You ask “Did computer users know and use keyboard shortcuts and other tricks more in the past? ”
In ancient days, like 30 years ago, I have a recollection the GUI interface was not as developed as today.
If I recall correctly, most tasks were done with key combinations. I think WordPerfect had a little template that you laid down on top of the Function keys (above your number keys). Each key could do multiple functions, depending on what key was pressed along with it (e.g., control, fn, shift). They didn’t have a Windows key back then. I suppose this was much better than a GUI if that is what you mainly used, but a GUI is much better for non-experts.
I barely ever use my function keys. I just use them to put my computer to sleep, or to change what happens when I start the computer, e.g., to enter the BIOS/UEFI setup, or to temporary change the boot order.
Besides WordPerfect, there was a database program called dBase.
I think the first advanced GUI I saw was either Microsoft Word or Excel.
Yeah, the olden days. I miss them too. I also missed or have forgotten Ctrl-; Haha, thanks for the reminder. Wish it worked in word processors.