| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dropdown list contains 5 items want to add 100 how
I have an existing dropdown list containing 5 rows with data ,I want to add
100 more items how do i do so thx vince |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
dropdown list contains 5 items want to add 100 how
Click on Data | Validation and under Allow click on List and then
adjust the range of your data in the Source box. Hope this helps. Pete On Apr 30, 11:07*am, wojick wrote: I have an existing dropdown list containing 5 rows with data ,I want to add 100 more items how do i do so thx vince |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I create a dropdown list to select multiple items | Excel Worksheet Functions | |||
| select multiple items from a dropdown list | Excel Worksheet Functions | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
| Dropdown list in PivotTable has deleted items. How to omit? | Excel Discussion (Misc queries) | |||
| is it possible to re-size or format list items in dropdown box? | Excel Discussion (Misc queries) | |||
Linear Mode
