Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List complication
I have a drop down list in EXCEL 2007 that includes the values from a range
that contains 8000 cells. Each one of these cells contains a formula. This worksheet is a template that could at times use all 8000 cells, but usually many of them will be blank. The problem is, since they include functions, they aren't actually empty, they just output "". This makes the dropdown list very long which makes it difficult to find values in it. How do I fix this problem? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Drop dow list complication | Excel Discussion (Misc queries) |