Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
instructions on how to generate a "pull down menu" in Excel 2000
Where can I find instructions on how to generate a pull down menu in a cell
in Excell 2000? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
instructions on how to generate a "pull down menu" in Excel 2000
I assume you are speak of data validation. Enter your list of values in some
range of cells. The select the cell(s) in which you want to display the dropdown list. Go to the Data menu, and choose Validation. In the "Allow" list, choose "List" and set the Source Range to the cells in which the list of values resides. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Inquiring Mind" <Inquiring wrote in message ... Where can I find instructions on how to generate a pull down menu in a cell in Excell 2000? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"list unique" instructions fr xldynamic site doent work | Excel Worksheet Functions | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
Sheets("Rpt").Copy different results from running in macro than off excel menu?? | Excel Discussion (Misc queries) | |||
I am unable to "print screen" flollowing the instructions in HELP | Excel Discussion (Misc queries) | |||
if "a" selected from dropdown menu then show "K" in other cell | Excel Worksheet Functions |