Tip #3786 - Highlight From Here On Up
Printer Friendly Version | E-Mail This Tip
Highlight
From Here On Up
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: Use
the Ctrl + Shift + Arrow keys to complete a quick highlight.
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
Want To Comment On This Tip? Click Here! We'd love to hear from you :-)
Like These Tips? Get 'Em Free In Your E-mail
