• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 437
  • Last Modified:

Excel 2013 AutoFill option

I need to use the auto fill option in excel.  

I have about 600 names that I need to be able to pick from in a cell.

Is there a way to make a drop down list form when I type the first letter, then decrease as I type more letters??

So if I type a Z it will show everyone with the letter Z in the first of their name then i just people with zi and so forth and so on??

Also I know that if I type a list of the people above my cell it should autofill their name as I type it but it in cells below but it seems if I copy and paste the name in it will not work.

Thanks for your help!!
Curtis Long
Curtis Long
1 Solution
Steven HarrisPresidentCommented:
Check out this post on Ozgrid.
Curtis LongAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now