Drop down menus in excel

  • Thread starter Thread starter Hairy
  • Start date Start date
H

Hairy

Please Help as I am at my wits end
I am new to the group and I am working on excel 2007 version. Could somebody
PLEASE help me how to create dropdown menus in excel.
 
data validation?

lets say you have a list in D2:D10

select any other cell, eg B2, then from the DATA menu, select Data
Validation from the Data Tools group

in the data validation form, set Allow to LIST and the source to =D2:D10
if the table D2:D10 is rangenamed, eg dataList , then in the validation form
source put =dataList

click OK to close the data validation form.
 
Back
Top