This tutorial demonstrates how to find the location of a named range in Excel and Google Sheets.
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
- First, open the Excel file that contains the named ranges.
- Then, in the Ribbon, go to Formulas > Defined Names > Name Manager.
The Name Manager contains all the range names in the current workbook.
- 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.
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.
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.
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.