WPS Name Manager on Windows: Introduction

WPS Name Manager is a built-in naming tool in WPS Spreadsheets; it includes 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	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

Name Manager is a built-in feature in WPS Spreadsheets for managing defined names and range references in a workbook, making formulas easier to read and reuse.

Core tasks include:

Create names for cell ranges, constants, or formulas.
Use names in formulas instead of cell addresses.
Edit or delete existing names from one place.

This feature is useful for sales summaries, cross-sheet references, reusable templates, and other spreadsheet workflows where formula clarity and maintenance matter.

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 name management
Other	Open a WPS Spreadsheet workbook before using the feature

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Launch WPS Office, open a spreadsheet file, and look for the Name Manager entry on the Formulas tab

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	WPS lets you open Name Manager from the Formulas tab, create names, use them directly in formulas, and edit or delete existing names.	Excel Name Manager lets you view, filter, sort, create, edit, and delete defined names, while also showing scope and references.	Google Sheets lets you create named ranges, edit or delete them, and use them directly in formulas.	Notion formulas work on database properties and calculations, but they do not provide spreadsheet-style named range management.	Adobe Acrobat focuses on PDF creation, editing, conversion, and links, rather than spreadsheet name management.
WPS Advantages	Advantage: WPS keeps name creation, formula use, and name maintenance inside the spreadsheet formula workflow, which helps replace cell addresses with readable names.	Compared with WPS: Excel provides more detailed filtering, sorting, and scope information inside its manager.	Compared with WPS: Google Sheets supports named ranges, but management is centered in the Data menu and a side panel.	Compared with WPS: Notion is better suited to database property formulas than workbook-level named range management.	Compared with WPS: Acrobat is not a spreadsheet tool, so it does not cover named range management scenarios directly.
Official Source	—	Use the Name Manager in Excel	Name a range of cells	Write formulas for databases	Acrobat Desktop Help

Overall Conclusion
If your work centers on named ranges, readable formulas, and workbook maintenance, WPS Name Manager covers the common tasks directly in WPS Spreadsheets. Excel and Google Sheets offer comparable spreadsheet workflows, while Notion and Adobe are better aligned with database or PDF use cases.

Source: How to use Name Manager

Use Cases

No.	Scenario	Suitable users	Main pain point	How Name Manager helps
1	Sales data summaries	Finance teams, sales operations	Cell-address formulas are hard to read	Create names for sales ranges and use them directly in summary formulas
2	Cross-sheet references	Report maintainers	Long references are harder to update later	Use names to point to target ranges across sheets
3	Reusable templates	Team collaborators	Formulas are harder for others to understand	Replace addresses with clear names for better readability
4	Centralized name maintenance	Advanced spreadsheet users	Existing names are scattered and harder to manage	Edit or delete names from one manager window
5	Complex formula cleanup	Data analysts	Long formulas take more time to review	Name key ranges first, then combine them in formulas

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Basic Name Manager use	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Some advanced PDF, AI, and extended benefits	May be limited depending on the product page	Usually includes broader access or higher limits
Cloud storage	1 GB	Higher-capacity plans are available

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Everyday naming and formula cleanup in spreadsheets	Free	Common Name Manager tasks are available directly
Users who also need more PDF, AI, or cloud benefits	WPS Premium	Better suited to broader office needs beyond this feature

WPS membership center: Subscribe now