How do I add names to a drop down list?
 

I have a drop down list in Excel & would like to add more names...how do I do
this?

Maybe using a dynamic name that grows and contracts with the list would work for
you.

Debra Dalgleish explains it:
http://contextures.com/xlNames01.html#Dynamic

Ron wrote:

I have a drop down list in Excel & would like to add more names...how do I do
this?

--

Dave Peterson

Go to DataValidation
in Validation Crieriachoose List and add the names to the list

"Ron" wrote:

I have a drop down list in Excel & would like to add more names...how do I do
this?