Adding drop-down list to spreadsheet

K

KDill

Hello All-
I need to add a drop-down button to my worksheet. I'm trying to be able to
get the wkst user to be able to choose from the selections in the list. I
have tried everything and can't seem to figure it out. Anybody know how I do
this?
 
B

bpeltzer

In the cell where the selection is to be made, use Data > Validation. Select
List in the first drop-down then in the text box either type the allowed
values (separated by commas) or select a set of cells (from the same sheet)
containing those values.
 
C

CWillis

Data--->Validation---->Settings Tab--->Allow List

In source: First thing in list,Second thing in list,etc.

-chris
 
G

Gord Dibben

The list source can be on another worksheet if you give the listrange a Name and
use that Name in the source dialog

i.e. =MyList


Gord Dibben MS Excel MVP
 
Top