If you were to ask me which Excel shortcut I use most often, I would definitely say Ctrl + Arrow Keys (↑ ↓ → ←). I use these all the time to navigate and select cells.
Let's look at how these work. In the example below, when I use Ctrl + ↓, starting in the header of Column A, it will move my selection all the way to the last non-blank cell in the column (A23).
In columns that have blanks, such as Column C, pressing Ctrl + ↓ the first time will move me to the last cell before the first blank. Pressing it again will move me to the next non-blank cell after the blank(s). Then pressing it again will take me to the last cell before the next blank.
In other words, repeatedly using Ctrl + ↓ moves you to the ends and the beginnings of the contiguous ranges of data in your column.
If your data has a lot of blank cells and you want to skip all the way to the bottom, you might want to use Ctrl + End instead. That will take you to the bottom-right entry on the sheet.
Typing Ctrl + Home will take you back up to the top left cell.
You can also select cells using these same navigation shortcuts by adding Shift into the mix.
In the example below, Ctrl + Shift + ↓ selects the entire data range between the two jump points.
I've only used the down arrow in my examples. However, the same principles apply to up, left, and right arrows as well.
Do you frequently use keyboard shortcuts to navigate and select cells in Excel? Or do you tend to rely on the mouse instead? Leave a comment and let me know your thoughts!