How to Use WPS Name Manager on macOS

Use WPS Name Manager with 4 how-to topics, including 4 free topics and 0 membership-related topics; choose a task from the index and follow the steps to finish it.

How-to Index

How-to Guide

1. Quick Naming with the Name Box

Entry point: Left side of the editing area → Name Box

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

Success Criteria

• Interface result: The name appears in the Name Box.
• What you can do next: You can use the name to locate the object or reference it in a formula.

Tips While Using

• Common mistake: Do not use a name that conflicts with a cell address, and avoid unsupported characters.

2. Create a Name in Name Manager

Entry point: Formulas tab → Name Manager → New

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

Success Criteria

• Interface result: The new name appears in the Name Manager list.
• What you can do next: You can edit it, delete it, or use it directly in a formula.

Tips While Using

• Common mistake: An incorrect reference can affect later formula results.

3. Edit or Delete a Name

Entry point: Formulas tab → Name Manager

1. Open Name Manager.
2. Select an existing name in the list.
3. Edit the name or its reference as needed, then save the change.
4. If you no longer need the name, select it and click Delete.

Success Criteria

• Interface result: The updated name information appears in the list, or the selected name is removed.
• What you can do next: You can continue managing other names or return to the sheet to check formula results.

Tips While Using

• Common mistake: If you delete a name that is already used in formulas, those formulas may need to be adjusted.

4. Use a Name in a Formula

Entry point: Cell editing mode → Formula input area

1. Define the name first.
2. Select the target cell and start entering a formula.
3. Type the defined name directly in the formula.
4. When the name suggestion appears, press Tab to insert it.
5. Press Enter to complete the formula, for example =SUM(JanuarySales,FebruarySales).

Success Criteria

• Interface result: The formula shows the defined name instead of only a direct cell reference.
• What you can do next: You can copy the formula, adjust the calculation, or review the result.

Tips While Using

• Common mistake: If the name has not been created yet, it will not be available in the formula.
• Environment note: If you do not want the reference to move with cells, use an absolute reference.