Thread: [Solved] Using Defined Names
View Single Post
 
Old 10-12-2015, 10:37 AM
snowbunny snowbunny is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2015
Posts: 2
snowbunny is on a distinguished road
Default

No sorry. I guess I should rephrase. That wasn't what I meant. Under the Formulas tab in the defined names area, I can create a drop-down list. When I finished creating my list that I wanted, I went to type in where the cell is located and it only allows me to click the drop down arrow and search for the name that I want. I was hoping that instead of always clicking on the drop down arrow, I could just start typing in the name and it would predict or forecast the name that I want. I have a very long list of names, in the hundreds and it is a pain to have to always select the drop down arrow and scroll down to locate it. Not very efficient.
Reply With Quote