Hi!

I seem to be limited as to the amount of data I can use in the drop
down menu

A data validation drop down list can contain 32,767 entries.

Biff

"jagermeist1" wrote in message
...
I am a new Excel user who has basically learned everyething I know by
practicing and making MANY mistakes, but my question is: I use ddata
validation to make drop down menus for particualar cells that I need the
data
in and I seem to be limited as to the amount of data I can use in the drop
down menu. Is there any way I can make a drop down menu for cells that can
accomodate "unlimited data"? These are basic speadsheets I am making but I
need alot of selectons in a few of the drop down menus.