ADDRESS in WPS on Windows: Introduction

ADDRESS in WPS is a spreadsheet lookup and reference function that returns a cell address as text from row and column numbers; this guide covers 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

The ADDRESS function in WPS Spreadsheet returns a cell address as text based on specified row and column numbers and reference settings. It supports cross-sheet references and nested calculations, and the result updates when related data changes.

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 formula input and calculation; download, sign-in, and cloud services require internet access
Other	You need permission to open and edit WPS Spreadsheet files

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office, launch Spreadsheet, and confirm that you can enter the ADDRESS function from the Formulas tab or formula bar

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Spreadsheet, ADDRESS returns a cell address as text from row and column numbers, supports reference styles, and can be used in cross-sheet and nested formulas.	Excel ADDRESS returns a cell reference from row and column numbers and supports absolute or relative references, A1 or R1C1 style, and sheet text.	Google Sheets ADDRESS returns a cell reference as a string and supports absolute-relative mode, A1 notation control, and a sheet argument.	Notion formulas support properties, operators, and functions for database-style calculations, but they do not provide a spreadsheet-style cell address function equivalent to ADDRESS.	Adobe Acrobat Sign text tags use exact syntax to create document fields, which is different from spreadsheet cell-address generation.
WPS Advantages	Advantage: WPS keeps ADDRESS in a familiar spreadsheet workflow, so you can enter it directly in the formula bar and combine it with other spreadsheet functions for address generation and reference tasks.	Compared with WPS: Excel documents the ADDRESS arguments in detail; both products support spreadsheet address generation in this scenario.	Compared with WPS: Google Sheets also supports ADDRESS, but it is primarily used in a browser-based spreadsheet environment.	Compared with WPS: Notion is better suited to property-based database formulas than cell-address reference tasks.	Compared with WPS: Adobe focuses on document field tagging and signing workflows rather than spreadsheet formula calculation.
Official Source	—	ADDRESS function	ADDRESS	Formula syntax & functions	Text tags - Basics and syntax

Overall Conclusion
If your work centers on spreadsheet address generation, reference assembly, and formula combinations, ADDRESS in WPS fits naturally into that workflow. Microsoft and Google offer comparable spreadsheet functions, while Notion and Adobe are designed for different calculation or document-field scenarios.

Use Cases

No.	Scenario	Suitable for	Main challenge	How ADDRESS helps
1	Generate cell address text	Spreadsheet editors	Turning row and column numbers into readable references	Use ADDRESS to return the address text directly
2	Build cross-sheet references	Data organizers	Pointing formulas to cells on other sheets	Use ADDRESS with sheet-related parameters in formulas
3	Create nested formulas	Analysts and finance users	Combining address output with other functions	Use ADDRESS as part of a larger formula chain
4	Keep results updated	Daily office users	Manually changing references after data changes	Let formula recalculation update the result automatically
5	Learn formula syntax	New users	Understanding reference styles and parameters	Follow the formula prompt while entering ADDRESS

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
ADDRESS function input and calculation	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Additional value-added services	Depends on the current account benefits	Available according to the selected subscription plan

Recommendations

Usage scenario	Recommended plan	Why
Everyday spreadsheet formulas	Free	The ADDRESS function itself has no membership restriction
Broader cross-device or added services	WPS Premium	Suitable if you also need more subscription-based services

WPS membership center: Subscribe now

Source: WPS Office pricing page