See all How-To Articles

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

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

 

RangeNames Intro

 

Delete Range Name

To delete a range name in our worksheet, we need to access the Name Manager.

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

 

Range Names Ribbon

 

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

Range Names Name Manager

 

  1. Select the Name to delete, and then click the Delete button.

 

Range Names Delete

 

  1. 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, select Data > Named Ranges.
  2. Click on the range name, and then click Edit.

 

RAnge Names Google Sheets Name Manger Edit

 

  1. Click the Delete button.

 

Range Names Google Sheets Delete

 

  1. Click Remove to remove the range name.

 

Range Names Google Sheets Remove