See all How-To Articles

Find the Location of a Named Range in Excel & Google Sheets

This tutorial will demonstrate how to find the location of a named range in Excel & Google Sheets.

 

FindLocation Intro

 

When you have existing range names in Excel, you can view these range names and the cells that they refer to with Name Manager.

Find the Location of a Named Range in the Name Manager

1. First, open the Excel file that contains the named ranges.

2. Then, in the Ribbon, select Formulas > Defined Names > Name Manager.

 

EditRangeNames Ribbon

 

The Name Manager contains all the range names in the current workbook.

 

EditRangeNames Name Manager

 

3. To see the range of cells that an individual range name refers to, click on the Name desired. The Refers to box at the bottom of the Name Manager will show the sheet name and the cell addresses of the named range.

 

FindLocation refersto

 

You can also view the range of cells that each range name refers to by looking at the Refers to column in the Name Manager.

 

FindLocation Intro

 

Find the Location of a Named Range in Google Sheets

With the Google sheet containing range names open, in the Menu, select Data > Named ranges.

 

EditRangeNames GS Ribbon

 

A list of all the range names that are contained in the Google Sheet will be shown down the right hand side of the sheet. The location of each named range is shown in the range indicated beneath each range name.

 

FindLocation GS