How to add a drop down menu to a cell
 

How to add a drop down menu to a cell?

hi,
you don't add it to a cell. It's a control in the toolbox
and it sits on top of the sheet.
Toolscustomizetoolbar tabselect control toolbox.
it's called a combo box. click it and drag it to the sheet.
for more help on combo boxes, type combo box in help.

-----Original Message-----
How to add a drop down menu to a cell?
.

You can do it. Take a look at DataValidation, see this site for full
details http://www.contextures.com/xlDataVal01.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
...
hi,
you don't add it to a cell. It's a control in the toolbox
and it sits on top of the sheet.
Toolscustomizetoolbar tabselect control toolbox.
it's called a combo box. click it and drag it to the sheet.
for more help on combo boxes, type combo box in help.

-----Original Message-----
How to add a drop down menu to a cell?
.