Tools like Microsoft Excel, LibreOffice Calc, or Google Spreadsheets are widely used both in the business world and also at home. If you work with large tables regularly, you may wonder if there is a way to quickly jump to the last row with data in a spreadsheet. Similarly, you may wonder whether you can jump to the first row with data, or the last column cell with data in a row.
A check of the available buttons and menus yields no available option to do that. While you may know that you can navigate in a spreadsheet using the cursor keys, activating these moves the cursor to the next cell only. Scrolling may be faster with the mouse, but if you have to a large table with thousands of cells or rows, you are going to spend some time scrolling, still.
Good news: there is a faster way. Even better, it should work in most spreadsheet applications. Note that you need to hold down the modifier key, in this case the Ctrl-key (or Cmd-key on Mac).
Here are the keyboard shortcuts that you need:
Ctrl-Down works well if there are no blank cells in the table. If you have lots of blank cells, you need to activate the shortcut multiple times. It is still faster than using the Down-key or scrolling but not the fastest option.
Ctrl-Home works all the time whereas Ctrl-End may jump too far down and to the right so that you may readjust the position again after the jump has been made.
Here is a combination of shortcuts that will work all the time: use Ctrl-End to jump all the way down, then Home to jump to the first cell of that row, and then Ctrl-Up to the last cell of the table with data.
Ctrl-Down is faster if there are no blank rows in the table, but if there are lots of them, the above combination may be faster.
Now You: Have other spreadsheet tips? Let us know in the comments!Advertisement
Ghacks is a technology news blog that was founded in 2005 by Martin Brinkmann. It has since then become one of the most popular tech news sites on the Internet with five authors and regular contributions from freelance writers.