Name Manager questions usually focus on formula references, deletion impact, and naming rules; this FAQ includes 3 common questions and a short glossary.
FAQ
How do I use a defined name in a formula?
- Create the name first by following the earlier steps.
- In the formula editing area, enter the name directly instead of the original cell or range address.
- Confirm the formula and check whether the result is calculated from the intended range, for example
=SUM(TotalSales).
What happens to formulas after I delete a name?
- After a name is deleted, formulas that used that name may no longer recognize the reference.
- If the workbook already contains related formulas, review those references first.
- If you still need to delete the name, replace it with direct cell references or another name first.
What naming practices should I follow in Name Manager?
- Use clear names so different data ranges are easy to distinguish.
- Avoid duplicate or confusing names in the same workbook.
- After changing a reference range, check related formula results again.
Glossary
| Term | Definition |
|---|---|
| Name | A custom identifier assigned to a cell, cell range, or reference object so it can be used directly in formulas. |
| Reference range | The cell or range location linked to a defined name. |
| Workbook | A spreadsheet file that can contain one or more worksheets, where names are usually managed within the current workbook. |