Excel multi-word list items possible?
January 21, 2011 12:01 PM Subscribe
Excel question: Is there any way to have multi-word options (without underscores) in a drop-down list that will be used as a condition for a second drop-down list?
posted by Awkward Philip to technology (2 answers total) 1 user marked this as a favorite
For example, List A consists of "Fruits", "Veggies", and "Meat". If the user selects Fruits, Excel goes to a list that I have named "Fruits" and displays those items, say "Apple", "Pear", and "Orange".
But what if I want an item in List A to have multiple words, say "Fruits and Veggies"? In that case, there would be no way to connect it to a list, because names in Excel can't have spaces. I know that I could call it "Fruits_and_Veggies", but I'd like to avoid that if at all possible. Is there any way to do this?
I'm using Excel 2003 for Windows, BTW.