How to Trace Referenced Cells on Another Excel Worksheet
Question details
The user wants to visually identify cells on another worksheet that are referenced by a formula, because Excel only highlights references on the active sheet during formula editing.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user is editing a formula in Excel and wants to check precedent cells located on a different worksheet.
- Observed behavior
- Excel highlights referenced cells on the same worksheet, but does not highlight cells on another worksheet during formula editing.
Open the workbook that contains the cross-sheet formula and select the formula cell before using formula auditing tools. Make sure the worksheet is not protected so the Formulas tab commands are available.
Use Trace Precedents to Inspect Cross-Sheet References
Use this built-in Excel command to display precedent arrows and open the Go To dialog for references on other worksheets.
Excel does not highlight cells on another worksheet while editing a formula, but Trace Precedents can show which cells feed the formula and lets you jump to them.
Open your workbook in Excel and click the cell that contains the formula with cross-sheet references.
Go to the Formulas tab and click Trace Precedents in the Formula Auditing group.
When a dashed tracer arrow points to a worksheet icon, double-click the dashed line or select the formula cell and click Trace Precedents again to open the Go To dialog, choose the referenced cell, and click OK.
Navigate to the Referenced Sheet and Range Manually
Use this method when you want to inspect the exact referenced range by following the formula reference.
Submit Feedback for Native Cross-Sheet Highlighting
Use this option when you want Excel to natively highlight off-sheet precedent cells during formula editing.
Try WPS Office as a Free Spreadsheet Alternative for Formula Review
Because Excel does not natively highlight off-sheet referenced cells while editing, WPS Office is a free, lightweight alternative for opening and reviewing Excel workbooks. It provides a familiar spreadsheet interface and Microsoft Excel format compatibility, so you can inspect formulas, sheet tabs, and references without losing workbook structure.
- 1. Download WPS Office: Click Download WPS Office Free and install WPS Office on your device.
- 2. Open your Excel workbook: Launch WPS Spreadsheets, click Open, and select the .xlsx workbook that contains the cross-sheet formula.
- 3. Inspect the formula references: Select the formula cell, review the reference in the formula bar, and click the referenced sheet tab to navigate to the source cells.
Frequently Asked Questions
Does Excel highlight referenced cells on another worksheet?
No. Excel highlights referenced cells on the active worksheet while you edit a formula. For references on another worksheet, it can show a dashed tracer arrow with a worksheet icon when you use Trace Precedents.
How do I trace cross-sheet precedents in Excel?
Select the cell that contains the formula, go to the Formulas tab, and click Trace Precedents. Then double-click the dashed tracer arrow to open the Go To dialog and jump to the referenced cell on the other worksheet.
Can I make Excel highlight off-sheet references like same-sheet references?
Not currently. Excel does not have a setting for this behavior. You can submit a feature request through Help, Feedback, and Make a Suggestion in Excel or through the Microsoft feedback portal.
Why is Trace Precedents grayed out?
Trace Precedents is usually grayed out if the active cell does not contain a formula, the worksheet is protected, or the workbook is in an unsupported shared state. Select a formula cell and make sure the worksheet is not protected.
Will WPS Office highlight referenced cells on another worksheet?
WPS Office Spreadsheets opens Excel workbooks and preserves formulas. If live cross-sheet highlighting is unavailable in your version, select the formula cell and use the formula bar or click the referenced sheet tab to inspect the source range manually.
