WPS Name Manager is a spreadsheet feature for defining and managing 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 |
| Version limit | No specific limit stated | No version threshold is described for this feature |
About This Feature
Overview
Name Manager is a built-in spreadsheet feature in WPS Office for Windows. It lets you assign custom names to cells, cell ranges, formulas, constant values, and some objects so formulas are easier to read and references are easier to manage.
Its main capabilities include:
- Quickly naming a selected item through the Name Box for everyday spreadsheet work.
- Creating a new name in Name Manager with scope, reference, and comments.
- Viewing, editing, and deleting existing names to keep workbook naming organized.
- Using names directly in formulas instead of cell addresses.
This feature is useful for monthly reports, summary models, budget sheets, and workbooks that reuse the same data ranges. It is also helpful when you want cleaner spreadsheet formulas and easier handoffs.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No mandatory internet connection is required for local naming and formula references |
| Other | Open a WPS Spreadsheet file and make sure you have editing permission |
Download & Installation
Before using Name Manager, install WPS Office on your Windows device and open WPS Spreadsheet.
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Spreadsheet, go to the Formulas tab, and confirm that Name Manager or the Name Box entry is available |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Supports quick naming through the Name Box, and also lets you create names for cells, ranges, formulas, and values in Name Manager for direct use in formulas. | Excel provides a Name Manager for defined names and table names, with scope, comments, sorting, filtering, editing, and deletion in one dialog box. | Google Sheets supports named ranges so you can name a range, use it in formulas, and edit or delete it later. | Notion organizes data through database properties and formula properties, but it does not provide a worksheet-style named range manager. | Acrobat focuses on PDF form fields and field properties, rather than named worksheet ranges for spreadsheet calculation. |
| WPS Advantages | Advantage: WPS combines quick naming in the Name Box, centralized maintenance in Name Manager, and direct formula references in one spreadsheet workflow. | Compared with WPS: Excel documents more filtering, sorting, and scope inspection in its manager; WPS focuses on quick naming, creating, editing, deleting, and formula use in a spreadsheet workflow. | Compared with WPS: Google Sheets centers on named ranges in a web-based workflow; WPS also provides a dedicated Name Manager entry and Name Box path in the desktop interface. | Compared with WPS: Notion formulas work on database properties rather than spreadsheet cell ranges, so it is not a direct replacement for named range management. | Compared with WPS: Acrobat field naming is designed for PDF form collection, while WPS Name Manager is designed for spreadsheet calculation and range references. |
| Official Source | — | Use the Name Manager in Excel | Name a range of cells | Database properties | PDF forms help |
Overall Conclusion
If your work centers on naming ranges, maintaining references, and writing clearer spreadsheet formulas, WPS Name Manager covers the common workflow well. Compared with online document tools, database tools, or PDF form tools, it is closer to a traditional spreadsheet experience. Compared with Excel, the core approach is similar for everyday name management inside WPS Spreadsheet.
Use Cases
| No. | Scenario | Suitable users | Main challenge | How Name Manager helps |
|---|---|---|---|---|
| 1 | Monthly sales summaries | Finance teams and sales operations | Long range references are hard to review in formulas | Create names for sales ranges and use them directly in formulas |
| 2 | Budget template building | Admin staff and project managers | The same data range is reused across multiple sheets | Maintain references in one place through Name Manager |
| 3 | Complex formula cleanup | Data analysts | Formulas are hard to read and hand over | Replace cell coordinates with custom names |
| 4 | Object naming | Spreadsheet editors | Many pictures or objects are hard to identify | Use the Name Box to assign clearer names |
| 5 | Reusing constants and formulas | Advanced spreadsheet users | Constants and formulas are entered repeatedly | Create names for constant values or formulas in Name Manager |
Membership & Benefits
Free vs WPS Premium
Name Manager is not marked as a membership-only feature and can be used in the free workflow. The WPS Office pricing page highlights broader benefits such as PDF tools, templates, cloud storage, and other extended tools.
| Capability | Free | WPS Premium |
|---|---|---|
| Basic Name Manager usage | ✅ Available | ✅ Available |
| Basic spreadsheet editing | ✅ Available | ✅ Available |
| Advanced PDF and extended tools | Some basic capabilities are available as listed on the product page | More advanced capabilities and extended benefits are available |
| Cloud storage and template benefits | Basic quota and basic templates | Higher quota and more template benefits |
Source: WPS Office pricing page
Recommendations
| Use case | Recommended plan | Why |
|---|---|---|
| Everyday naming and formula cleanup in spreadsheets | Free | Name Manager itself is not marked as membership-only, so it is suitable for common naming tasks |
| Users who also need more PDF, template, or cloud benefits | WPS Premium | A better fit when you need broader office benefits beyond this spreadsheet feature |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page