how do i do a "drop down selection menu"?

[sokevin]

Hi Gurus,

Does anyone know how to do a drop down selection menu in excel?

i want to do a drop down selction so i can select the a date eg select
jan, feb, mar, april etc etc

cheers

 

[M. lane]

First you need to make your list (one entry per cell).
Click the (cell) location where you want the drop down list to be, click
data, validation and on the settings tab, in the allow box, choose "list",
place the cursor in the "source" box, and then highlight all cells to be a
part of your consolidated list. Make sure the Ignore blank box is checked
and the In cell dropdown is checked as well. That will give you a drop down
list.

 

[Debra Dalgleish]

You can use Data>Validation. There are some instructions here:

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