Drop down list

[Rusty]

When I "name" a range and put that name into the selection while creating the
drop down list. Then go to the cell and click on the arrow all i see is the
name of the range and it doesn't show the list to allow selection?

 

[Gord Dibben]

You must enter as =myrange

Note the "=" sign


Gord Dibben MS Excel MVP