Expand a Named Range in 2007

[Nanette]

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!

 

[ChesterCoronel]

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.

 

[Nanette]

Thanks Chester,

That is exactly what I was looking for.