Expand a Named Range in 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nanette - 25 Apr 2007 22:50 GMT

Hi all,

I'm actually an experienced user, but am now using Excel 2007 and can't find
how to expand my named range. It's been changed and I'm not able to find it
in the help section.

HELP!

Reply to this Message

ChesterCoronel - 26 Apr 2007 02:36 GMT

I believe you want to change which cells that a particular name refers to
right? If so you can use the Name Manager under the defined names group of
the formulas tab. From there you can select the name then modify which cells
does it refers to on the refers to textbox.

Signature

Chester C. Coronel
Junior BSIT Student
University of Asia and the Pacific, Philippines
Read the StudentEmpowered Blog!http://msforums.ph/blogs/chestercoronel

> Hi all,
>
[quoted text clipped - 3 lines]
>
> HELP!

Reply to this Message

Nanette - 26 Apr 2007 22:08 GMT

Thanks Chester,

That is exactly what I was looking for.

> I believe you want to change which cells that a particular name refers to
> right? If so you can use the Name Manager under the defined names group of
[quoted text clipped - 8 lines]
> >
> > HELP!

Reply to this Message