Ho Do I create drop down menu?

[Guest]

I am doing invoices in Excel. Can I create a drop down menu for different
categories in Excel?

 

[Debra Dalgleish]

You can use Data Validation to create dropdown lists. There are
instructions
in Excel's help, and here:

http://www.contextures.com/xlDataVal01.html

 

[Guest]

Thank you Debra; I didn't know what to call it when I tried to look in "help".
Lu

 

[Diane]

Thank you so much for the info & the link - very easy to following
instructions!!

 

[Debra Dalgleish]

You're welcome! Glad the instructions helped.

Thank you so much for the info & the link - very easy to following
instructions!!

:

 

[Crayola]

im curious as to how to create a drop down menu and display other information
along side it. I have a list of movies which i want in a drop down menu, and
when a movie is selected, it would along side it in other cell provide
additional information to that selection ie: The Hulk when selected would
provide additional information to the right of it, like size, etc..

 

[T. Valko]

See this:

http://contextures.com/xlFunctions02.html