How do I create drop down lists in Excel for correct data entry
 

I am entering information in an Excel file and would like users to select
pre-defined value for a particula coloum.

How do I create drop down lists in Excel for correct data entry
 

You can use Data Validation to create a dropdown list in a cell. There
are instructions in Excel's Help, and he

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

Utpal Kapadia wrote:
I am entering information in an Excel file and would like users to select
pre-defined value for a particula coloum.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html