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

Maybe data|validation.

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

Montana wrote:

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

--

Dave Peterson

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" wrote:

Maybe data|validation.

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

Montana wrote:

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

--

Dave Peterson

Maybe data|validation would work for you.

Lisa wrote:

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" wrote:

Maybe data|validation.

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

Montana wrote:

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

--

Dave Peterson


--

Dave Peterson

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" wrote:

Maybe data|validation.

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

Montana wrote:

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

--

Dave Peterson

Data|Validation won't work this way.



Mike Monahan wrote:

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" wrote:

Maybe data|validation.

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

Montana wrote:

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

--

Dave Peterson


--

Dave Peterson

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

http://www.microsoft.com/office/comm...xp=&sloc=en-us

Respectfully,
Mike

"Dave Peterson" wrote:

Data|Validation won't work this way.



Mike Monahan wrote:

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" wrote:

Maybe data|validation.

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

Montana wrote:

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

--

Dave Peterson


--

Dave Peterson

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

"Montana" wrote:

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