Selecting from a list

[Dean]

I would like to create, in a cell, a list of predefined
options from which one could be chosen. Like a dropdown
box. Can this be done short of programming??? If so,
how??
Thank you
Dean

 

[Gord Dibben]

Dean

Data>Validation drop-dowm list.

Debra Dalgleish has instructions on this.

http://www.contextures.on.ca/xlDataVal01.html

Gord Dibben Excel MVP

 

[Arvi Laanemets]

Hi

1. Select cell(s). From menu, select Data.Validation.List and enter into
source field your options, using delimiter defined by your windows settings.
Press OK

or
2. Enter all your options into some free column on same worksheet. Select
cell(s) you want to format as combo. Select Data.Validation.List, and into
source field, select the range containing your options. Press OK

or
3. Enter your options into some column on separate worksheet. Define the
range with option as named range (Insert.Name.Define) - fixed or dynamic one
at your will. Select cell(s) you want to format as combo. Select
Data.Validation.List, and into source field, enter the formula
'=YourNamedRange'. Press OK