Expand a Named Range in 2007
 

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!

Expand a Named Range in 2007
 

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.
--
Chester C. Coronel
Junior BSIT Student
University of Asia and the Pacific, Philippines
Read the StudentEmpowered Blog!http://msforums.ph/blogs/chestercoronel


"Nanette" wrote:

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!

Expand a Named Range in 2007
 

Thanks Chester,

That is exactly what I was looking for.

"ChesterCoronel" wrote:

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.
--
Chester C. Coronel
Junior BSIT Student
University of Asia and the Pacific, Philippines
Read the StudentEmpowered Blog!http://msforums.ph/blogs/chestercoronel


"Nanette" wrote:

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!