pull down menus

[Montana]

How do I insert pull down menus in an Excel Spreadsheet?

 

[Dave Peterson]

Maybe data|validation.

Debra Dalgleish shares some instructions:
http://contextures.com/xlDataVal01.html

 

[Lisa]

Did you ever get an answer to this? This is exactly my question as well. I
know you can do it. I even took a class that showed me how once, but too
long ago to remember however.

 

[Dave Peterson]

Maybe data|validation would work for you.

Did you ever get an answer to this? This is exactly my question as well. I
know you can do it. I even took a class that showed me how once, but too
long ago to remember however.

 

[Lisa]

Hey !! The Tech guy here in the office just showed me. Highlight the
column or columns that you would like the pull down on, go to Data at the top
of your screen, right click, Fliter, right click, Auto filter. The pull down
arrow should be there should be there....
Good luck,
L

 

[Mike Monahan]

I followed the link below - very helpful! Only trick I can't nail is pulling
the fill color or the 'bold' font from my source list to the destination.
Any ideas?

 

[Dave Peterson]

Data|Validation won't work this way.

I followed the link below - very helpful! Only trick I can't nail is pulling
the fill color or the 'bold' font from my source list to the destination.
Any ideas?

 

[Mike Monahan]

Thank you - see RagDyeR's post of 4/24/07 for more helpful advice on this
topic:

http://www.microsoft.com/office/com...5298&catlist=&dglist=&ptlist=&exp=&sloc=en-us

Respectfully,
Mike