text lists - begin typing names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of teams in one column, i would like to begin typing a team
name in a separate cell and excel will recognize the name and fill in the
rest...similar to how some search engines work. is this possible?
 
The only way I can get Excel to "autocomplete" is to:
a) type a list of names ABOVE the cells you want to type into.
b) hide THOSE rows
c) use the rows beneath for typing the names.
d) do not leave any blank cells between the hidden list and your list or
within either one or it won't work.

--
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif until a number occurs four times in a row then return that number 3
validation (list) & auto fill 2
Lookup multiple cell values and place contents in a single cell 3
Query Named Range Return Single Column Value 5
Finding Multiple Instances in a List 1
list items from one table in another table based on value in first table 2
Pick List + Alphabetical Skip To or Auto Complete 2
Formatted cell column in drop down list 1

Back
Top