I have a drop down list in Excel & would like to add more names...how do I do this?
R Ron Sep 17, 2005 #1 I have a drop down list in Excel & would like to add more names...how do I do this?
D Dave Peterson Sep 17, 2005 #2 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
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
S sue walton Sep 17, 2005 #3 Go to Data>Validation in Validation Crieria>choose List and add the names to the list
