WPS Locate Referenced Cell on Windows: Introduction

WPS Locate Referenced Cell is a spreadsheet formula review feature that helps you identify which cells feed the current formula cell; it includes 1 core task, with 1 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	1	Matches the number of rows in the How-to Index
Available without membership	1	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

Locate Referenced Cell is a formula auditing feature in WPS Spreadsheet for Windows. It helps you check which cells are referenced by a selected formula cell, so you can understand data relationships and troubleshoot formula issues more efficiently.

Core capabilities include:

View referenced cells: Select a formula cell to see which source cells it uses.
Review the result list: Check referenced cells in the pop-up window.
Jump to source data: Use the locate action to move to the referenced data source.

This feature is useful when you review calculation logic, inspect shared worksheets, or understand complex formulas in spreadsheets.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	No mandatory network connection is required for local spreadsheet use; downloading, installation, and account services require internet access
Other	Open a WPS Spreadsheet file that contains formulas, and make sure the target cell already has references

Download & Installation

Before you use Locate Referenced Cell, install the WPS Office desktop app for Windows.

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Spreadsheet, load any worksheet with formulas, and confirm that the related entry is available on the Formulas tab

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	WPS provides a Locate Referenced Cell entry on the Formulas tab so you can review the cells used by the current formula and continue locating the source data.	Excel provides Trace Precedents to display relationships between formulas and referenced cells with tracer arrows, and it can trace additional levels.	Google Sheets highlights referenced cells while you edit a formula and supports F2 or Ctrl+e range-selection mode, but the official help page does not describe a native tracer-arrow workflow like Excel.	Notion formulas focus on database properties, relations, and rollups. They can work with referenced databases or properties, but they are not cell-level spreadsheet tracing tools.	Adobe Acrobat supports calculated PDF form fields with predefined calculations or custom logic, but it does not provide spreadsheet-style cell reference tracing.
WPS Advantages	Advantage: You can review and locate formula source cells directly in the spreadsheet workflow, which is practical for fast formula checks and spreadsheet auditing on Windows.	Compared with WPS: Excel emphasizes arrow-based visualization and multi-level tracing.	Compared with WPS: Google Sheets focuses more on formula-edit highlighting and range editing than on a dedicated review entry for tracing references.	Compared with WPS: Notion is better suited to database formulas and relations than to cell-level spreadsheet troubleshooting.	Compared with WPS: Acrobat focuses on PDF form calculations rather than spreadsheet formula auditing.
Official Source	—	Display formula relationships in Excel	Add formulas and functions in Google Sheets	Common formula errors in Notion	Configure form field calculations in Acrobat

Overall Conclusion
WPS Locate Referenced Cell is well suited to checking where a formula gets its data inside a spreadsheet. If your work centers on spreadsheet formula review, WPS and Excel both provide direct ways to inspect references, while Google Sheets, Notion, and Adobe focus more on formula editing, database logic, or PDF form calculations.

Source: The Trace Precedents function; Display formula relationships in Excel; Add formulas and functions in Google Sheets; Common formula errors in Notion; Configure form field calculations in Acrobat

Use Cases

No.	Scenario	Suitable for	Pain point	How this feature helps
1	Review summary formulas	Finance teams, operations teams	It is not clear which detail cells feed a summary result	Select the result cell and use Locate Referenced Cell to inspect the source
2	Troubleshoot shared worksheets	Team collaborators	It is hard to understand formulas created by someone else	Review the reference list and continue locating the related cells
3	Check cross-range references	Data coordinators	Formulas may reference multiple areas and are slow to inspect manually	Jump to referenced positions more quickly
4	Explain spreadsheet logic	Trainers, students	Formula logic needs a clearer explanation	Use the reference list to show where the formula gets its values
5	Fix unexpected results	General office users	A result looks wrong but the source is unclear	Locate referenced cells first, then inspect each source value

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Locate Referenced Cell	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Advanced PDF and additional value-added tools	Partially limited	More advanced tools and extended benefits are available
Cloud storage	1 GB	Higher cloud storage allocation

Source: WPS Office pricing page

Recommendations

Use case	Recommended plan	Why
Routine formula reference checks	Free	This feature is available for everyday spreadsheet review
Broader office needs with more PDF and extended tools	WPS Premium	Suitable if you also need more advanced tools and higher cloud storage

WPS membership center: Subscribe now