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

Utpal Kapadia · Jan 21, 2006

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

Debra Dalgleish · Jan 21, 2006

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