ADDRESS in WPS on Windows: Introduction

ADDRESS in WPS on Windows returns a cell reference 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 reference as text based on the specified row and column numbers.

Key capabilities include:

Return a cell reference from row and column numbers for dynamic spreadsheet formulas.
Control absolute references, relative references, and reference style through parameters.
Work with sheet names and nested formulas in spreadsheet calculations.
Update the returned result when input parameters change.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	No mandatory internet connection is required for local spreadsheet formulas; internet access is needed for download, installation, and account services
Other	An editable workbook in WPS Spreadsheet is required

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, launch Spreadsheet, select a cell, and enter `=ADDRESS(` in the formula bar

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	The ADDRESS function in WPS Spreadsheet returns a cell reference as text from row and column numbers and can be used in parameterized, cross-sheet, and nested formulas.	Excel provides the ADDRESS function to return a cell address from row and column numbers, with optional absolute or relative references, A1 or R1C1 style, and sheet text.	Google Sheets provides the ADDRESS function to return a cell reference as a string, with optional absolute or relative mode, A1 or R1C1 notation, and a sheet argument.	Notion formulas support properties, operators, and functions for database calculations, but they do not provide a spreadsheet-style ADDRESS function for cell coordinates.	Adobe Acrobat forms use JavaScript for form fields, calculations, and validation, which fits PDF form workflows rather than spreadsheet cell-reference formulas.
WPS Advantages	Advantage: You can enter ADDRESS directly in the WPS Spreadsheet formula bar and use it in the same worksheet calculation flow as other spreadsheet functions.	Compared with WPS: Excel covers a very similar spreadsheet function scenario and documents the full syntax and arguments.	Compared with WPS: Google Sheets also supports ADDRESS syntax, but it is centered on the Sheets web spreadsheet environment.	Compared with WPS: Notion is designed for database property formulas, so it does not focus on direct cell-coordinate references.	Compared with WPS: Adobe focuses on PDF form automation instead of spreadsheet ADDRESS function syntax.
Official Source	—	ADDRESS function	ADDRESS	Formula syntax and functions	Using JavaScript in Forms

Overall Conclusion
If your work centers on dynamic cell references in spreadsheets, WPS ADDRESS, Microsoft Excel, and Google Sheets belong to the same general use case. Notion and Adobe serve different workflows that focus more on database formulas or PDF form automation than spreadsheet cell addressing.

Use Cases

No.	Scenario	Suitable for	Main need	Solution
1	Generate reference text dynamically	Spreadsheet editors	Need to build reference text from row and column numbers	Use ADDRESS in a cell to return the reference string
2	Combine with other functions	Data analysts	Writing reference text manually is inefficient in nested formulas	Combine ADDRESS with other functions to return reference text from parameters
3	Organize cross-sheet references	Multi-sheet users	Need to structure references across worksheets	Use ADDRESS parameters to generate references with sheet information
4	Learn function syntax	New users	Need a quick way to understand parameter order	Enter `=ADDRESS(` in the formula bar to view syntax prompts
5	Update results after parameter changes	Everyday office users	Manual references need to be rewritten after row or column changes	Adjust the parameters and let the function update the result

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic spreadsheet functions	Can use spreadsheet functions such as ADDRESS	Can use them as well
Basic PDF features	Includes some basic PDF features	Includes more advanced PDF features
Cloud storage	1 GB	20 GB or more depending on the plan shown on the pricing page
Templates and advanced tools	Some limits apply	More advanced templates and tools are available

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
You mainly need ADDRESS and other basic spreadsheet functions	Free	Basic spreadsheet editing and formula entry are enough for everyday work
You also need more advanced tools, more cloud storage, or broader benefits	WPS Premium	Better suited to users with broader document and premium feature needs

Subscribe here: Get WPS Premium