Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list
Hi folks,
I have 3 drop down lists on sheet 1 of a spreadsheet, all of which relate to other sheets in the workbook. Can I set the drop down lists up to allow for future expansion of the other worksheets. In Validate Data, i have tried increasing the range of the source but this leaves a number of blanks at the end of the drop down box. Although this solves the problem I was hoping for some advice on a neater way to achieve my aims. Thanks for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
drop down list multiple columns | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |