Cntrl+ down arrow is taking me to the next blank cell. The problem is that many
cells in a column appear blank, but they actually have something in them.
These data are being copied from other sheets, and there are no blank spaces
in the cells. I've tried using paste special - values, but this also does not
work.

So my question: What could be in these cells that stops excel from seeing
them as blank? A colleague is also having this happen to him with data
exported from Access. Maybe excel sees a null value or something and
considers that different from blank?

I'm dealing with very large spreadsheets, and I want to be able to quickly
verify if there is data in all columns. I want to use cntrl plus arrow down
for this, but I can't as long as excel views these null cells as containing
values.
thank you,
craig