WPS Locate Referenced Cell on macOS: Introduction

WPS Locate Referenced Cell is a spreadsheet auditing feature for checking which cells a formula refers to; 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 Office for Mac Spreadsheets. It helps you identify which cells are referenced by the selected cell, making it easier to review formulas, understand data relationships, and troubleshoot calculation issues.

Key capabilities include:

View referenced cells: Select a target cell to see which cells it refers to.
Continue tracing the source: In the result dialog, click Locate to keep following the data source.
Support formula review: Useful for spreadsheet review, collaboration handoff, and formula troubleshooting.

System Requirements

Item	Requirement
Operating system	A macOS device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office for Mac
Network	No mandatory internet connection is required for checking local cell references
Other	Open a spreadsheet file that contains formulas, and make sure the selected cell has reference relationships

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Launch WPS Office for Mac, open a spreadsheet, and confirm that Locate Referenced Cell is available on the Formulas tab

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	After selecting a target cell in a spreadsheet, you can use Locate Referenced Cell on the Formulas tab to view referenced cells and continue locating related cells.	Excel provides Trace Precedents to show which cells supply data to the current formula, and it supports deeper tracing.	Google Sheets supports formulas and highlights referenced cells while editing formulas, but the official help page does not describe a separate command dedicated to tracing referenced cells.	Notion formulas work with database properties and functions. They are suited to property calculations rather than spreadsheet-style cell reference tracing.	Adobe Acrobat focuses on PDF and form workflows. Its official help content centers on form calculation and field setup rather than spreadsheet cell reference tracing.
WPS Advantages	Advantage: The command is directly available on the Formulas tab, and after viewing the result you can click Locate again to continue tracing the data source.	Compared with WPS: Excel offers a broader formula auditing toolkit with arrows and multi-level tracing, while WPS provides a more direct path for quickly checking the current reference source.	Compared with WPS: Google Sheets emphasizes reference highlighting during formula editing, and the official documentation does not describe a separate command equivalent to Locate Referenced Cell.	Compared with WPS: Notion formulas are designed for database property logic, not cell-level reference troubleshooting.	Compared with WPS: Adobe's related features are focused on PDF forms rather than spreadsheet formula auditing.
Official Source	—	Display the relationships between formulas and cells	Add formulas & functions	Intro to formulas	Acrobat Help Center

Overall Conclusion
If your main goal is to check spreadsheet formula references, WPS Locate Referenced Cell is a practical option for quickly viewing and continuing to trace data sources. If you need broader visual auditing tools, other products may offer different review methods depending on the workflow.

Use Cases

No.	Scenario	Suitable For	Main Pain Point	How WPS Helps
1	Reviewing finance formulas	Finance and audit staff	It is hard to confirm which detail cells are used by a summary formula	Use Locate Referenced Cell to inspect references and continue locating the source
2	Checking shared spreadsheets	Team collaborators	It is difficult to understand formula dependencies in a file created by someone else	Select the target cell and review its reference path
3	Troubleshooting calculation issues	Data staff	A result looks wrong, but the source reference is not easy to find	Trace the referenced source cells through the locate dialog
4	Learning formula structure	New spreadsheet users	It is not easy to understand how formulas connect to data ranges	Use reference tracing to understand where values come from
5	Reviewing complex reports	Managers and analysts	Multi-layer reports make manual reference checking slow	Open the formula tool and quickly locate related cells

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Locate Referenced Cell	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Additional premium features	Some features may be limited	More premium benefits are available, depending on the pricing page

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Why
Routine formula reference checks	Free	This feature is available directly for regular spreadsheet review
Broader advanced office needs	WPS Premium	Suitable if you also need additional premium features across WPS Office

WPS membership page: Subscribe now