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

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on July 23, 2023

This tutorial demonstrates how to find the location of a named range in Excel and 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, go to Formulas > Defined Names > Name Manager.

Edit Range Names Ribbon

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

Edit Range Names Name Manager

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

Find Location refers to

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, go to Data > Named ranges.

EditRangeNames GS Ribbon

Down the right side of the sheet, see a list of all the range names in the Google Sheet. The location of each named range is shown in the range indicated beneath each range name.

FindLocation GS

Also see

AI Formula Generator

Try for Free

See all How-To Articles