Microsoft Office Tutorials and References
In Depth Information
Delete a Range Name
Working with Range Names
Excel asks you to confirm the
6 Click OK.
A Excel deletes the range
7 Repeat Steps to to delete 6
other range names as
8 Click Close .
Excel closes the dialog box
and returns you to the
Is there a faster way to delete multiple range names?
Yes, you can delete two or more range names at once. First, follow Steps to to display the 3
Name Manager dialog box. Next, select the range names you want to delete: To select
consecutive names, click the first name you want to delete, hold down , and then click
the last name you want to delete; to select non-consecutive names, hold down and click
each name you want to delete. When you have selected the names you want to remove, click
Delete , and then click OK when Excel asks you to confirm the deletion. Click Close to return
to the worksheet.