How to Use WPS Name Manager on Windows

Last updated:July 20, 2026

Use WPS Name Manager through 3 how-to topics, including creating names, using names in formulas, and editing or deleting names.

How-to Index

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

How-to Guide

1. Create a Name

Entry: Formulas tab → Name Manager → New

  1. Click Name Manager on the Formulas tab.
  2. In the dialog box, click New.
  3. Enter the name you want to use.
  4. In the content area, enter or select the cell range, constant, or formula to reference.
  5. Click OK to finish.

Success Criteria

  • Interface result: The new name appears in the Name Manager list.
  • What you can do next: You can use the name directly in formulas.

Tips While Using

  • Common mistake: Avoid names that can be confused with cell addresses.
  • Environment note: Open a spreadsheet workbook before creating names.

2. Use a Name in a Formula

Entry: Type the name directly in a formula

  1. Create the name first.
  2. Select the cell where you want to enter a formula.
  3. Type the formula and use the custom name instead of a cell range reference.
  4. For example, enter =SUM(SalesData) instead of a full range address.
  5. Press Enter to confirm the formula.

Success Criteria

  • Interface result: The cell returns the expected calculation result.
  • What you can do next: The same name can continue to be used elsewhere in the workbook.

Tips While Using

  • Common mistake: Make sure the name already exists and is spelled correctly.
  • Environment note: Workbook-level names are easier to maintain across sheets.

3. Edit or Delete a Name

Entry: Formulas tab → Name Manager

  1. Open the Name Manager dialog box.
  2. Select the name you want to change.
  3. Click Edit to update the name or its reference.
  4. Click Delete to remove a name you no longer need.
  5. Close the dialog box and return to the worksheet.

Success Criteria

  • Interface result: The updated name information is shown, or the selected name is removed from the list.
  • What you can do next: Related formulas continue with the current name status or reflect the reference change.

Tips While Using

  • Common mistake: Before deleting a name, check whether formulas still use it.
  • Environment note: After editing, review important formulas to confirm the results.