I have columns in my spreadsheet that all contain information, but along with
blank rows. I want the auto fill feature to recognize date from the entire
column, not just that up to the last blank. Example:

A
B
C
D
Blank
E
F
If I start typing here with the contents of A it will not see it due to the
blank row. Can anyone tell me how to get it to recognize the entire column?

Thanks
Mike