Id like to create a DropDown list from a Named Range containing all months in the year, but also id like to add a static value at the beginning of the list called "All" im wondering if that's possible!

  • 1
    What have you tried so far and where is the problem? – cybernetic.nomad Feb 14 at 19:40
  • Tried using INDIRECT and & when setting the list source but didnt work, i have no idea what else to try, i know i could add a row to the table containing the months but that would make it dirty and i couldnt reuse same named range for places where i dont want the All option to be available – DSB Feb 14 at 19:45
  • 1
    Have you tried adding the value you want to be able to choose from to the list in the named range? – Alex M Feb 14 at 19:58
  • Use one list and two overlapping named ranges (one for the months and the other for "All" + the months) – cybernetic.nomad Feb 14 at 20:18
  • @DSB,, use dependent drop down with 2 list ,, 1st list Month name & 2nd should ALL & Months,, and let me remind every value itself is static,, but never the list is !! – Rajesh S Feb 15 at 6:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.