Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I make a drop-down menu without cells containing the choices?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I make a drop-down menu without cells containing the choices?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I make a drop-down menu without cells containing the choices?
You can simply enter the items using a comma delimiter directly into the
data validation user form but when done like this you're limited to 255 characters. Like this: Tom,Sue,Bill,Pam,Linda You can also use a named range: Sheet1!A1:A25 = list of names Select the range Sheet1!A1:A25 In the name box (that little area directly above the header for column A) type in a name for the list like, say, MyList then hit enter. Then, as the source for the data validation list use: =MyList -- Biff Microsoft Excel MVP "Caeres" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a column of cells have a drop down menu | Excel Worksheet Functions | |||
how do i make a packing slip with a drop down menu | Excel Worksheet Functions | |||
how do i make a packing slip with a drop down menu | Excel Worksheet Functions | |||
how do i make all choices in a drop down box visible | Excel Discussion (Misc queries) | |||
Developing macro event to allow multiple choices on drop down menu | Excel Worksheet Functions |