| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering multiple data into list | Excel Discussion (Misc queries) | |||
| entering data from a list | Excel Worksheet Functions | |||
| Entering data from dropdown list | Excel Discussion (Misc queries) | |||
| Data Validation lists - entering value not in list | Excel Discussion (Misc queries) | |||
| Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
Linear Mode
