pull down menus

[Murat]

Hi,

I was wondering if it possible to create a pull down tab in a cell. There I
would like to be able to choose from a list of data (letters not
numbers). If someone could tell me how to do this it would be very
much appreciated.

Thanks,

Murat

 

[keepitcool]

Murat,

many people use data validation for this.

menu: Data/Validation
Allow: LIST
Source:
1. a separated list (depends on your list separator)=> a,b,c
2. a range on the same sheet (single columns/row)=> =D110
3. a defined name (which allows the list to reside on a different sheet)
=> =MyList

Insert Name Define: Name:=MyList RefersTo:= =sheet2!a1:a10



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Bob Phillips]

Murat,

See Debra Dalgleish's site at http://www.contextures.com/xlDataVal01.html
for more than you'll need to know re Data Validation.

--

HTH

Bob Phillips

Hi,

I was wondering if it possible to create a pull down tab in a cell. There I
would like to be able to choose from a list of data (letters not
numbers). If someone could tell me how to do this it would be very
much appreciated.

Thanks,

Murat