I’m going to write a lot about ditching the mouse in favor of keyboard shortcuts, so consider this one of many to come. And while we’re at it, get used to me spamming this next sentence throughout my shortcut posts: Using keyboard commands over hunting and clicking with the mouse will save you time. Period.
Next time you open Excel to manage a list, a table with headers or just giant blocks of data, please, please avoid using your mouse to select or highlight cells and cell ranges. Use these keyboard shortcuts instead:
- Ctrl + Shift + Arrow Key: I consider this among the most useful Excel keyboard shortcuts around. Extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.
- Ctrl + Arrow Key: Jumps to the edge of the current data region in a worksheet.
- Ctrl + Home: Jumps to cell A1 no matter where you are on a worksheet.
- Ctrl + End: Jumps to the right bottommost nonblank cell.
- Shift + Arrow Key: Extends the selection of cells by one cell.
Out of these five navigation shortcuts I probably use the first and second 95% of the time. The first shortcut, Ctrl + Shift + Arrow, to select large blocks of data like a long list or a table. This one is especially useful if you have a table or any list with more than one column because you can press Ctrl + Shift + ↓ to select down the entire first column, then while keeping Ctrl + Shift pressed, hit → to quickly select the remaining columns to the right.
Some of the data feeds I work with regularly generate tables 30+ columns wide and often thousands of rows long, so being able to exactly select the entire table by simply pressing Ctrl + Shift + ↓ + → saves me a lot of time and hassle. The second shortcut, Ctrl + Arrow Key, is how I jump around in Excel to get from one end of my data to the other.
It’s super, so do it.