| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a dropdown list within a column
I have an existing XLS file with a column that is currently manually
populated. However, I would like to create a dropdown list for my end users so they can choose a value from the dropdown list to populate this specific field. However, I can't seem to find how to go about creating one in Excel - any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a dropdown list within a column
Click into the cell you wish to display your drop down list in. To create a
drop down list got to Data and Validation. In the settings tab under Validation Criteria choose List from the Allow box. Make sure the Ignore blank and In-cell dropdown boxes to the right are ticked. In source highlight the range of cells you wish to use, these will be automatically Absoluted by the program. If you wish to apply this list to more than one cell with the same settings make sure to tick the box. Click OK Your drop down arrow will appear to the right of the cell. Just click the arrow to open the menu and choose the appropriate item from the list. I hope this solves your problem. "dsebiz" wrote: I have an existing XLS file with a column that is currently manually populated. However, I would like to create a dropdown list for my end users so they can choose a value from the dropdown list to populate this specific field. However, I can't seem to find how to go about creating one in Excel - any help would be appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a dropdown list within a column
Thank you for the information - it resolved my issue!
"Tara @ Fuinneoga Computer Training" wrote: Click into the cell you wish to display your drop down list in. To create a drop down list got to Data and Validation. In the settings tab under Validation Criteria choose List from the Allow box. Make sure the Ignore blank and In-cell dropdown boxes to the right are ticked. In source highlight the range of cells you wish to use, these will be automatically Absoluted by the program. If you wish to apply this list to more than one cell with the same settings make sure to tick the box. Click OK Your drop down arrow will appear to the right of the cell. Just click the arrow to open the menu and choose the appropriate item from the list. I hope this solves your problem. "dsebiz" wrote: I have an existing XLS file with a column that is currently manually populated. However, I would like to create a dropdown list for my end users so they can choose a value from the dropdown list to populate this specific field. However, I can't seem to find how to go about creating one in Excel - any help would be appreciated. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a dropdown list within a column
Delighted I could help!!
"dsebiz" wrote: Thank you for the information - it resolved my issue! "Tara @ Fuinneoga Computer Training" wrote: Click into the cell you wish to display your drop down list in. To create a drop down list got to Data and Validation. In the settings tab under Validation Criteria choose List from the Allow box. Make sure the Ignore blank and In-cell dropdown boxes to the right are ticked. In source highlight the range of cells you wish to use, these will be automatically Absoluted by the program. If you wish to apply this list to more than one cell with the same settings make sure to tick the box. Click OK Your drop down arrow will appear to the right of the cell. Just click the arrow to open the menu and choose the appropriate item from the list. I hope this solves your problem. "dsebiz" wrote: I have an existing XLS file with a column that is currently manually populated. However, I would like to create a dropdown list for my end users so they can choose a value from the dropdown list to populate this specific field. However, I can't seem to find how to go about creating one in Excel - any help would be appreciated. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a dropdown list within a column
Watch this 5 min video:
http://youtube.com/watch?v=t2OsWJijrOM -- Biff Microsoft Excel MVP "dsebiz" wrote in message ... I have an existing XLS file with a column that is currently manually populated. However, I would like to create a dropdown list for my end users so they can choose a value from the dropdown list to populate this specific field. However, I can't seem to find how to go about creating one in Excel - any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dropdown List that populates another column | Excel Worksheet Functions | |||
| Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
| Creating a Dropdown List | Excel Worksheet Functions | |||
| Creating a dropdown list | Excel Discussion (Misc queries) | |||
| creating a dropdown list in excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
