delete or edit named dell ranges

[chris31849]

i have named a range of cell for validation use but i need to expand the list
so i need to either figure out how to expand the named range or delete the
named range and start over. thanks in advance for any replies on this.

 

[Guest]

Hi

Go to Insert / Name / Define and edit the range in there.

Andy.

 

[Doug Kanter]

i have named a range of cell for validation use but i need to expand the
list
so i need to either figure out how to expand the named range or delete the
named range and start over. thanks in advance for any replies on this.

Select your new range. Click Insert, Name, Define and enter the same name as
before. That will overwrite Excel's recognition of the previous range.

 

[Dave Peterson]

Or maybe use a dynamic named range that grows or contracts with your data.

See Debra Dalgeish's site for some nice tips:
http://contextures.com/xlNames01.html#Dynamic

 

[chris31849]

that site is very helpful. thanks again!!

Or maybe use a dynamic named range that grows or contracts with your data.

See Debra Dalgeish's site for some nice tips:
http://contextures.com/xlNames01.html#Dynamic