drop down column

[mandy]

Is there a way to make all of the cells in one column use
the same drop down menu?

 

[Ken Wright]

Select the entire range, then do Data / Validation / List - Choose the list. Each will now have
a dropdown

 

[Jim]

Assuming you are creating an in-cell dropdown: Select all the cells you want
and Data>Validation>Allow>List and enter into the window an equal sign (=)
and the name of the list =MyList OR enter the range of cells that hold the
list
=A2:A20
OR
enter the members of the list in the window, each separated by a comma:
Jim,amiller,excel,newsgroups