how to edit named range?

  • Thread starter Thread starter Steven
  • Start date Start date
Steve, go to the Menu bar and Insert > Name > Define. Select the name and do
your edit in the "Refers to" field at the bottom, then OK.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com
 
Highlight the range and go to the Insert Menu, Select Name and Define.

Or

Higlight the range and select the name box (Just above cell A1) type i
the name and press return.

Pet
 
And while editing the "Refers-To" box, you can use F2 to change the cursor
from Point-To mode (where using an arrow key will insert cell addresses) to
Insert mode (where you can edit the existing address as normal text).

I am embarassed to say how long it took me to figure that one out.
 
You must log in or register to reply here.

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

Edit named range 1
Frequency of items in a huge range 3
Count in a range of numbers 8
Excel Run macro upon cell edit 0
name ranges 2
Recalculate edited Arrays 1
Excel Named Ranges and Conditional Format 3
Excel VBA - counting cells by colors and names to it in two different rows. 0

Back
Top