Ever encountered a situation when you are working on a spreadsheet created by someone else? Not sure about the cells being referred to in the formula?

When writing, editing, or auditing Excel formulas you will have to view and access the referenced cells within a formula argument.

In this article, we will go through the Excel formula to go to a specific cell using the following methods:

There is a cool tip where you can jump to the referenced cell or range within the formula and make your changes.

Excel go to cell in formula is helpful if you want to check how the formula works or to make any changes to the formula.

 

Go To Functionality

Jump To A Cell Reference Within An Excel Formula | MyExcelOnline
Jump To A Cell Reference Within An Excel Formula | MyExcelOnline

Follow the step-by-step tutorial on Excel formula to go to a specific cell with an Excel worksheet to practice along:

DOWNLOAD EXCEL WORKBOOK

STEP 1: Double click inside your Excel formula

Excel Cell Reference

STEP 2: Select the formula argument that you want to edit with your mouse

Excel Cell Reference

STEP 3: Press F5 which will bring up the Go To dialogue box and press OK

Excel Cell Reference

STEP 4: This will take you to the referenced cell/range

Excel Cell Reference

STEP 5: You can select the new range with your mouse and also make any changes to the formula bar

Excel Cell Reference

STEP 6: Press Enter and your formula is updated

excel formula to go to a specific cell

This is how you can use the go to cell in Excel!

 

You can even use a simpler technique to Excel jump to cell in formula using Trace Dependents and Trace Precedents in Excel.

Let’s look at these two features in detail!

 

Trace Precedents

Precedent cells are the cells that are referred to by a formula.

In the example below, cell F6 contains a formula that is getting value from another cell. You can use the Trace Precedents to take you to the cell from which you are getting the value.

Let’s see it can be done!

STEP 1: Select the cell F6.

Jump To A Cell Reference Within An Excel Formula | MyExcelOnline

STEP 2: Go to Formulas > Trace Precedents.

Jump To A Cell Reference Within An Excel Formula | MyExcelOnline

This will create arrows on your sheet that will indicate which cells affect the value of the currently selected cell.

Jump To A Cell Reference Within An Excel Formula | MyExcelOnline

To remove these arrows, Go to Formulas > Remove Arrows.

Jump To A Cell Reference Within An Excel Formula | MyExcelOnline

You can even use a keyboard shortcut to highlight the precedent cells.

STEP 1: Select the cell F9.

Jump To A Cell Reference Within An Excel Formula | MyExcelOnline

STEP 2: Press Ctrl + [. This will highlight all the cells mentioned in the formula.

Jump To A Cell Reference Within An Excel Formula | MyExcelOnline

You can press Tab to move between these cells.

Another cool tip is that this feature also works when the formula contains a link to an external workbook and that workbook is closed. When you press Ctrl + [, it will open the closed workbook and take you to that specific cell.

Let’s look at another example for this.

STEP 1: Select a cell that contains a formula linked to a different worksheet or an external workbook.

Jump To A Cell Reference Within An Excel Formula | MyExcelOnline

STEP 2: Go to Formulas > Trace Precedents.

Jump To A Cell Reference Within An Excel Formula | MyExcelOnline

Since the dependent cells are placed in a different worksheet, it will be indicated with a black dash line and arrowhead pointed to a small picture.

Jump To A Cell Reference Within An Excel Formula | MyExcelOnline

STEP 3: Double click on the dashed line to open the dialog box that lists the dependent cells.

Jump To A Cell Reference Within An Excel Formula | MyExcelOnline

STEP 4: Select the cell from the list and press OK. Excel will take you to the referred cell.

Jump To A Cell Reference Within An Excel Formula | MyExcelOnline

 

Trace Dependents

Dependent cells can be used to show the cells that are affected by the active cells. To see the cells that are dependent on the active cells, follow the steps below:

STEP 1: Select the cell you want to analyze.

Jump To A Cell Reference Within An Excel Formula | MyExcelOnline

STEP 2: Go to Formulas > Trace Dependents or Press Ctrl +].

Jump To A Cell Reference Within An Excel Formula | MyExcelOnline

This will highlight the dependent cell with blue arrows.

Jump To A Cell Reference Within An Excel Formula | MyExcelOnline

STEP 3: Click on Trace Dependents again to show more cells that are related to the active cells.

Jump To A Cell Reference Within An Excel Formula | MyExcelOnline

 

HELPFUL RESOURCE:

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

Microsoft Excel Training

You can learn more about how to use Excel by viewing our FREE Excel webinar training on FormulasPivot TablesPower Query, and Macros & VBA!

How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn