G Guest Jan 21, 2006 #1 I am entering information in an Excel file and would like users to select pre-defined value for a particula coloum.
I am entering information in an Excel file and would like users to select pre-defined value for a particula coloum.
D Debra Dalgleish Jan 21, 2006 #2 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
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