Office Settings & Configuration

Fix Excel Does Not Highlight Referenced Cells on Another Worksheet

Aamir Naveed Akram Oct 16, 2026 870 views

Question details

Users need to know why referenced cells located on a different worksheet are not visually highlighted or outlined when editing a formula.

Fix Excel Does Not Highlight Referenced Cells on Another Worksheet

Product: Microsoft Excel
Device & OS: Windows PC
Scenario: Editing a formula that references cells located on a different worksheet from the active one.
Observed behavior: Excel for PC highlights referenced cells on the active worksheet but fails to outline or highlight cells referenced on another worksheet.

Before you start

Verify that your formula is typed correctly. Keep in mind that missing visual highlights on cross-sheet references do not prevent the formula from calculating the correct result.

Solution 1Recommended

Use the Trace Precedents Feature to Track References

Since Excel for PC lacks automatic highlighting for cross-sheet references, use the Trace Precedents tool to visually track referenced cells.

The Trace Precedents feature is the best built-in alternative to track which cells are affecting the value of the currently selected formula.

When a reference is on another sheet, Excel will display a black dashed line pointing to a spreadsheet icon. Double-clicking this line allows you to navigate directly to the referenced cell on the other worksheet.

Select the formula cell

Click on the cell containing the formula that references data on another worksheet.

Navigate to the Formulas tab

On the Excel ribbon at the top of the window, click on the 'Formulas' tab.

Activate Trace Precedents

In the 'Formula Auditing' group, click on 'Trace Precedents'. A black dashed arrow will appear. Double-click the arrow to open the 'Go To' dialog box and see the cross-sheet references.

Use the Trace Precedents Feature to Track References

Calculation Status: Your formulas will calculate perfectly fine even without the colored highlight. The lack of highlighting is purely a visual interface limitation on the PC version.

Solution 2

Submit Feature Feedback to Microsoft

Provide direct feedback to the Excel development team to request the addition of cross-worksheet reference highlighting.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If you often manage complex formulas across multiple worksheets and find yourself frustrated by interface limitations in Microsoft Excel, WPS Spreadsheet offers a lightweight, high-performance, and entirely free alternative.

1. Download the software: Visit the official WPS Office website and download the free installation package for your PC.
2. Install WPS Office: Run the downloaded installer and follow the on-screen instructions to set up the software.
3. Open your spreadsheet: Launch WPS Spreadsheet and open your existing Excel files to continue editing your formulas smoothly.

Seamless compatibility with Microsoft Excel (.xlsx, .xls, .csv) formatsFamiliar user interface that requires zero learning curve to masterLightweight installation and lightning-fast operation for large datasetsBuilt-in advanced formula tracking and auditing tools

microsoft office alternative - wps office

Frequently Asked Questions

Why does the Excel Android app highlight cross-sheet references but the PC version doesn't?

The Android and PC versions of Excel are developed with different interface engines. The mobile app includes a feature to highlight cross-sheet references, which has not yet been implemented by Microsoft in the desktop PC version.

Will my formula still calculate correctly if the cells aren't highlighted?

Yes, absolutely. The lack of visual highlighting is strictly an interface limitation. As long as your cell references and formula syntax are correct, Excel will calculate the precise result.

How can I check references on another sheet if they aren't highlighted?

You can use the 'Trace Precedents' tool located under the Formulas tab. Clicking this creates a dashed arrow pointing to a spreadsheet icon. Double-clicking that arrow opens a list of the exact cells referenced on other sheets.

Office App Problems