WPS Name Manager on macOS: Introduction

WPS Name Manager is a spreadsheet feature for creating custom names for cell ranges, formulas, or constants; 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 spreadsheet feature in WPS Office for Mac that lets you assign clearer names to cell ranges, formulas, or constants, making formulas easier to read and easier to maintain.

Its main capabilities include:

Create names: assign custom names to ranges, formulas, or constants instead of relying only on cell references.
Use names in formulas: replace direct references with names for clearer formulas.
Edit and delete names: maintain existing names in one place and keep workbook references organized.

This feature is useful for summary sheets, reusable report templates, team collaboration, and recurring calculations.

System Requirements

Item	Requirement
Operating system	A Mac device that can run WPS Office for Mac
App version	It is recommended to use the latest version of WPS Office for Mac
Network	No mandatory internet connection is required for local name management tasks; internet access is needed for download and account-related services
Other	Open a spreadsheet workbook in WPS Spreadsheets before using this feature

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Launch WPS Office for Mac, open a spreadsheet file, then go to the Formulas tab and confirm that the Name Manager entry is available

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports creating names for cell ranges, formulas, or constants, then using and maintaining them inside the current workbook.	Excel supports names for cell references, constants, formulas, and tables, and documents worksheet-level and workbook-level scope.	Google Sheets supports named ranges for cleaner formulas and lets users edit or delete named ranges.	Notion formulas are designed for database property calculations rather than spreadsheet-style named range management.	Adobe Acrobat supports calculations in PDF form fields, but its workflow focuses on form fields and PDF forms instead of spreadsheet named ranges.
WPS Advantages	Advantage: keeps name creation, formula use, editing, and deletion in a spreadsheet workflow that is easy to follow for workbook maintenance.	Compared with WPS: offers more detailed scope rules and naming options, but the naming model is more complex.	Compared with WPS: works well for online named ranges, but the official help focuses on range naming rather than naming formulas or constants.	Compared with WPS: suitable for database formulas, not for workbook-style name management in spreadsheets.	Compared with WPS: suitable for PDF form calculations, not for spreadsheet formula references managed through a name manager.
Official Source	—	Names in formulas	Name a range of cells	Intro to formulas	Advanced form fields

Overall Conclusion

If your main goal is to manage named references inside spreadsheets, WPS Name Manager fits everyday workbook editing and formula maintenance well. Microsoft Excel provides more detailed scope behavior, Google Sheets focuses on named ranges in online spreadsheets, and Notion and Adobe target different calculation scenarios.

Use Cases

No.	Scenario	Suitable For	Main Pain Point	How It Helps
1	Organizing sales summary formulas	Sales and operations teams	Long range references are hard to read	Create names for sales ranges and use them directly in formulas
2	Reusing report templates	Finance and analysts	Repeated reports are difficult to maintain	Define common names once and reuse them in templates
3	Team handoff and collaboration	Collaborative teams	Formula meaning is not obvious during handoff	Replace cell addresses with business-friendly names
4	Updating reference ranges consistently	Workbook maintainers	Range changes require many formula edits	Edit the named reference once and keep related formulas aligned
5	Cleaning up unused names	Users maintaining long-term workbooks	Too many old names make management harder	Review and delete names that are no longer needed

Membership & Benefits

Membership information for this feature focuses on whether Name Manager itself requires a paid plan and where to subscribe; the feature includes 3 free tasks and 0 membership-related tasks.

Free vs WPS Premium

Capability	Free	WPS Premium
Basic use of Name Manager	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available with a broader feature set
Cloud storage and additional advanced tools	Includes basic quota and some limits	Includes higher quota and more advanced tools

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Why
Everyday naming and formula organization in spreadsheets	Free	Name Manager itself can be used without membership for basic workbook tasks
Broader office needs such as more PDF tools, cloud storage, or additional advanced features	WPS Premium	Better suited for users who need expanded office capabilities beyond this feature

Subscribe here: Get WPS Premium