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)
 
Back
Top