Excel 2007 - Remove Name Range via Name Manager

P

peter

An xls file was provided to me with name ranges and I need to do some
additional work with it and seem to be having a problem. I have saved it off
to xlsx and am tryin to "merge" two ranges they provided, but need to check
each row.

What I want to do is remove the range name. When I go to Formulas - Name
Manager, I see the two ranges. When I select one, the New... and Edit...
buttons are available, but Delete is grayed out.

What steps do I have to take to be able to remove as name range and still
have the data there to work further with it?
 

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

Similar Threads

Remove Identical words 0
Setting a range in a named range 3
Constructing Range Name calls with Concatenate 4
Start a mail merge upon opening the document 1
Incorporating the User Profile location into a document template path 1
a data validation list that contains a list of named ranges - not alist from a named range 1
Formula Based on Values in Named Range Q 5
Hyperlinks with lookups 0

Top