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

Get FREE Advanced Excel Exercises with Solutions!

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.

how to navigate to a named range in excel


 How to Navigate to a Named Range in Excel: 3 Suitable Methods

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

Use Go To Feature to a Named Range in Excel


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.

Use Go To Feature to a Named Range in Excel

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

Use Go To Feature to a Named Range in Excel

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

Read More: How to Display Named Range Contents in Excel


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.

Utilize Name Box Control to a Named Range in Excel

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

Utilize Name Box Control to a Named Range in Excel


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

Apply Name Manager Feature

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

Use Name Manager Tool to a Named Range in Excel

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

Use Edit Name window

  • Finally, it will show the range of the Print_Area.

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:F12Numbers“. 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.

change the name to Numbers

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

How to Create a Named Range in Excel

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.

Read More: Excel VBA to Create Named Range from Selection


Download Practice Workbook

Download this practice workbook to exercise while reading this article.


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.


Related Articles

Alif Bin Hussain
Alif Bin Hussain

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc and my program was Civil Engineering from Bangladesh University of Engineering & Technology (BUET). I am a fresh graduate with a great interest in research and development. I do my best to acquire new information and try to find out the most efficient solutions.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo