ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   instructions on how to generate a "pull down menu" in Excel 2000 (https://www.excelbanter.com/excel-discussion-misc-queries/161278-instructions-how-generate-pull-down-menu-excel-2000-a.html)

Inquiring Mind

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?

Chip Pearson

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?




All times are GMT +1. The time now is 03:40 PM.

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