How to Use WPS Name Manager on macOS

Last updated:July 20, 2026

Use WPS Name Manager through 3 how-to topics: create a name, use a name in a formula, and edit or delete a name; choose a topic from the index and follow the steps.

How-to Index

No.TopicMembership Requirement
11. Create a NameFree
22. Use a Name in a FormulaFree
33. Edit and Delete a NameFree

How-to Guide

1. Create a Name

Entry: Formulas tab → Name Manager → New

  1. Click the Formulas tab.
  2. Click Name Manager.
  3. In the dialog box, click New.
  4. Enter a custom name.
  5. In the content area, enter a cell reference, constant, or formula.
  6. Click OK to finish.

Success Criteria

  • Interface result: the new name appears in the Name Manager list.
  • What you can do next: you can type the name directly in a formula.

Tips While Using

  • Common mistake: avoid names that look like cell references.
  • Environment note: open a workbook before creating a name.

2. Use a Name in a Formula

Entry: Type the name directly in a formula

  1. Make sure the target name has already been created.
  2. Select a cell and start entering a formula.
  3. Type the custom name instead of a direct range reference.
  4. For example, use =SUM(SalesData) instead of a long range address.
  5. Continue using the same name in other worksheets within the current workbook as needed.

Success Criteria

  • Interface result: the formula bar shows the custom name instead of a long range address.
  • What you can do next: the formula can still be edited, copied, and calculated.

Tips While Using

  • Common mistake: make sure the spelling matches the defined name exactly.
  • Environment note: names are used within the current workbook, so another workbook needs its own definition.

3. Edit and Delete a Name

Entry: Formulas tab → Name Manager

  1. Open Name Manager.
  2. Select the name you want to change or remove.
  3. Click Edit to update the name or its reference.
  4. Click Delete to remove a name you no longer need.
  5. Check related formulas after the change.

Success Criteria

  • Interface result: the name list is updated or the selected name is removed.
  • What you can do next: related formulas continue with the updated name or show that the old name is no longer valid.

Tips While Using

  • Common mistake: deleting a name can break formulas that still reference it.
  • Environment note: check whether the name is still used elsewhere before deleting it.