Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ron
 
Posts: n/a
Default 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?
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
  #3   Report Post  
sue walton
 
Posts: n/a
Default

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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding value to drop down list neb Excel Discussion (Misc queries) 3 June 24th 05 01:40 PM
Text to Columns from drop down list update Kurgan Excel Discussion (Misc queries) 0 June 21st 05 12:14 PM
Drop Down List for Chart savior1 Excel Discussion (Misc queries) 2 May 3rd 05 10:51 PM
how can I count distinct names in an excel list? RPC@Frito Excel Discussion (Misc queries) 5 February 3rd 05 09:12 PM
Pull unique names for drop down list [email protected] Excel Discussion (Misc queries) 3 February 1st 05 10:23 PM


All times are GMT +1. The time now is 09:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"