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.
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
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.
- Use Dynamic Named Range in an Excel Chart
- How to Change Scope of Named Range in Excel
- Name a Column in Excel
- How to Create Dynamic Named Range in Excel
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.
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.
Download Practice Workbook
Download this practice workbook to exercise while reading this article.
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 Name a Group of Cells in Excel
- How to Find a Named Range in Excel
- How to Paste Range Names in Excel
- How to Edit Named Range in Excel
- How to Use Named Range in Excel VLOOKUP Function
- Excel INDIRECT Function with Named Range
- Excel Reference Named Range in Another Sheet
- How to Ignore Blank Cells in Named Range in Excel
- How to Delete Named Range Excel
- Define Names with the Create from Selection Tool in Excel
- How to Use Named Range in Excel VBA
- Create Dynamic Named Range with VBA in Excel
- Excel VBA to Loop Through Named Range
- How to Delete Named Range Using VBA in Excel
- Check If Named Range Exists with Excel VBA
- Set Value to a Named Range with Excel VBA
- How to Delete All Named Ranges in Excel