how to edit named range?

D

DDM

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
 
P

Pete JM

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
 
G

George Nicholson

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