ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Ho Do I create drop down menu? (https://www.excelbanter.com/excel-worksheet-functions/15190-ho-do-i-create-drop-down-menu.html)

Lu Roe

Ho Do I create drop down menu?
 
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 he

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


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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


Lu Roe

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

"Debra Dalgleish" wrote:

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

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


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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



Diane

Ho Do I create drop down menu?
 
Thank you so much for the info & the link - very easy to following
instructions!!

"Debra Dalgleish" wrote:

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

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


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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



Debra Dalgleish

Ho Do I create drop down menu?
 
You're welcome! Glad the instructions helped.

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

"Debra Dalgleish" wrote:


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

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


Lu Roe wrote:

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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com


Crayola

Ho Do I create drop down menu?
 
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..

"Debra Dalgleish" wrote:

You're welcome! Glad the instructions helped.

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

"Debra Dalgleish" wrote:


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

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


Lu Roe wrote:

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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com



T. Valko

Ho Do I create drop down menu?
 
See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


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

"Debra Dalgleish" wrote:

You're welcome! Glad the instructions helped.

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

"Debra Dalgleish" wrote:


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

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


Lu Roe wrote:

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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com






All times are GMT +1. The time now is 12:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com