WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


The Trace Precedents function

Uploaded time: December 3, 2021 Difficulty Beginner

The Trace Precedents function

The Trace Precedents function

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more.While processing a table, we have to double-click a cell containing a function formula to view the referenced data cell, However, this will easily lead to incorrect editing of the formula. At this time, we can use the function of  Tracking Precedents of WPS table.

Take this table as an example. We want to see which cells are referenced by the formula of Cell E15 and where they are.

Click the Formulas tab, click the Trace Precedents button, and then an arrow will appear in the table. Head to Formula Bar, we know that the formula in Cell E15 refers to cell I3 and the cells in B3:F12.

If we want to remove the arrow, just click Remove Arrows.

What a practical feature! Did you get it?

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.