On Aug 9, 2:20 pm, "Peo Sjoblom" wrote:
Interesting, I didn't know that, always thought it was single column
centric, not region.

--
Regards,

Peo Sjoblom

"JE McGimpsey" wrote in message

...

Neither right, nor wrong.

Autocomplete operates on the "active data region", i.e., there must be
no completely blank rows between the list and your entry.

For example, when making an entry at <entry,

Autocomplete works

A B
1 data1 1
2 data2 2
3 data3 3
4 <blank 4
5 <blank 5
6 <entry 6

Autocomplete doesn't work:

A B
1 data1 1
2 data2 2
3 data3 3
4 <blank <blank
5 <blank 5
6 <entry 6

article ,
Gringo wrote:

It seems thatautocompletehas previously worked for me when there was a
separation of several rows at least. Today it will onlyautocomplete
for
the next cell down. Is this right or wrong?

I have a sheet open right now that will auto complete only in a
scattered handful of cells further down the column that are not
"connected" to the cells above. I too would like to have it auto
complete if it finds a match ANYWHERE in that column. Strange that a
FEW cells will do it, but I can't find any rhyme or reason why... the
formating, etc all looks the same. Copying a "magic" cell doesn't
seem to carry it's magic with it, and I can't seem to duplicate the
effect. Please forward any solutions you may have come across.