Ctrl-Down (for example)

If the active cell is:
Empty - goes to first non-empty cell (or last row if all cells are empty)
Not Empty but next cell is empty - Same as above
Not Empty and next cell is also not empty - goes to last non-empty
contiguous cell

Hidden rows are treated as empty.

If you have an specific example that behaves differently tell us the _exact_
steps that reproduce it.

--
Jim
"Craig" wrote in message
...
| 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