When using Name Manager, 3 common question types appear most often: collaboration sharing, naming rules, and ongoing maintenance. This FAQ covers 3 frequent questions.
FAQ
Can other people use names created in collaboration mode?
- Names are stored in the current document.
- Other collaborators can use those names in formulas after they open the same workbook.
- For long-term teamwork, it is helpful to use shared naming rules to reduce confusion.
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 common special characters, and avoid names that look too similar to cell addresses.
What happens to formulas after I edit or delete a name?
- Find the target name in Name Manager first.
- After editing the name or reference range, check whether related formulas still return the expected results.
- If you delete a name, review the formulas that used it and adjust them if needed.
Glossary
| Term | Definition |
|---|---|
| Name Manager | The management interface used to create, view, edit, and delete names in one place. |
| Name | A custom identifier assigned to a cell range, formula, or constant so it can be referenced directly in formulas. |
| Reference range | The cell range, formula content, or constant value associated with a name. |