Excel Shortcut to Go to a Referenced Cell

In Excel for Microsoft 365 on Windows, select a formula cell and press Ctrl+[ to select the cells it directly references. To jump to a cell when you already know its address, press Ctrl+G or F5, type the address, and press Enter.

The shortcut for a formula’s referenced cells

Excel calls a cell used by a formula a precedent. For example, if the formula in D2 uses values from B2 and C2, those two cells are D2’s direct precedents. Click D2 and press Ctrl+[ to select the cells directly referenced by its formula. If a formula refers to a range, Excel selects that range; if it refers to separate cells, it can select multiple areas.

This is different from typing an address into the Go To dialog. Ctrl+[ follows the formula’s references, whereas Ctrl+G and F5 take you to a location you specify. Use the former when you are inspecting a formula and want to find its inputs. Use Go To when you know the destination, such as H250, but do not need to discover what the active formula refers to.

The shortcut works on the active formula cell, so first make sure the selection is on the formula you want to investigate. If a range of cells is selected, Excel’s response can depend on which cells in that selection contain formulas. Selecting one formula cell first makes the result easier to interpret.

What counts as a referenced cell

A formula can refer to a single cell, a range, or several nonadjacent cells. It can also refer to cells on another worksheet or, in some cases, another workbook. The cells a formula reads are its precedents. Cells whose formulas use the active cell are called dependents. This distinction explains why two similar-looking shortcuts move in opposite directions.

For example, with quantities in B2:B20 and unit prices in C2:C20, a total in D2 might multiply B2 by C2. Those two input cells are precedents of D2. If another formula in E2 adds D2 to a fee, E2 is a dependent of D2. Following precedents helps you trace inputs upstream; following dependents helps you see where a value flows downstream.

Excel follows references expressed in the formula, not the business meaning you intend. If a formula contains a constant typed directly into it, that constant is not a cell for Excel to select. Similarly, a reference generated indirectly through a function such as INDIRECT may not be represented as an ordinary, traceable cell reference. In those cases, inspect the formula itself as well as using navigation shortcuts.

How to follow a formula reference

Click the cell containing the formula you want to inspect.
Press Ctrl+[ on Windows. Excel selects the directly referenced cells, and may move to another worksheet if a reference is there.
Read the selected cell or cells and check the formula bar or Name Box to confirm their addresses.
To return to a particular cell, use the Name Box or Go To: press Ctrl+G, enter its address, and press Enter.

Consider a worksheet where B2 contains 4 units and C2 contains a price of 12.50, while D2 calculates the line total. With quantity in B2 and price in C2, enter =B2*C2 in D2; the result is 50. Select D2 and press Ctrl+[ to select B2 and C2. The example is intentionally simple: it shows that the shortcut reveals the formula’s cell inputs, not the calculated result or a written explanation of what those inputs represent.

If you need to inspect a particular input, note its address and navigate there. For instance, if the selected precedent is C2, press Ctrl+G, type C2, and press Enter. You can also click the Name Box to the left of the formula bar, type C2, and press Enter. The Name Box is convenient when the destination is known and you want to avoid opening a dialog.

Using Go To when you know the address

The Go To dialog is the better tool when the question is “How do I get to cell F125?” rather than “Which cells feed this formula?” On Windows, Ctrl+G and F5 open Go To. Enter a cell address such as F125 and confirm. To specify a worksheet as well, enter a reference such as Sheet2!F125; if a sheet name contains spaces, enclose the name in single quotation marks, as in 'Quarter 2'!F125.

Go To can also move to named ranges, provided they exist in the workbook. A name such as Sales_Total can be entered in the dialog or Name Box. This can be easier than scrolling through a large sheet, and it is useful when a workbook uses meaningful names instead of relying only on addresses. If you are unsure what a name refers to, check the Name Manager on the Formulas tab.

Entering a range, such as B2:C20, selects the whole range rather than just its first cell. A worksheet-qualified reference is useful when the destination is not on the active sheet. The dialog does not calculate a formula or change its references; it changes the active selection so you can inspect or edit the destination.

Other shortcuts and formula-auditing tools

To move from a cell to cells that directly depend on it, use Ctrl+] on Windows. This is the downstream counterpart to Ctrl+[. For example, if D2 uses B2 and C2, selecting B2 and pressing Ctrl+] can take you to D2. The result depends on whether dependent formulas exist and whether they are available for Excel to locate.

For a visual explanation, open the Formulas tab and choose Trace Precedents or Trace Dependents in the Formula Auditing group. Excel draws arrows to show relationships. A blue arrow points to a precedent on the same worksheet; a dashed arrow can indicate a reference outside the current worksheet or workbook. Double-clicking a tracer arrow opens a Go To list of the referenced cells, where you can choose a destination.

For a formula that depends on intermediate calculations, one level of precedents may not be enough. Trace Precedents can be applied repeatedly to follow the chain step by step. For instance, a summary formula might refer to a subtotal cell, which in turn refers to many detail rows. Following each level helps reveal where a value originates without assuming that the summary formula contains every underlying input directly.

References across sheets and workbooks

A formula can point to a different worksheet, for example to a cell on a sheet named January. When you follow a direct reference, Excel may switch worksheets to show the precedent. If the formula has references on more than one sheet, inspect the selected areas and the formula bar carefully; the formula may contain several separate references rather than one continuous range.

References to another workbook require extra care. A formula may point to a cell in a workbook that is closed, unavailable, or stored in a different location. Excel can show an external reference in the formula, but navigation and tracing may be less straightforward than for cells in the current workbook. Opening the source workbook may be necessary to inspect the referenced value. Do not assume that an external link is current simply because the formula displays a number.

Structured references in Excel tables can also make a formula less familiar. A formula using a table column name describes a reference by its label rather than by an address such as C2:C20. If navigation does not make the intended source obvious, read the formula and check the table’s headers and rows. The shortcut can help locate traceable precedents, but understanding the reference syntax still matters.

Windows, Mac, and Excel for the web

This article’s primary shortcuts are for Excel for Microsoft 365 on Windows. In Excel for Mac, keyboard mappings can differ by version, macOS settings, and keyboard layout. The direct-precedent shortcut is commonly Control+Shift+[ on Mac, but if that combination is intercepted or does not work in your setup, use the ribbon command Formulas > Trace Precedents. To navigate by a known address, use the Name Box; it avoids dependence on a particular function-key mapping.

On a Mac, the function keys may control system features unless you hold Fn or change the keyboard settings, so F5 may not behave as it does on a Windows keyboard. The Go To command is also available from Excel’s menus, and Control+G is commonly used in Excel for Mac. Because menu and shortcut behavior can vary, the Name Box is a dependable alternative: enter the address or named range and press Return.

Excel for the web runs in a browser, where browser shortcuts can overlap with spreadsheet shortcuts. If a key combination does not reach Excel, use the Name Box to go to a known address. Formula-auditing features and keyboard behavior can differ from desktop Excel, so use the available commands on the web ribbon if you need to trace a relationship. For complex audits, the Windows desktop application provides the most familiar set of formula-auditing tools.

Common problems and what to check

The shortcut appears to do nothing: confirm that the active cell contains a formula with ordinary cell references. A typed value has no precedents. If you are in edit mode, press Enter or Esc first, select the cell again, and retry.
Excel selects more than one cell: this is expected when the formula refers to multiple inputs or a range. Look at the formula to identify which references correspond to each selected area.
The shortcut is intercepted: another application, the keyboard layout, or a Mac function-key setting may be consuming the keys. Use Formulas > Trace Precedents or the Name Box instead.
The formula uses INDIRECT or a similar indirect construction: the actual address may be assembled from text or another value, so ordinary precedent tracing may not reveal the final target. Inspect the formula and the values used to build the reference.
The destination is on another sheet or in another file: check the worksheet and workbook name in the formula. An external source may need to be open and accessible before you can inspect it fully.

A useful habit is to distinguish navigation from auditing. Go To answers where a known address is; precedent tracing answers which cells a formula directly uses. If the selection seems surprising, do not immediately edit the formula. First compare the highlighted cells with the references visible in the formula bar, including any sheet names, range notation, and structured table references.

Frequently Asked Questions

What is the Excel shortcut to go to a cell referenced by a formula? On Windows, select the formula cell and press Ctrl+[ to select its direct precedents. To go to a specific address you already know, use Ctrl+G or F5 and enter the address.

What shortcut goes to cells that depend on the selected cell? On Windows, press Ctrl+] to select direct dependents of the active cell. These are cells whose formulas refer to the selected cell, rather than cells used by the selected cell’s formula.

How do I jump to a cell by typing its address? Press Ctrl+G or F5, type an address such as H250, and press Enter. You can also type the address in the Name Box beside the formula bar.

Can I use the shortcut to follow references on another worksheet? Often, Excel can move to or select precedents on another worksheet, but results depend on the reference and workbook state. Use Trace Precedents and double-click an arrow if you need to choose among several destinations.

Why does Ctrl+[ not work on my Mac? Mac shortcut mappings and keyboard settings differ from Windows. Try Control+Shift+[ where supported, or use Formulas > Trace Precedents. To jump to a known cell, use the Name Box or Excel’s Go To command.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.