Hi!

Doesn't it look at the entire worksheet when it auto completes?

No. As you've experienced, it only works on contiguous ranges.

Biff

"Sarah" wrote in message
...
Thanks in advance for your help.

I have Enable Autocomplete for cell values checked in Options/Edit. If I
am
entering in the next blank row in the column that has the text it auto
completes. If i skip a row or go to another column it does not do the
auto
complete. Doesn't it look at the entire worksheet when it auto completes?

Thanks,

Sarah