| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| Range that expand | Excel Discussion (Misc queries) | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
| Data Range Will Not Expand | Excel Worksheet Functions | |||
Hybrid Mode
