An Alternative To AutoComplete In Excel

Sometimes AutoComplete just doesn’t do the trick to make it easy to fill in data from a long list. Here’s a great alternative.

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, ,

4 Responses to An Alternative To AutoComplete In Excel

  1. Randy January 24, 2015 at 3:43 am #

    Thanks for the post. A few points your readers may want to note when it comes to auto-complete:
    *When you have a large list of names (hundreds or thousands) typing in the first few characters and then entering Alt + Down arrow will start the user within the list based on the entered characters, which is quite helpful when using the Up/Down arrows to locate the entry you are searching for
    *When using auto-compete with names in the thousands there is a lag time between excel locating the names towards the end of the list. Ex: if your names are in alphabetical order, and you type in “Ba” then Alt + Down Arrow, excel should find it quickly, however if you type in “za”, you will have to wait a required # of seconds BEFORE pressing Alt + Down Arrow, otherwise Excel won’t start at the desired letters (The # of seconds is direction proportional to the speed of your processor and the # of names within the list)
    I hope this helps,
    Randy

  2. Jason November 22, 2015 at 4:43 pm #

    Thanks for the Alt + Down Arrow tip! This is exactly what I was looking for, and Googling for 2 hours gave me nothing until I found your post. I have long text entries on a column that can be similar but not exactly the same so auto-complete was no help until I typed enough to make it unique. Now I can type a few letters and use Alt + Down Arrow to get a list of similar previous entries and pick the one I want. I knew there had to be a quick way to do this.

Leave a Reply