How to Use WPS Name Manager on Windows

Use WPS Name Manager through 4 operation topics, including quick naming, creating a new name, editing or deleting names, and using names in formulas; 4 items are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Quick Naming with the Name Box

Feature entry: Formulas → Name Box

1. Select the cell, cell range, picture, or other object that you want to name.
2. Enter a custom name in the Name Box at the upper-left area of the spreadsheet.
3. Press Enter to finish naming.

Success Criteria

• The name is saved and can be viewed in the Name Box.
• When you select the related item, the new name is shown.

Tips While Using

• Use a name that is easy to recognize and does not look like a cell address.

2. Create a Name in Name Manager

Feature entry: Formulas → Name Manager → New

1. Click Name Manager on the Formulas tab, or press Ctrl+F3.
2. In the Name Manager window, click New.
3. Enter a custom name and choose the scope. The default scope can be the workbook.
4. Fill in the reference. It can be a cell, a cell range, a constant value, or a formula, and you can add comments if needed.
5. Click OK to finish creating the name.

Success Criteria

• The new name appears in the Name Manager list.
• The name can be used later in formulas or location-based actions.

Tips While Using

• Confirm the target range before you fill in the reference.
• If you need a fixed reference, use an absolute reference format.

3. Edit or Delete a Name

Feature entry: Formulas → Name Manager

1. Open Name Manager and select an existing name.
2. Edit the name text as needed or review the current reference content.
3. If the name is no longer needed, select it and click Delete.
4. Confirm the action to finish saving or deleting.

Success Criteria

• The updated name appears correctly in the list, or the unneeded name is removed.
• The workbook name list stays organized.

Tips While Using

• Before deleting a name, check whether it is already used in formulas.

4. Use a Name in a Formula

Feature entry: Enter a formula in a cell

1. Create the name first.
2. In the target cell, type an equal sign and begin editing the formula.
3. Type the name directly, then press Tab when the suggestion appears.
4. Finish the formula, for example =SUM(JanuarySales,FebruarySales).
5. Press Enter to calculate the result.

Success Criteria

• The formula shows the custom name instead of a cell address.
• The formula returns a valid result.

Tips While Using

• If the name is not recognized, check whether it has already been created and spelled correctly.
• Saving the file in XLSX format can help preserve name definitions.