You can type a list in the Data Validation dialog box, instead of
refering to a range on the worksheet. There's a limit of 255 characters.
For example,
Select the cells where you want the drop down list
Choose DataValidation
From the Allow drop down, choose List
In the Source box, type your list, e.g.:
East, West, North, South
Click OK
Caeres wrote:
I want to make a drop-down menu without having to reference cells that
contain the information in the menu (because I don't want to have to devote
cells to just a menu, and have to keep track of where and what they are). Is
there a way to do this, like reference a name containing a single column of
cells or something? I tried, but couldn't get it to work. Thanks in advance.
--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog:
http://blog.contextures.com