Drop Down list for entering data
 

Is anyone aware of functionality in Excel 2003 that allows you to create a
drop down list of values in a cell to choose from for entering data? Similar
to the autocomplete functionality- but an actual drop down arrow on the cell
that allows you to point and click on the text you want entered?

Drop Down list for entering data
 

Take a look at Data...Validation

A lot of good tips at:

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



On Dec 13, 2:05 pm, dscmm wrote:
Is anyone aware of functionality in Excel 2003 that allows you to create a
drop down list of values in a cell to choose from for entering data? Similar
to the autocomplete functionality- but an actual drop down arrow on the cell
that allows you to point and click on the text you want entered?