Drop Down Lists

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

I'm trying to build a drop down list into a worksheet and
am not sure how to do it, of if Excel is even capable of
doing it. The list will have around 30 entries in it,
with each entry related to a value in another cell. Can
anyone tell me how to do this?

Thanks,

Adam
 
Adam,

For in cell dropdowns using Data Validation. Debra Dalgleish has
a good tutorial on her site.
http://www.contextures.com/xlDataVal01.html

another:
http://www.beyondtechnology.com/tips018.shtml

Out of cell use:

Combo Box (Forms Menu)
Right click and choose Format Control
Under the Control tab the Input Range is the data you want listed
in the combo box. The Cell Link is the cell you want the index of
the selected item entered in

Combo Box (Control Toolbox)
Right click and choose properties (must be in design mode)
in the ListFillRange property enter the range you want to appear in
the dropdown. In the LinkedCell enter the cell you want the
selected item to appear in.

Dan E
 
-----Original Message-----
I'm trying to build a drop down list into a worksheet and
am not sure how to do it, of if Excel is even capable of
doing it. The list will have around 30 entries in it,
with each entry related to a value in another cell. Can
anyone tell me how to do this?

Thanks,

Adam

.
Click to expand...
from the menu pick Data, then Validation, in the allow box
select list. For the Source pick the range of cells
containing the entries.
 
-----Original Message-----
Combo Box
Click to expand...
you define for the cell wich text/words should be in a
list. You can copy it to other cels as well. In this way
you press on the errow in the cell and select the entry.
N.
 
Back
Top