Common questions about WPS Name Manager mainly involve formula references, deletion impact, and naming rules; this page includes 3 FAQs and a glossary.
FAQ
How do I use a defined name in a formula?
- Complete the steps in “Create a Custom Name” first.
- Enter a formula in the target cell.
- Type the defined name directly instead of a cell range, for example
=SUM(SalesTotal). - Confirm that the result matches the intended range.
What happens to formulas that reference a name after I delete it?
- After a name is deleted, formulas that reference it may no longer work correctly.
- If a formula result becomes abnormal, check whether it uses the deleted name.
- Recreate the same name, or replace the name in the formula with a direct cell or range reference.
- Check the calculation result again before saving.
What naming rules should I keep in mind?
- Use business-friendly names that are easy to recognize.
- Avoid duplicate names to reduce conflicts.
- After changing a referenced range, check whether related formulas still behave as expected.
- Keep important names consistent so they are easier to maintain later.
Glossary
| Term | Definition |
|---|---|
| Name Manager | The feature entry used to create, view, edit, and delete defined names. |
| Defined name | A custom name assigned to a cell, range, or related reference that can be used directly in formulas. |
| Referenced range | The cell or data range linked to a defined name. |