How to Find a Name Range in Excel

puneet-gogia-excel-champs-09-06-23

- by Puneet

In Excel, naming a range of cells is the easiest and fastest way of referring to those cells in the formula. You can create multiple name ranges in the spreadsheet and use them as cells reference while applying the formula.

But sometimes, if you have multiple named ranges within the workbook, it may become difficult to remember the names and locations of the name ranges.

So, in this tutorial, we will show you how to find the name ranges within the current workbook.

Steps to Find the Name Range Using Name Manager

The best and recommended way to find all the name ranges within the entire workbook is by “Name Manager”. From it you can also edit the relative cells of any named range and change the name of any named range by following the below steps:

  1. First, go to the “Formulas” tab and then click on the “Name Manager” icon under the “Defined Names” group.
  2. Or first, press and hold the “Ctrl” key and then press the “F3” key.
    name-manager-icon
  3. At this point, you will get the “Name Manager” dialog box opened.
  4. In this, you will find all the name ranges with their names under the “Name” tab and the location (sheet name) including the range of cells given to them under the “Refer To” tab.
  5. From here, double-click on any of the name range which you want to edit or go to the relative cells of that name range.
    name-manager-dialog-box
  6. The moment, you double-click on the individual name range, it will open that name range dialog box as per the image below.
  7. Now, to change the name of this name range, go within the “Name” field and remove the existing name and add the new name, and press OK.
  8. To go to the referred cells, click on the last of the given reference and it will take you to the referred cells.
    edit-name-range-dialog-box
  9. From here, you can re-select the cells range and the range will get updated.
  10. you can see it within the “Refers to” field in the dialog box, and then press OK.
    reselect-the-range

Find Name Range Using Go To Option

  1. First, go to the “Home” tab and then click on the “Find & Select” icon and then click on the “GO TO” option to open the “GO TO” dialog box.
  2. Or simply press the “Ctrl + G” keyboard shortcut and it will open the “GO TO” dialog box.
    go-to-option
  3. Here in the “GO TO” dialog box, you will find all the name ranges within your workbook.
    go-to-dialog-box

Find the Name Range by Zoom-out

To find the name ranges within the current worksheet, just zoom out the spreadsheet at 30% and you will find the name ranges’ names highlighted on their relative cells.

zoom-out

In the below image, the spreadsheet is zoomed out at 30% and you can see we have two separate name ranges defined within the current spreadsheet on which the names are got highlighted.

highlighted-name-ranges

Find Name Range from Name Box

You can also find the name ranges from the top left “Name Box” of the spreadsheet and to go to the relevant cells of the name range just click on it.

name-box