- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

Highlight Everything Above in MS Excel

Or down. Or left. Or right.

Yep, that’s what you can do with a few quick keystrokes in MS Excel. That is, if you know the “magic” combination.

Okay, so it’s not exactly magic, but it still could be a pretty useful skill and worth a look.

If you’ve ever had a cell selected in MS Excel and wanted to quickly highlight everything above, below, to the left or to the right of the current cell, this tip’s for you.

Here’s the deal:

The Ctrl + Shift + Arrow keys will complete a quick highlight faster than you could ever hope to find.

Excel will highlight in the direction your arrow key designated, until it reaches the edge of the data range that the current cell is in.

Need to go further?

No problem! Just keep hitting the arrow key until the highlight has extended as far as you need it. (Keep in mind that it’s moving one range at a time and could make large jumps through the worksheet, depending upon the data location).

Need a block of cells highlighted?

I’ve got that one covered too.

Complete a highlight in the left or right direction and then immediately repeat the process in the up or down direction. You’ll then have an entire range of data highlighted in a matter of seconds!

There you have it. Just one more keyboard shortcut to add to your ever growing list of Excel timesavers. Yes!

~ April