Drop down list

[Leighton Barnish]

I'd like to transform a selection of cells in a column to
be drop down lists forcing people to choose one of the
choices. I don't want to use the control or forms to draw
the list box over the cell.

how can I change the cells to be drop down lists with
values that I want to pre-set?

Thanks,
LB

 

[Govind]

Hi,

Use Data -> Validation. In the validation criteria, choose List from the
dropdown and in the source give reference to your list of cells which
have the choices

Regards

Govind.

 

[Bob Phillips]

Sounds like you want Data Validation. Take a look at
http://www.contextures.com/xlDataVal01.html

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Debra Dalgleish]

You can use Data>Validation to create a dropdown list in a cell. For a
short list, you can type the values in the Data Validation dialog box.
For longer list, refer to a list in the workbook.

There are instructions in Excel's Help files, and here:

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