Drop down menus in excel

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.
 
P

Patrick Molloy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top