Thread: Drop Down list for entering data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
willwonka[_2_] willwonka[_2_] is offline
external usenet poster
  
Posts: 14
Default 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?

Reply With QuoteReply With Quote