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.

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

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