drop down column

  • Thread starter Thread starter mandy
  • Start date Start date
Select the entire range, then do Data / Validation / List - Choose the list. Each will now have
a dropdown
 
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
 
Back
Top