When using WPS Name Manager, common questions usually involve naming rules, reference changes, object names, and file compatibility; this FAQ includes 4 common questions and 4 glossary terms.
FAQ
Why is my name marked as invalid after I enter it?
- Check whether the name starts with a number.
- Check whether the name contains spaces or special characters.
- Check whether the name conflicts with a cell address such as A1 or B2.
- Edit the name and press Enter again.
Why can’t some names be updated as expected for their reference?
- Open Name Manager and select the target name.
- Check whether the current name can be edited directly for its reference.
- If it is not convenient to adjust the current name directly, note the original content first.
- Delete the original name and create it again with the new reference.
Where can I view the names of shapes or picture objects?
- Open the related find tools on the Home tab.
- Open the Selection Pane.
- View the names of shapes, pictures, and similar objects in the list.
- To rename a table or PivotTable, select the object first and then adjust it from the related toolbar.
Why is XLSX recommended when I save the file?
- After defining names and formulas, choose Save or Save As.
- Select a common spreadsheet format such as XLSX.
- Reopen the file and check whether the names are still available in Name Manager.
- If you need to share the file, keeping a common format can help reduce compatibility issues.
Glossary
| Term | Definition |
|---|---|
| Name Box | The field near the upper-left area of the sheet where you can type a name for the selected object. |
| Name Manager | The management window used to view, create, edit, and delete names in one place. |
| Scope | The range in which a defined name is valid, often the current workbook. |
| Absolute Reference | A fixed cell reference such as $A$1 that does not shift when you copy a formula. |