Here is an excellent way in case you have big Excel sheets, and you need to move from one part of the sheet to another to check or pickup data. If you a lot of tables, and you need to navigate to that table or section quickly, you can type in the name of the section, and Excel will take you there instantly. This post helps you to quickly navigate to parts of the Excel Sheet with Named Ranges.
I came out with this when I was working with Excel sheets (Microsoft Office) in Sharepoint, where named ranges are actually helpful if you want to hide one part of the sheet from some people.
Quickly Navigate to parts of Excel Sheet with Named Ranges.
Named Ranges in Microsoft Office Excel is useful to navigate to a specific part of the Excel sheet quickly. To create a Named Range, follow these steps:
- Select the range of cells you want to name, and then right-click on it.
- Right-Click on while it is selected, and click on Define Name.
- Keep the Scope to Workbook so you can move across the sheets.
- Once done, click on the Ok button.
To quickly move to that Named Range, click on the left corner of the excel sheet, which usually displays the cell name, and type the name you created in the above step. Press the Enter key, and you will be instantly taken even if it is available on a different worksheet.
Remember you will need to keep the scope of the range throughout the Workbook. Otherwise, you won’t be able to access them from other sheets once you have created the named ranges.
These named ranges can also be called Formula. Type equal to in a cell, and type the ranged name, and it will instantly appear. It is useful when you need to display the sum of a column into a cell.
If you need to manage them all from one place, you can use the Name Manager.
Video: How to use Named Ranges in Excel
I hope the post was easy to follow, and you have learned a new trick in Microsoft Office Excel. Named Ranges to navigate between sheets and workbooks a bliss.