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.
 
Back
Top