Forum Discussion
creating a drop down list
I understand what a dropdown list, but how do I apply it to data being entered. All the tutorial shows is how to create it, not how to apply it or how it actually works. Its was very useful in Quattro Pro and Lotus, but in Excel it makes no sense.
2 Replies
The moment you created the drop down list you are applying it.
So, what really is your question?
- The option to create a list to enter data is there. How do I put in pre data in so it is there when I need it from a drop down list. Are you referring to predictive text? I have names and numbers that all start out similar, but pretty much just end up spelling the whole word or number out to get the desired data typed in. It would be easier to create a dropdown list to select among similar names and numbers. I have not been able to create a "drop down list," as shown in tutorial or help list.
