[nabs-l] Excel question

[Sean Whalen]

Control plus up, down, left, or right arrow will move you to the edge of a
region, but not necessarily the beginning or end of a row or column. For
example, if you have data in column A from A1 down to A100, but no data in
cell A50, pressing control plus down arrow while you are in cell A1 will
take you down to A49, and not A100. Pressing control up arrow while in cell
A100 will take you to cell A51. Similarly, if you have column B empty except
for cells B25 and B50, which have data in them, pressing control down arrow
while in cell B1 will take you to the first cell containing data, B25.
Another press of control down arrow will take you to B50. This is a great
way to scan for records that are missing data in a particular column.

One other note: pressing "home" will always take you to the first cell in a
row, regardless of whether or not it is filled.

Hope it's useful,

Sean