Naming ranges

[Khalil Handal]

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

 

[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

 

[Guest]

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

 

[Khalil Handal]

Thanks to both of you!
It worked fine.

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

 

[Nick Danger]

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

 

[Peo Sjoblom]

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

 

[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.

 

[Harlan Grove]

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.

....

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).

 

[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.

...

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).

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."

 

[DaveNeath]

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

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The quickest way to get to the Define Name dialog is the Ctrl-F3
shortcut.

For more about range names see http://www.cpearson.com/excel/named.htm

Best Regards
Dave

 

[Khalil Handal]

Thanks to you all. It helped.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The quickest way to get to the Define Name dialog is the Ctrl-F3
shortcut.

For more about range names see http://www.cpearson.com/excel/named.htm

Best Regards
Dave