Auto Complete

  • Thread starter Thread starter elihue
  • Start date Start date
E

elihue

I have excell 2000 and have 300 names in one column and would like for excell
to auto complete on another column but it wont. When I went to HELP, all I
canfigure out is it says its out of my data region but I don't know how to
change that.
 
hi
auto complete looks at data in the same column above the activecell so
autocomple will not work in another column.
sorry
regards
FSt1
 
FSt1 said:
hi
auto complete looks at data in the same column above the activecell so
autocomple will not work in another column.
sorry
regards
FSt1
Click to expand...

Would a custom list be of any use to you, just a thought.
Cheers L
 
Back
Top