Update Excel Data List for Drop Down use

[Guest]

I have created data lists that were named (name field left of formula field)
and have those lists tied to cells as drop down data validation options. I
now need to add additional entries to the data lists, but am unable to get
them added into the existing groups. I've tried re-highlighting and naming
again - no go.
I am an admitted novice, but really look forward to getting this recurring
document as drop and click as possible. Appreciate any help.

 

[Debra Dalgleish]

You could use a dynamic range, that would automatically expand to
include new entries. There are instructions here:

http://www.contextures.com/xlNames01.html

Or, to redefine the existing range:
Choose Insert>Name>Define
Select the name in the list
In the Refers to, change the cell reference
Click OK

 

[Guest]

This can be as easy as inserting a cell in the middle of the range that you
initially created, this will update the data that is referenced by the
validation program.