software

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

Not sure what you are trying to do. Did you use autofill to create the column?
What are you trying to accomplish?

quot;Mikeytjquot; wrote:

gt; I have columns in my spreadsheet that all contain information, but along with
gt; blank rows. I want the auto fill feature to recognize date from the entire
gt; column, not just that up to the last blank. Example:
gt;
gt; A
gt; B
gt; C
gt; D
gt; Blank
gt; E
gt; F
gt; If I start typing here with the contents of A it will not see it due to the
gt; blank row. Can anyone tell me how to get it to recognize the entire column?
gt;
gt; Thanks
gt; Mike

You're referring to the AutoComplete feature. I think you're stuck with
this behavior. From support.microsoft.com/kb/130047/en-us:

quot;The AutoComplete feature and the Pick From list use only the entries in the
active column in the current region. The quot;current regionquot; is bounded by any
combination of blank rows and blank columns.quot;

--
Jim
quot;Mikeytjquot; gt; wrote in message
...
|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
Thanks Jim,

That answers the issue. First I have to know what to call it and second if
nothing else, put a period or something I won't use in blank fields.
Excellent.

Mike

I'm going to post another question about data verify, mabye you can aim me
right there to LOL

quot;Jim Rechquot; wrote:

gt; You're referring to the AutoComplete feature. I think you're stuck with
gt; this behavior. From support.microsoft.com/kb/130047/en-us:
gt;
gt; quot;The AutoComplete feature and the Pick From list use only the entries in the
gt; active column in the current region. The quot;current regionquot; is bounded by any
gt; combination of blank rows and blank columns.quot;
gt;
gt; --
gt; Jim
gt; quot;Mikeytjquot; gt; wrote in message
gt; ...
gt; |I have columns in my spreadsheet that all contain information, but along
gt; with
gt; | blank rows. I want the auto fill feature to recognize date from the
gt; entire
gt; | column, not just that up to the last blank. Example:
gt; |
gt; | A
gt; | B
gt; | C
gt; | D
gt; | Blank
gt; | E
gt; | F
gt; | If I start typing here with the contents of A it will not see it due to
gt; the
gt; | blank row. Can anyone tell me how to get it to recognize the entire
gt; column?
gt; |
gt; | Thanks
gt; | Mike
gt;
gt;
gt;