WPS Sheets Collaboration Mode Name Manager Feature User Guide

Feature Summary

The Name Manager allows you to create custom names for cell ranges, formulas, or constants in collaborative spreadsheets, enabling team members to use more intuitive and understandable names in formula references and collaborative communication.

Feature Description

Feature Dimension	Description
Membership Restriction	No membership restriction
Version Restriction	No version restriction

Operation Steps

Create a New Name

Feature Entry
"Formulas" tab → "Name Manager" → "New"

1. Click the "Name Manager" button in the Formulas tab
2. Click "New" in the pop-up dialog box
3. Set the following in the pop-up window:

• Name: Enter a custom name (e.g., SalesData)
• Refers To: Can enter a cell reference, constant, or formula

4. Click OK, and the name creation is complete

Use Names in Formulas

Feature Entry
Enter the name directly in the formula

1. After creating a name, you can directly use the custom name in formulas to replace range references
2. For example: =SUM(SalesData) replaces =SUM(Sheet1!$A$1:$A$100)
3. The name can be used in all worksheets within the current workbook
4. Collaborators can also use the names you created to write formulas

Edit and Delete Names

Feature Entry
"Formulas" tab → "Name Manager"

1. Open the "Name Manager" dialog box
2. Select the name item you want to modify
3. Click "Edit" to modify the name, reference range, and so on.
4. Click "Delete" to remove unwanted names
5. After modification, all formulas using that name will be automatically updated synchronously

FAQ

Q1: Can names created in collaboration mode be used by others?

• Solution: Yes, names in the Name Manager are saved in the document. All collaborators can use the names you created to write formulas after opening the document, without needing to recreate them.

Q2: What are the rules for naming names?

• Solution: Names must start with a letter or underscore, cannot start with a number, and cannot contain spaces or special characters (such as @, #, $).

Notes

1. Names are globally referenceable within the workbook scope; naming should be clear and explicit for team understanding
2. Avoid using names that may cause conflicts (such as names identical to cell addresses)
3. It is recommended to unify naming conventions within the collaborative team to facilitate formula maintenance and error troubleshooting