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!!