DropDown w/in cell

[Holt88]

I want to have a drop down appear in an individual cell
when a user activates that cell. I have an example on hand
but don't know how to create it. When the user activates
the cell, a drop down "triangle" appears to the right,
giving the user the option to pick from a list. How is
this done? Thanks in advance

 

[Debra Dalgleish]

You can use Data>Validation. There are instructions in Excel's Help, and
here:

http://www.contextures.com/xlDataVal01.html

 

[Jason Morin]

It's called Data Validation. MVP Debra Dalgleish has some
pretty simple step-by-step instructions:

http://www.contextures.com/xlDataVal01.html

HTH
Jason
Atlanta, GA

 

[sam]

I'd turnon the 'Forms' Toolbar in ur toolbars (rightclick
select Forms). Then draw ur Dropdown box and reference the
list (or type in the list). Hope this helps! ^-^
-sam