Delete / Remove Named Range(s) in Excel & Google Sheets

This tutorial demonstrates how to remove named ranges in Excel and Google Sheets.

Delete Range Name

To delete a range name in a worksheet, access the Name Manager.

1. In the Ribbon, go to Formulas > Defined Names > Name Manager.

The Name Manager shows all named ranges in the Worksheet and Workbook.

2. Select the Name to delete, and then click Delete.

3. Click OK to delete the range name, and then click Close to close the Name Manager.
   Alternatively, you can use macros to delete range names.

Delete Range Name in Google Sheets

1. In the Menu, go to Data > Named Ranges.
2. Click on the range name, and then click Edit.

3. Click the Delete button.

4. Click Remove to remove the range name.

Also see

• Resolve a Name Conflict for a Named Range
• Paste Range Names
• Edit Named Ranges