WPS Name Manager is the named-reference management feature in WPS Spreadsheets on macOS; 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 macOS that lets you create custom names for cell ranges, formulas, or constants and then use those names directly in formulas. It helps make formulas easier to read and supports clearer collaboration when multiple people work in the same workbook.
Its main tasks include:
- Create names for ranges, formulas, or constants.
- Use names in formulas instead of direct cell references.
- Edit or delete names from one place and keep related formulas aligned with the updated definition.
This feature is useful for collaborative spreadsheets, recurring reports, reusable templates, and workbooks that need consistent naming rules.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A macOS device that can run WPS Office for Mac normally |
| App version | The latest version of WPS Office is recommended |
| Network | No mandatory internet connection is required for local name management; a network connection is recommended for collaboration scenarios |
| Other | Open a WPS spreadsheet file and make sure you have permission to edit the current workbook |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Spreadsheets, load a workbook, and confirm that the Name Manager entry is available on the Formulas tab |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | WPS Name Manager lets you create, use, edit, and delete names for ranges, formulas, or constants in one place, and those names can be used throughout the current workbook. | Excel provides a Name Manager dialog box to work with defined names and table names, including viewing, filtering, editing, deleting, and checking scope and references. | Google Sheets supports named ranges so users can name a range, use it in formulas, and later edit or delete that named range. | Notion formulas work with database properties, built-ins, and functions for calculated outputs, but they do not provide a spreadsheet-style named range manager. | Adobe Acrobat supports calculation settings for PDF form fields, which fits form workflows rather than workbook-based named range management. |
| WPS Advantages | Advantage: Covers the common workflow of creating, referencing, editing, and deleting names in one spreadsheet feature. Distinct: Better aligned with workbook formula readability and spreadsheet collaboration scenarios. | Compared with WPS: Excel documents more advanced scope, filtering, and centralized management details for defined names and table names. | Compared with WPS: Google Sheets focuses on naming and maintaining ranges, with a lighter official workflow around centralized name management. | Compared with WPS: Notion formulas are designed for database property calculations, not for naming spreadsheet ranges and reusing them in worksheet formulas. | Compared with WPS: Acrobat calculations are built for PDF form fields, so they do not replace spreadsheet name management or workbook formula references. |
| Official Source | — | Use the Name Manager in Excel | Name a range of cells | Intro to formulas | Configure form field calculations in Acrobat |
Overall Conclusion
If your main goal is to manage named ranges, improve formula readability, and keep spreadsheet collaboration clearer, WPS Name Manager covers the common create-use-maintain workflow well. Other products fit different scenarios, such as advanced Excel name administration, lightweight web-based named ranges, database formulas, or PDF form calculations.
Use Cases
| No. | Scenario | Suitable for | Main issue | How this feature helps |
|---|---|---|---|---|
| 1 | Naming sales report ranges | Sales analysts | Cell-address formulas are hard to read | Create names for sales data ranges and use them directly in formulas |
| 2 | Maintaining team spreadsheets | Collaborators | Team members may not understand formulas quickly | Use consistent names to reduce explanation time |
| 3 | Reusing report templates | Operations and finance staff | Repeated report building increases formula maintenance work | Reuse fixed names to make templates easier to maintain |
| 4 | Reviewing formulas | Data coordinators | Complex formulas make referenced ranges hard to trace | Check and update names centrally in Name Manager |
| 5 | Reusing constants and formulas | Advanced spreadsheet users | Re-entering constants or formulas can cause mistakes | Define constants or formulas as names and reuse them |
Membership & Benefits
Free vs WPS Premium
| Item | Free | WPS Premium |
|---|---|---|
| Basic use of Name Manager | ✅ Available | ✅ Available |
| Core office features | ✅ Available | ✅ Available with more advanced capabilities across WPS Office |
| Extended PDF and template benefits | Some features available | More features available |
| Cloud storage | 1 GB | 20 GB, depending on the plan shown on the pricing page |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Everyday spreadsheet editing and name management | Free | Name Manager itself is available without a membership requirement |
| Ongoing work that also needs broader PDF, template, or cloud benefits | WPS Premium | Better suited for users who need expanded office benefits beyond spreadsheet naming |
How to Subscribe
- WPS membership page: Subscribe now
Source: WPS Office pricing page