Select all cells in a column up to a blank cell
To go from top to bottom, it's <Ctrl<Shift<Down Arrow
To go from bottom to top, it's <Ctrl<Shift<Up Arrow
From left to right, its <Ctrl<Shift<Right Arrow
From right to left, <Ctrl<Shift<Left Arrow
If you need to select a range, you can do it in combination
<Ctrl<Shift<Down Arrow
<Ctrl<Shift<Right Arrow
will select a block all the way down to the first empty cell, and all the
way to the right to the first empty cell in the bottom row.
HTH
"nemadrias" wrote:
Hi -
Can anyone tell me how to select all cells in a row up to (not
including) the first blank cell in the row?
Thanks alot!
|