Excel Made Easy

Quickly navigate to frequently used field cell in workbook in Excel

For example, I have a complex WorkBook with multiple tables running into 500 rows and 60 columns. Is there a way I can quickly go to certain frequently used cells avoiding horizontal and vertical scrolling? In the screenshot below

after reviewing the full report for one country till row 500, I want to get back to the Country field quickly without scrolling so that I can select next Country and analyze the report.

excel quickly navigate to frequently used field cell in workbook

To do it in Excel, here is the answer:

a) As a first step, for the field of interest, assign a NAME (make it a NAMED RANGE) by clicking on "Name Manager" under "Formulas".

excel quickly navigate to frequently used field cell in workbook

b) In the Name Manager dialog box that comes up, Click on "New".

excel quickly navigate to frequently used field cell in workbook

c) In the "New Name" dialog box, enter a name for the range (in this case "COUNTRY") and in the Refers to: field, select the field that corresponds to "COUNTRY".

excel quickly navigate to frequently used field cell in workbook

d) If you want to navigate to this field from anywhere in the WorkBook (or from among open WorkBooks), simply press F5 (alternatively, select Go To under Find & Select under Home).

In the "Go To" dialog box that pops up, select "COUNTRY" and click OK.

excel quickly navigate to frequently used field cell in workbook

 

You can find similar Excel Questions and Answer hereunder

1) How to read a value from a cell in vba in Excel

2) Can I add a small chart to Table data to make it visually appealing and easy to interpret?

3) Highlight row of selected cell in Excel

4) Remove the apostrophe cell text values in Excel

5) I want to pull data from a table using a reference cell in table. Is there a function to support that?

6) I want to add a trend indicator symbol next to my sales data - how can I do that?

7) How do you know which column was used last, Here the explanation to find it with VBA

8) How can I identify the cells that are dependent on a particular cell?

9) How can I identify the cells that influence a particular cell to help with debugging of my spreadSheet or understand a spreadSheet that I inherited?

10) How can I clear cell after activating a routine when there is a change in value of a cell?

 

Here the previous and next chapter

Excel Made Easy was founded in 2002. Excel Made Easy is a service to people looking to learn Microsoft Excel or any other spreadsheet SW on the market.

We endeavor to provide the best service and support and to respond quickly to your questions.

Excel Made Easy is a proud sponsor of Dismantle-It.com the site that shows you the belly of your daily objects, Poupounette.com the site of cars loving cat and PowerPointMadeEasy.com the world top reference for PowerPoint Presentations questions and Pet Cemetery Online a site dedicated to your loving Pets.