Use WPS Name Manager through 3 how-to topics: create a name, use a name in a formula, and edit or delete a name; all 3 are available without membership.
How-to Index
| No. | Topic | Membership |
|---|---|---|
| 1 | 1. Create a Name | Free |
| 2 | 2. Use a Name in a Formula | Free |
| 3 | 3. Edit or Delete a Name | Free |
How-to Guide
1. Create a Name
Entry: Formulas → Name Manager → New
- Click Name Manager on the Formulas tab.
- In the dialog box, click New.
- Enter a custom name in the name field.
- Enter a cell reference, constant, or formula in the content area.
- Click OK to finish creating the name.
Success Criteria
- Interface result: The new name appears in the Name Manager list.
- What you can do next: You can type that name directly in formulas in the current workbook.
Tips While Using
- Common mistake: Avoid using a name that looks like a cell address, because it can make references harder to distinguish.
- Environment note: You need edit permission for the current workbook.
2. Use a Name in a Formula
Entry: Type the name directly in a cell formula
- Make sure the target name has already been created.
- Select the cell where you want to enter the formula.
- Type the formula and use the custom name instead of a direct range reference.
- For example, enter
=SUM(SalesData)instead of a full range address. - Press Enter to confirm the formula.
Success Criteria
- Interface result: The formula bar shows the custom name instead of the original range address.
- What you can do next: Other worksheets in the same workbook can continue using that name.
Tips While Using
- Common mistake: If the name is typed incorrectly, the formula may not recognize it correctly.
- Environment note: The name is used within the current workbook, so collaborators need to open the same file.
3. Edit or Delete a Name
Entry: Formulas → Name Manager
- Open the Name Manager dialog box.
- Select the name you want to change in the list.
- Click Edit to change the name or its reference.
- If you want to remove it, click Delete.
- Confirm the result after the change.
Success Criteria
- Interface result: The selected name is updated or removed from the list.
- What you can do next: Related formulas continue working with the updated name or reference result.
Tips While Using
- Common mistake: If you delete a name that is still used in formulas, those formulas may need to be checked.
- Environment note: In team workbooks, it helps to agree on naming rules before making broad changes.