quickly navigate to frequently used field cell in workbook in Excel

Q112. In Excel, how can I quickly navigate to a frequently used field in a voluminous worbook?

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 excel quickly navigate to frequently used field cell in workbook

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

excel excel 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 excel excel 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 excel excel excel excel quickly navigate to frequently used field cell in workbook

 

You can find similar Excel Questions and Answer hereunder

1) How can I save a WorkSheet as a new WorkBook using VBA?

2) 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?

3) How can I enter a text in a cell with subscript and superscript?

4) How can I ensure that user enters only certain acceptable values in an input cell?

5) How do I disable the right click option for users in my WorkBook?

6) Filtering the value field in a pivot table in Excel

7) How can I activate a routine when there is a change in value of a cell?

8) How can I display fractions as it is in a cell (instead of displaying as a decimal)?

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

10) How can I update a listbox based on data in a list using VBA?

11) How do I enter a formula in a cell using VBA (using Relative Reference)?

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

13) How can I enter a picture in a cell?

14) how do you enter multiple line in a cell in Excel

15) Calling a macro from another workbook in Excel