Microsoft Office Tutorials and References
In Depth Information
Change a Range Name
Change a
Range Name
You can change any range name to a more suitable
or accurate name. Changing a range name is useful if
you are no longer satisfied with the original name
you applied to a range or if the existing name no
longer accurately reflects the contents of the range.
You might also want to change a range name if you
do not like the name that Excel generated
automatically from the worksheet labels.
If you want to change the range coordinates
associated with a range name, see the second tip
in this section.
Change a Range Name
1 Open the workbook that contains
the range name you want to
change.
2 Click the Formulas tab.
3 Click Name Manager .
The Name Manager dialog box
appears.
4 Click the name you want to
change.
5 Click Edit .
Search JabSto ::




Custom Search