I've recently needed to create drop down lists. I see from several places that it can be done by typing each choice into individual cells, assigning the ranges a name, and using INDIRECT to reference the named range. I understand how that works, but is there any way of doing the same thing without having to list out the menu items in separate cells?