Microsoft Office Tutorials and References
In Depth Information
Delete a Range Name
Delete a
Range Name
If you have a range name that you no longer need,
you should delete it. This reduces clutter in the
Name Manager dialog box, and makes the Name box
easier to navigate.
Note, however, that deleting a range name will
generate an error in any formula that uses the name.
This occurs because when you delete a range name,
Excel does not convert the name to its range
coordinates in formulas that use the name.
Therefore, before deleting a range name, you should
convert that name to its range coordinates in every
formula that uses the name.
Delete a Range Name
1 Open the workbook that contains
the range name you want to
delete.
2 Click the Formulas tab.
3 Click Name Manager .
Note: You can also open the
Name Manager dialog box by
pressing
+
.
The Name Manager dialog box
appears.
4 Click the name you want to
delete.
5 Click Delete .
Search JabSto ::




Custom Search