WPS Name Manager on macOS helps you create and manage names for cells, ranges, formulas, and values; it includes 4 core tasks, with 4 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 4 | Matches the number of rows in the How-to Index |
| Available without membership | 4 | 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 naming and reference management feature in WPS Spreadsheet for macOS. It lets you assign custom names to cells, ranges, formulas, and constant values so formulas are easier to read and maintain.
Core tasks include:
- Quickly naming a selected cell, range, or object from the Name Box.
- Creating a new name in Name Manager with scope, reference, and comments.
- Viewing, editing, and deleting existing names.
- Using defined names directly in formulas for clearer calculations.
This feature is useful for complex formulas, reusable ranges, and workbook maintenance across multiple sheets.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Mac device that can run WPS Office for Mac normally |
| App version | The latest version of WPS Office for Mac is recommended |
| Network | No mandatory internet connection is required for local naming and formula references; internet access is needed for download and account-related actions |
| Other | Open a spreadsheet file in WPS Spreadsheet; common formats such as XLSX are recommended |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Installation | Download the Mac installer, follow the on-screen steps, and launch WPS Office |
| Post-install check | Open WPS Spreadsheet, go to the Formulas tab, and confirm that Name Manager is available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | You can use the Name Box for quick naming, or use Name Manager to create names for cells, ranges, formulas, and values, then use those names directly in formulas. | Excel lets you define names for a cell range, function, constant, or table, and manage them in Name Manager. | Google Sheets supports named ranges to keep formulas cleaner, and lets you edit or delete named ranges. | Notion formulas work with database properties, built-ins, and functions, rather than a spreadsheet-style name manager. | Adobe Acrobat Sign text tags define form fields with structured text and are designed for document field placement, not spreadsheet name management. |
| WPS Advantages | Advantage: WPS on macOS combines quick naming from the Name Box, centralized management in Name Manager, edit and delete actions, and direct formula references in one spreadsheet workflow. | Compared with WPS: Excel documents a broader defined-name system that also covers tables and functions; WPS focuses on the naming and management flow described for spreadsheet workbooks. | Compared with WPS: Google Sheets documentation centers on named ranges, while WPS also documents names for formulas and constant values in this feature flow. | Compared with WPS: Notion is suited to database formulas, not traditional spreadsheet range naming or Name Box operations. | Compared with WPS: Adobe focuses on document form fields and signing workflows rather than spreadsheet formulas and named ranges. |
| Official Source | — | Define and use names in formulas | Name a range of cells | Intro to formulas | Text Tags in Adobe Acrobat Sign |
Overall Conclusion
If your main goal is to name spreadsheet content, reuse references, and keep formulas easier to maintain, WPS Name Manager fits that workflow directly on macOS. The other products listed here focus on broader workbook naming, named ranges only, database formulas, or document field authoring.
Use Cases
| No. | Scenario | Suitable For | Main Challenge | How Name Manager Helps |
|---|---|---|---|---|
| 1 | Organizing finance formulas | Finance teams and bookkeepers | Cell references are hard to read in long formulas | Replace direct references with meaningful names |
| 2 | Reusing ranges across sheets | Analysts and reporting users | The same ranges are reused repeatedly | Create and manage names in one place |
| 3 | Handing off spreadsheet templates | Team collaborators | New users may not understand existing formulas | Use descriptive names to improve readability |
| 4 | Reusing constants or formulas | Advanced spreadsheet users | Re-entering constants or complex references takes time | Save them as names and reuse them later |
Membership & Benefits
Free vs WPS Premium
| Item | Free | WPS Premium |
|---|---|---|
| Quick naming from the Name Box | ✅ | ✅ |
| Create, edit, and delete names in Name Manager | ✅ | ✅ |
| Use names in formulas | ✅ | ✅ |
| Cloud space and additional premium benefits | Basic benefits | More benefits and storage |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended Plan | Why |
|---|---|---|
| Everyday spreadsheet editing and basic name management | Free | The core Name Manager workflow is available for regular use |
| Users who also need more cloud space or added cross-platform benefits | WPS Premium | A better fit when you also want storage and other premium benefits |
How to Subscribe
- WPS membership page: Subscribe now
Source: WPS Office pricing page