Delete Named Ranges

[monagan]

I have a Named Range, ALASKA)
With some cities in Alaska in the Range. I need to add more cities, and I want to be able to change the range to include more cells.

Also I need to change the named ranges to include less.

So basically...

How do I delete the name for a named range?

 

[mbarron]

Go to Insert/Names>Define

Mike

 

[AnotherHiggins]

To create, edit or delete Named Ranges, go to Insert>Name>Define

You may want to look into creating dynamic ranges. See faq68-1331 for more info on how to created named ranges that will grow and shrink along with your source data!

John