| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create drop down lists in Excel for correct data entry
I am entering information in an Excel file and would like users to select
pre-defined value for a particula coloum. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create drop down lists in Excel for correct data entry
You can use Data Validation to create a dropdown list in a cell. There
are instructions in Excel's Help, and he http://www.contextures.com/xlDataVal01.html Utpal Kapadia wrote: I am entering information in an Excel file and would like users to select pre-defined value for a particula coloum. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data entry with drop down lists | Excel Discussion (Misc queries) | |||
| create excel spreadsheet on a data access page | Excel Discussion (Misc queries) | |||
| Update Excel Data List for Drop Down use | Excel Discussion (Misc queries) | |||
| How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
| create a data entry form template in Excel 2003? | Excel Discussion (Misc queries) | |||
Linear Mode
