Naming Ranges

  • Thread starter Thread starter Gary Thomson
  • Start date Start date
G

Gary Thomson

Hi,

I have a series of ranges which I have named (using the
Insert->Name->Define menu).

AS a consequence, I also have several functions which use
these names in their formulae.

I have 2 questions:

(1) Can I change the name of the range (i.e. one of my
ranges in called "Schools_Table" and I want the same range
to be called "Schools_Lookup_Table");

(2) If the name of the range can be changed, will all the
relevant formulae in my sheets be updated as a result, or
will I need to manually change each formula that
references that particular range?

Many Thanks,

Gary.
 
You might want to actually try it with a dummy formula and a dummy range..
you'd be done by now.
 
I couldn't resist, and tried the experiment myself.

There isn't a way to change the name, but you can create a new named range
referring to the same cells.

What you can do is define your new range, same as your old one, then delete
the first one. Then select the cells with the formulas containing
Schools_Table, press CTRL H, enter Schools_Table in the top box, and
Schools_Lookup_Table in the bottom box, and replace all if that suits you.
 
Hi Gary,

You cannot change a name, only add a new name or delete an existing name.
And because you are just addin g a new name, any formulae will continue to
use the existing name.

This is clear in the dialog box where the only options are Add and Delete.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top