Name Manager questions usually focus on collaboration, naming rules, and formula maintenance; this FAQ covers 3 common questions and practical answers.
FAQ
Can other people use names created in a collaborative workbook?
- Names are stored in the current workbook, not only in one person’s local view.
- Other collaborators can continue using those names after they open the same file.
- It helps to agree on naming rules in advance so formulas stay easier to understand.
What naming rules should I follow?
- Start the name with a letter or an underscore.
- Do not start the name with a number.
- Do not include spaces or special characters, and avoid names that conflict with cell addresses.
What happens to formulas after I edit or delete a name?
- If you edit the name or its reference, related formulas follow the updated definition.
- If you delete a name that is still in use, check the related formulas to make sure they still calculate as expected.
- In collaborative workbooks, confirm the impact before deleting a shared name.
Glossary
| Term | Definition |
|---|---|
| Name Manager | The management panel used to view, create, edit, and delete names in one place. |
| Named range | A custom name assigned to a cell range so it can be used directly in formulas. |
| Reference | The cell range, constant, or formula definition that a name points to. |