software

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

Hi!

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

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

Biff

quot;Sarahquot; gt; wrote in message
...
gt; Thanks in advance for your help.
gt;
gt; I have Enable Autocomplete for cell values checked in Options/Edit. If I
gt; am
gt; entering in the next blank row in the column that has the text it auto
gt; completes. If i skip a row or go to another column it does not do the
gt; auto
gt; complete. Doesn't it look at the entire worksheet when it auto completes?
gt;
gt; Thanks,
gt;
gt; Sarah
You are right.To add to that

Autocomplete works only on rows and not on columns
Autofilter alos does not work on balnks
For example,when you have values from a1:a10 and then
form a150:a200,when you use autofilter, the values from
a1:a10 is only displayed
Also,you cannot cut and paste data in autofilter mode

For more queries and answers visit
groups.google.co.in/group/answers-for-everythingIf you selected A1:A200, then applied data|filter|autofilter, you'd see all the
items in A1:A200--no matter if you had blanks or not.

But if you leave the range to filter up to excel, it'll guess that your data
stops when it sees that blank row. (I never let excel guess at those kinds of
ranges.)wrote:
gt;
gt; You are right.To add to that
gt;
gt; Autocomplete works only on rows and not on columns
gt; Autofilter alos does not work on balnks
gt; For example,when you have values from a1:a10 and then
gt; form a150:a200,when you use autofilter, the values from
gt; a1:a10 is only displayed
gt; Also,you cannot cut and paste data in autofilter mode
gt;
gt; For more queries and answers visit
gt; groups.google.co.in/group/answers-for-everything

--

Dave Peterson