ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to create a pull down menu for selection? (https://www.excelbanter.com/excel-worksheet-functions/76535-how-create-pull-down-menu-selection.html)

Eric

How to create a pull down menu for selection?
 
Does anyone know how to create a pull down menu in a cell ? so I can select
the option, such as Easy, Normal, Difficult.
Thank you
Eric

David Billigmeier

How to create a pull down menu for selection?
 
<Data<Validation
Choose Settings tab (default)
In the "Allow" box choose list
In the "Source" box choose the range on your worksheet that contains
information you would like in your list.

--
Regards,
Dave


"Eric" wrote:

Does anyone know how to create a pull down menu in a cell ? so I can select
the option, such as Easy, Normal, Difficult.
Thank you
Eric


Ron Coderre

How to create a pull down menu for selection?
 
See Debra Dalgleish's Contextures website for a good instructions on Data
Validation:

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

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Eric" wrote:

Does anyone know how to create a pull down menu in a cell ? so I can select
the option, such as Easy, Normal, Difficult.
Thank you
Eric



All times are GMT +1. The time now is 11:01 AM.

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