When using WPS Name Manager, common questions usually involve naming rules, reference changes, object names, and formula usage; this FAQ includes 4 common questions and 4 glossary terms.
FAQ
Why does the name show as invalid after I enter it?
- Check whether the name contains spaces or special characters such as @ or #.
- Make sure the name does not start with a number.
- Avoid using cell addresses such as A1 or B2 as the name.
- Edit the name and press Enter again to save it.
Why can’t I directly change the reference for some names?
- Open Name Manager and select the target name.
- Review the current name type and reference content first.
- If the current item does not support direct reference changes in your workflow, delete the original name and create a new one.
- Check the formula again after recreating the name.
Where can I view the names of shapes and picture objects?
- Open the Home tab.
- Click Find, then open the Selection Pane.
- View the names of shapes, pictures, and other objects in the pane.
- If needed, return to the related entry and adjust the object name.
How can I keep the reference from moving with the cell?
- Select the target reference when creating a name or editing the reference.
- Press F4 to switch the reference to an absolute reference.
- Confirm that the reference appears in a format such as
$A$1. - Save the setting and use the name again in the formula.
Glossary
| Term | Definition |
|---|---|
| Name Box | The area at the upper-left of the spreadsheet where you can enter or view a name for quick naming and navigation. |
| Name Manager | The management window used to view, create, edit, and delete names in one place. |
| Scope | The range where a name is valid, usually at the workbook level or a specific worksheet level. |
| Absolute reference | A reference format that uses $ to lock row and column positions so the reference stays fixed when formulas are copied. |