instructions on how to generate a "pull down menu" in Excel 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Where can I find instructions on how to generate a pull down menu in a cell
in Excell 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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying a Drop Down Menu 2
Menu Behavior 4
Linking choices in drop down menu to have automatic answer... 3
How do I create pull down menus for individual cells? 7
Pull down selections 1
Excel 97 menu items 4
Pull Down Menu Bar 2
How to create a pull down lists? 1

Back
Top