extend the range of cells for a drop down list

M

Marge

I have a range of cells (named staff) on a worksheet in the workbook where
the drop down list will be used. Additional cells were added to the range of
cells, but I can't get Excel to include them on the named list. Can I not
expand the range of cells or do I need to name the expanded list with a new
range name?
 
D

Don Guillett

use a self adjusting defined name such as mylist and in the refers to box

=offset($a$1,1,0,counta($a:$a),1)
 
O

Otto Moehrbach

Marge
If you're using Excel 2007, simply delete the name "staff" and then name
the new list "staff". In earlier versions you can simply name the new list
"staff" without having to first delete that name. HTH Otto
 
M

Marge

I'm working with Excel 2003. I tried selecting the expanded list and naming
it "staff"...it reverts back to the unexpanded list.
 
D

Don Guillett

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
 
G

Gord Dibben

Select "staff" in insert>name>defined names.

In the "refers to" dialog simply edit the range and OK

I like Don's suggestion of a dynamic range best however.


Gord Dibben MS Excel MVP
 
O

Otto Moehrbach

Marge
In 2003, when you do Insert - Name - Define, if you select the name, it
will revert back to the old list. Don't select the name. Type it in. HTH
Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top