I've never found a decent keyboard combination for selecting a single-column range whose length is determined by an adjacent column. If I double-click the fill handle, for example, it will fill a formula down as far as the column on the left has data. That's nice when you have a lot of data.
I [...]
Read the complete post at http://www.dailydoseofexcel.com/archives/2007/11/25/select-adjacent/
Posted
Nov 25 2007, 11:13 PM
by
Daily Dose of Excel