Excel Go To Referenced Cell: Shortcuts and Navigation

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, press Ctrl+[ to select the cell or cells directly referenced by the formula in the active cell. To go to a cell by typing its address instead, press F5 or Ctrl+G, enter an address such as A10, and press Enter.

Which shortcut should you use?

The right shortcut depends on what you mean by a referenced cell. If you are looking at a formula and want to inspect the cells it uses, Ctrl+[ is the formula-navigation shortcut. If you already know the address of the destination, F5 or Ctrl+G opens Excel’s Go To dialog so you can type it directly.

For example, if B4 contains =A4*2, select B4 and press Ctrl+[ to move the selection to A4, the cell used by the formula. If you instead want to jump to D25 regardless of the current formula, use F5 or Ctrl+G and type D25. These commands solve related but different navigation problems: one follows a formula reference; the other goes to a location you specify.

  • Follow a formula reference: select the formula cell and press Ctrl+[.
  • Go to a known address: press F5 or Ctrl+G, enter the reference, then press Enter.
  • See what uses the current cell: use Ctrl+] to select cells that directly depend on it.

How Ctrl+[ follows a formula

Excel calls cells used by a formula its precedents. With a formula cell active, Ctrl+[ selects the cells directly referenced in that formula. The command does not calculate the formula or open a separate list of references; it changes the selection to the referenced cells. This is useful when checking where a result comes from, reviewing a calculation, or locating an input buried elsewhere in a large worksheet.

Suppose D6 contains =B6+C6. Selecting D6 and pressing Ctrl+[ selects B6 and C6. For a formula such as =SUM(B2:B8), Excel selects the referenced range B2:B8. If the formula has more than one separate reference, Excel may select multiple areas at once. A selection with several areas can look less obvious than a single-cell jump, so check the Name Box to see the selected address or addresses.

The shortcut follows direct references, not every earlier input that contributed to the result. If D6 refers to B6 and B6 in turn contains a formula referring to A6, Ctrl+[ from D6 takes you to B6. Press Ctrl+[ again from B6 to follow its own direct reference to A6. This step-by-step behavior helps distinguish a formula’s immediate inputs from the full chain of calculations behind it.

Use F5 or Ctrl+G for an address

Go To is the better option when you know a cell, range, or named range but are not trying to trace a formula. Press F5 or Ctrl+G to open the Go To dialog, type a reference such as Sheet2!C14, and press Enter. Excel activates the destination. If the sheet name contains spaces, use single quotation marks around the name, as in 'Quarter 1'!C14.

You can also enter a range such as A1:D20 to select it, or type a defined name if the workbook has one. The Name Box, located to the left of the formula bar, is another quick way to go to an address: click it, type the reference, and press Enter. Go To is especially useful for long worksheets where scrolling would be slow, or when a formula refers to a location whose address you can read but do not want to trace automatically.

For a formula containing a reference, you can also select the reference text while editing the formula and press F5 or Ctrl+G to go to that location in some Excel workflows. A reliable general method is to use Ctrl+[ from the formula cell, or copy the address from the formula and enter it in Go To. Avoid replacing or editing formula text unintentionally while trying to navigate.

Follow references across sheets and workbooks

A formula may refer to another worksheet, for example =Sheet2!A1. Ctrl+[ can take you to the precedent on the other sheet, and Excel may switch worksheets as part of the selection. If the sheet name includes spaces, the formula normally displays it with apostrophes, such as ='Monthly Data'!A1. For a direct jump when you know the destination, enter the sheet-qualified address in Go To.

References to other workbooks need more care. A formula can include a workbook name and worksheet name, and the referenced file may need to be available for Excel to follow the link usefully. If a linked workbook is closed, Excel may not be able to open and select its target cell in the same way it can navigate within the current workbook. Check that the source workbook is available and that the external reference is valid before treating a navigation failure as a formula error.

For a quick visual overview rather than a cell selection, go to Formulas > Formula Auditing > Trace Precedents. Excel draws arrows from the cells feeding the selected formula. This is helpful when the formula has several inputs or when you want to preserve the formula cell as the active selection while reviewing its inputs. Use Remove Arrows in the same Formula Auditing group to clear the arrows afterward.

Trace inputs versus cells that depend on a value

It is easy to reverse the direction of formula navigation. Ctrl+[ follows precedents: the cells the active formula reads. Ctrl+] follows dependents: cells whose formulas directly use the active cell. For example, if A1 contains 10 and B1 contains =A1*2, Ctrl+[ from B1 selects A1. Ctrl+] from A1 selects B1.

These are direct relationships. If C1 uses B1 and B1 uses A1, Ctrl+] from A1 identifies B1, not necessarily every later calculation that eventually depends on A1. Repeat the command from each selected formula cell to follow a chain. For a diagram of direct inputs, use Trace Precedents; to show cells that rely on a value, choose Formulas > Formula Auditing > Trace Dependents.

Common reasons the shortcut seems not to work

  • The active cell is not a formula cell. Ctrl+[ has no formula reference to follow if the selection contains only a typed value or blank cell. Select a cell with a formula first.
  • The wrong direction was used. Ctrl+[ follows inputs; Ctrl+] finds formulas that use the selected cell. Check which cell is active before pressing the shortcut.
  • The keyboard layout changes the bracket key. On some layouts, typing [ requires an extra key or the key position differs. Try the key that produces the left bracket, and use the Formula tab’s Trace Precedents command if the shortcut is awkward.
  • A laptop intercepts F5. Some keyboards assign function keys to hardware controls. Try Fn+F5, or use Ctrl+G to open Go To.
  • The formula uses a name or a complex expression. Named ranges and formulas combining several references can produce a multi-cell selection or behavior that is less obvious than a jump to one cell. Inspect the formula bar and the Name Box, or use Trace Precedents to see the relationships.
  • The target is external or unavailable. Check the workbook link and confirm that the referenced file or worksheet exists.

A common misconception is that Ctrl+[ always opens the formula’s first address in a dialog. It does not: it selects precedent cells. F5 and Ctrl+G open Go To. If you need to see the exact formula text without moving, click the cell and read the formula bar, or press F2 to edit the formula in the cell; press Esc to leave editing without committing changes.

Windows, Mac, and Excel for the web

The instructions above target Excel for Microsoft 365 on Windows. On a Mac, Control+G opens Go To; F5 may require the Fn key depending on the keyboard and macOS function-key settings. Excel for Mac keyboard layouts can also affect entering the bracket for the precedent shortcut. If Control+[ does not work as expected, use Formulas > Trace Precedents from the ribbon instead. The ribbon command avoids relying on a particular bracket-key layout.

Excel for the web supports many familiar navigation actions, but browser shortcuts and keyboard layouts can affect what happens when a shortcut is pressed. If Ctrl+[ is intercepted or does not select the expected references, use the Formula ribbon’s auditing command where available, or use the Name Box or Go To control to enter a known address. The workbook’s formula still determines which cells are precedents; changing the navigation method does not change the calculation.

Frequently Asked Questions

What is the Excel shortcut to jump to a cell referenced in a formula?
On Windows, select the formula cell and press Ctrl+[ to select its direct precedents. If you know the address and simply want to jump there, press F5 or Ctrl+G and enter it.

How do I go to a specific cell in Excel without scrolling?
Press F5 or Ctrl+G, type the cell address, such as H500, and press Enter. You can also type the address in the Name Box to the left of the formula bar.

What does Ctrl+] do in Excel?
Ctrl+] selects cells that directly depend on the active cell, meaning their formulas refer to it. It is the opposite direction from Ctrl+[, which follows a formula’s precedents.

How can I see all cells used by a formula?
Select the formula cell and use Ctrl+[ for its direct references, or choose Formulas > Formula Auditing > Trace Precedents to display arrows. Repeat the shortcut on an intermediate formula cell to follow a longer chain.

Why does Ctrl+[ not work on my keyboard?
The bracket may require a different key combination on your keyboard layout, or the selected cell may not contain a formula. Try the Trace Precedents command on the Formulas tab, and confirm the active cell before troubleshooting further.

Choosing the fastest method

For formula checking, start with Ctrl+[ and use the Name Box to confirm the selected reference. For a known destination, use F5 or Ctrl+G. For a visual map of dependencies, use Trace Precedents or Trace Dependents. Keeping those three purposes separate makes Excel navigation more predictable: follow a formula’s inputs, enter a destination, or inspect a relationship without guessing which shortcut does what.

Related

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.