Common questions about WPS Name Manager usually involve naming rules, formula references, and what happens after deletion; this FAQ covers 3 frequent questions.
FAQ
What naming rules should I follow for a defined name?
- Use a clear name that reflects the business meaning of the range or formula.
- Avoid names that conflict with cell reference patterns.
- Choose a format that is easy to type and maintain in formulas.
What is the purpose of using defined names?
- A defined name can replace a long cell or range reference.
- Formulas become easier to read when they use meaningful names.
- Team members can understand workbook logic more quickly during collaboration or handoff.
What happens if I delete a name?
- Open Name Manager and confirm whether the name is still in use.
- If formulas reference that name, those formulas may no longer work correctly after deletion.
- Before deleting, consider whether editing the name or adjusting its reference would be more appropriate.
Glossary
| Term | Definition |
|---|---|
| Name Manager | A panel used to view, create, edit, and delete defined names in one place. |
| Defined name | A custom label assigned to a cell range, formula, or constant so it can be referenced more clearly in formulas. |
| Reference range | The actual cell range, formula content, or constant value associated with a defined name. |