Naming ranges

K

Khalil Handal

Hi,
Can we rename a range name? if yes, How?
Is there a site where I can read more about it?
 
B

Bill Ridgeway

To rename a range-
Highlight the cells to be named
Click on <Insert><Name><Define>
Type in the name and click on <OK>

To delete the extant name-
Click on <Insert><Name><Define>
Highlight the name to be deleted
Click on <Delete>

For additional reading click on F1 and type in define

Regards.

Bill Ridgeway
Computer Solutions
 
F

FSt1

hi,
Select the named range you wish to rename.
on the menu bar....Insert>Name>Define.
select the name you wish to rename.
Click the delete button. click ok.
on the menu bar... Insert>Name>Define.
Rename the still selected range.
Click the add button. click ok.
range now renamed.

hope this helped.
regards
FSt1
 
K

Khalil Handal

Thanks to both of you!
It worked fine.

FSt1 said:
hi,
Select the named range you wish to rename.
on the menu bar....Insert>Name>Define.
select the name you wish to rename.
Click the delete button. click ok.
on the menu bar... Insert>Name>Define.
Rename the still selected range.
Click the add button. click ok.
range now renamed.

hope this helped.
regards
FSt1
Click to expand...
 
N

Nick Danger

Can someone please describe how to rename or delete a named range in Excel
2007?
 
P

Peo Sjoblom

Insert > name > define, from there you should be able to figure out how to
do the rest
 
N

Nick Danger

Excel 2007 doesn't have a menu bar. It does have an Insert tab on the
ribbon, but there's nothing there that maps to "Name" on the Insert menu
pulldown.
 
H

Harlan Grove

Nick Danger said:
Excel 2007 doesn't have a menu bar. It does have an Insert tab on the
ribbon, but there's nothing there that maps to "Name" on the Insert menu
pulldown.
Click to expand...
....

But it supports Excel 2003 keyboard sequences mimicking KEYBOARD use of the
Excel 2003 menu. Hold down an [Alt] key and press I (for Insert), then press
N (for Name) then D (for Define).
 
N

Nick Danger

Harlan Grove said:
Nick Danger said:
Excel 2007 doesn't have a menu bar. It does have an Insert tab on the
ribbon, but there's nothing there that maps to "Name" on the Insert menu
pulldown.
Click to expand...
...

But it supports Excel 2003 keyboard sequences mimicking KEYBOARD use of
the Excel 2003 menu. Hold down an [Alt] key and press I (for Insert), then
press N (for Name) then D (for Define).
Click to expand...

Thanks, Harlan. That worked. It also gave me the clue I needed. It appears
the preferred way to do it in Excel 2007 is to ckick on the "Formulas" tab,
and then click on "Name Manager."
 
Top