Excel

[Joe]

How do you create a drop down list in excel? anyone.

 

[Lise]

-----Original Message-----
How do you create a drop down list in excel? anyone.
.
Select the cell you want it to appear in, go to Data,

Validation, uder Allow chose list and in Source enter the
items you want listed in the drop down menu.

Lise

 

[Tod]

There are a couple ways to do this. If you want a quick
and dirty method of just choosing from a list of values
that are already in the column, you can use a built-in
feature called 'Pick from List'. Just right click in a
cell and choose Pick from List.

Another solution is to choose the Combo Box from the
Contorl Toolbox toolbar. Once drawn, choose the properties
by right clicking on the combo box. For ListFillRange, put
the worksheet range for the list of values you want to
appear. Click the Design Mode icon on the toolbar. Now
when you pull down the combo box, you'll see your values
listed there.

tod

 

[Frank Kabel]

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