How to Navigate to a Named Range in Excel (3 Easy Ways)

Sometimes we change the names of cells and ranges as per our need for various purposes in Excel. While working with a large dataset with lots of named ranges, it might become difficult to find and navigate to a specific named range. In this article, we will explain three quick and easy methods to show how to navigate to a named range in Excel.

Table of Contents hide

Download Practice Workbook

3 Suitable Methods to Navigate to a Named Range in Excel

1. Use Go To Feature to Navigate to a Named Range

2. Utilize Name Box Control

3. Use Name Manager Tool

How to Create a Named Range in Excel

Conclusion

Download Practice Workbook

Download this practice workbook to exercise while reading this article.

Navigate to a Named Range.xlsx

3 Suitable Methods to Navigate to a Named Range in Excel

In this article, we will describe three suitable methods to show how to navigate a range in Excel. We will use the following dataset for this purpose. The dataset includes the following six named ranges:

B5:B12 = Names
C5:C12 = Dates
D5:D12 = Products
E5:E12 = Quantity_Sold
F5:F12 = Total_Price
A1:F13 = Print_Area

1. Use Go To Feature to Navigate to a Named Range

In the first method, we will use the “Go To” feature to demonstrate how to navigate a named range in Excel. In this method, we want to navigate to the range E5:E12. Follow these steps to learn how to do it.

Steps:

First of all, press F5 on your keyboard to open the Go To dialogue box.
Then select Quantity_Sold and click on OK.

As a result, you will find that the cell range E5:E12 is selected in your worksheet.

Notes

You can also use the Ctrl + G keyboard shortcut to open the Go To dialog box.

2. Utilize Name Box Control

In this step, we will use the Name Box to navigate to the named range Dates. The process for doing it is discussed below.

Steps:

First, click on the Name Box dropdown and then select Dates.

Consequently, it will navigate you to the range C5:C12.

Similar Readings

3. Use Name Manager Tool

We will now navigate to the named range Print_Area using the Name Manager tool. Read the steps to learn the procedure.

Steps:

First, click on the Formulas tab and go to,

Formulas → Defined Names → Name Manager

The Name Manager dialogue box will appear. From there, double-click Print_Area of your active worksheet.

As a result, the Edit Name pop-up box will open. Click on the upward arrow button in the Refers to box.

Finally, it will show the range of the Print_Area.

How to Create a Named Range in Excel

You can easily name a range using the Name Box. In this example, we will name the range E5:F12 “Numbers“. The steps to do it are given below.

Steps:

First of all, select the range E5 to F12 and click on the Name Box.
Then change the name to Numbers and press Enter.

Now if you click on the Name Box dropdown and select Numbers, the cell range E5:F12 will be highlighted.

Notes

Using the Name Manager tool, you can find the location of the named range. To navigate to the range, it is better to use the first two methods.

Conclusion

Thanks for making it this far. I hope you find this article useful. Now you know three easy ways how to navigate a named range in Excel. Please let us know if you have any further queries, and feel free to give us any recommendations in the comment section below.