Excel Trace References Across Worksheets When Ctrl+[ or Ctrl+] Does Not Work
Question details
The user needs to find formula precedents or dependents located on another Excel worksheet when Ctrl+[ or Ctrl+] does not navigate to them.
![Excel Trace References Across Worksheets When Ctrl+[ or Ctrl+] Does Not Work](https://res-academy.cache.wpscdn.com/upload/seo-engine-admin/2026-11-12/a1aef37c058fffbfe3a4c632c00210f0.png)
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A formula contains references to cells on different worksheets, and the user wants to trace those relationships.
- Observed behavior
- Ctrl+[ and Ctrl+] do not reliably open referenced or dependent cells on another worksheet.
Select the formula cell whose inputs or results you want to investigate. Make sure calculation tracing arrows are visible by using the commands on Excel's Formulas tab.
Use Trace Precedents or Trace Dependents for cross-sheet references
Use this method when the formula relationship extends to another worksheet and keyboard shortcuts do not take you to the linked cell.
Excel displays a dashed tracing arrow when a precedent or dependent is on another worksheet. Double-clicking that dashed arrow opens the Go To dialog, where you can select the off-sheet reference.
Click the cell that contains the formula you want to inspect. Use Trace Precedents to find cells feeding the formula, or Trace Dependents to find formulas that use the selected cell.
On the Excel ribbon, select Formulas > Trace Precedents or Formulas > Trace Dependents.
Find the dashed tracing arrow that indicates a relationship on another worksheet, then double-click the dashed arrow.
In the Go To dialog, select the listed reference and click OK to jump to the related cell or formula.
Use Ctrl+[ and Ctrl+] for direct same-sheet relationships
Use these shortcuts for quick checks of direct references and dependents that Excel can select on the active worksheet.
Review Formula References with WPS Spreadsheets
WPS Office is a free, lightweight alternative for working with spreadsheet formulas and linked cells. Its familiar spreadsheet interface helps you move from Excel smoothly while continuing to open, edit, and share common Office files.
Frequently Asked Questions
Why does Excel show a dashed arrow when I trace a formula?
A dashed tracing arrow usually means the precedent or dependent is on another worksheet or in another workbook. Double-click the dashed arrow, choose an item in the Go To dialog, and select OK.
What is the difference between Trace Precedents and Trace Dependents in Excel?
Select Formulas > Trace Precedents to identify cells used by the active formula. Select Formulas > Trace Dependents to identify formulas that use the active cell.
Can Ctrl+[ trace a reference on a different worksheet?
Ctrl+[ is most useful for direct references Excel can select on the active worksheet. For an off-sheet reference, use Formulas > Trace Precedents and double-click the dashed arrow.
How do I remove formula tracing arrows in Excel?
Go to the Formulas tab, open the Remove Arrows menu, and choose Remove Arrows. You can also choose to remove only precedent or dependent arrows when needed.
