See all How-To Articles

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

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

RangeNames Intro

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.

Range Names Ribbon

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

Range Names Name Manager

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

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

Range Names Google Sheets Name Manager Edit

  1. Click the Delete button.

Range Names Google Sheets Delete

  1. Click Remove to remove the range name.

Range Names Google Sheets Remove

Also see

See all How-To Articles