Drop down menus in excel
 

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.
--
Hairy Gerry

Drop down menus in excel
 

You may refer the below link
http://www.contextures.com/xlDataVal01.html

If this post helps click Yes
---------------
Jacob Skaria


"Hairy" wrote:

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.
--
Hairy Gerry

Drop down menus in excel
 

In the ribbon ?, in a cell ?

What do you want to do with them ?

Tim

"Hairy" wrote in message
...
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.
--
Hairy Gerry

Drop down menus in excel
 

This may help:
http://video.google.com/videosearch?...itle&resnum=4#

2007?
http://office.microsoft.com/en-us/ex...316081033.aspx

One mo
http://www.homeandlearn.co.uk/excel2...l2007s8p3.html


HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Tim Williams" wrote:

In the ribbon ?, in a cell ?

What do you want to do with them ?

Tim

"Hairy" wrote in message
...
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.
--
Hairy Gerry

Drop down 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.




"Hairy" wrote in message
...
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.
--
Hairy Gerry