pull down menus

  • Thread starter Thread starter Murat
  • Start date Start date
M

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
 
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)=> =D1:D10
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 >
 
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
 
Back
Top