Hi,
This bugs me about excel, and it leads to mistakes, so I thought I'd ask:

When I select Control key plus the arrow key, I thought this skipped all
blank cells and took you to the next populated cell.

What I've found however is that it sometimes ignores cells with content, and
my cursor goes to the bottom of the sheet, leading me to believe that a
column is empty when it is not.

Why does excel do this? does it depend on the data type of the data in the
column? please help, I can't figure it out.
thanks,
Craig