Tools like Microsoft Excel, LibreOffice Calc, or Google Spreadsheets are extensively used each in the enterprise world and likewise at residence. If you’re employed with massive tables frequently, you might surprise if there’s a method to rapidly jump to the last row with data in a spreadsheet. Similarly, you might wonder if you possibly can jump to the first row with data, or the last column cell with data in a row.
A verify of the obtainable buttons and menus yields no obtainable possibility to do this. While you might know you can navigate in a spreadsheet utilizing the cursor keys, activating these strikes the cursor to the subsequent cell solely. Scrolling could also be quicker with the mouse, however if in case you have to a big desk with hundreds of cells or rows, you’re going to spend a while scrolling, nonetheless.
Good news: there’s a quicker method. Even higher, it ought to work in most spreadsheet purposes. Note that you just want to maintain down the modifier key, in this case the Ctrl-key (or Cmd-key on Mac).
Here are the keyboard shortcuts that you just want:
- Ctrl-Down — The shortcut strikes the cursor to the last row with data earlier than the first clean row that’s encountered; this can be the last row in the desk ideally, however provided that there should not any clean rows in the desk.
- Ctrl-Up — The shortcut strikes the cursor to the first row with data earlier than a clean row.
Ctrl-Down works effectively if there aren’t any clean cells in the desk. If you might have a lot of clean cells, you want to activate the shortcut a number of occasions. It remains to be quicker than utilizing the Down-key or scrolling however not the quickest possibility.
- Ctrl-End — Moves the cursor to the last right-most cell of the desk.
- Ctrl-Home — Moves the cursor to the first left-most cell of the desk.
Ctrl-Home works all the time whereas Ctrl-End could jump too far down and to the proper so that you could be readjust the place once more after the jump has been made.
- End — Jumps to the last cell of the row with data.
- Home — Jumps to the first cell of the energetic row.
- Arrow Keys — Moves one cell or row.
Here is a mixture of shortcuts that can work all the time: use Ctrl-End to jump all the method down, then Home to jump to the first cell of that row, after which Ctrl-Up to the last cell of the desk with data.
Ctrl-Down is quicker if there aren’t any clean rows in the desk, but when there are many them, the above mixture could also be quicker.
Now You: Have different spreadsheet tips? Let us know in the feedback!