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.
Download Practice Workbook
Download this practice workbook to exercise while reading this article.
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
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.
- 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.
- 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 (4 Quick Ways)
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.
- First, click on the Name Box dropdown and then select Dates.
- Consequently, it will navigate you to the range C5:C12.
Read More: How to Edit Name Box in Excel (Edit, Change Range and Delete)
- How to Change Excel Column Name from Number to Alphabet (2 Ways)
- Use Dynamic Named Range in an Excel Chart (A Complete Guide)
- How to Change Scope of Named Range in Excel (3 Methods)
- Name a Column in Excel (3 Easy and Effective Ways)
- How to Create Dynamic Named Range in Excel (2 Easy Ways)
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.
- 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.
Read More: [Solved!] Names Not in Name Manager in Excel (2 Solutions)
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.
- 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.
- 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 (5 Examples)
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.
- How to Delete Named Range Using VBA in Excel (5 Examples)
- Check If Named Range Exists with Excel VBA
- How to Copy a Sheet If Name Already Exists in Excel
- Rename Column in Excel (3 Easy Ways)
- [Fixed!] Name Manager Delete Option Greyed out in Excel (3 Reasons)
- Set Value to a Named Range with Excel VBA (3 Methods)
- How to Delete All Named Ranges in Excel (2 Ways)