Named Ranges
Replace confusing cell references like $D$1 with a plain-English name.
Compatibility: All Excel versions
What You'll Learn
- How to create a named range from the Name Box
- Why a named range behaves like an absolute reference automatically
- How to view and manage existing named ranges
Instead of writing =A2*$D$1, you can name cell D1 something like TaxRate and write =A2*TaxRate instead — a formula that reads like a sentence, and one that's much easier for someone else (or future you) to understand at a glance.
Creating a Named Range
Select a cell or range, then either type a name directly into the Name Box (to the left of the Formula Bar) and press Enter, or use Formulas > Define Name for more options, like limiting the name's scope to one worksheet.
Named Ranges Act Like Absolute References
A named range automatically behaves like an absolute reference — it won't shift when you copy a formula elsewhere, the same way $D$1 wouldn't, but without needing to remember to add the dollar signs yourself.
Managing Named Ranges
Formulas > Name Manager lists every named range in the workbook, and lets you edit or delete ones you no longer need — worth checking occasionally so old, unused names don't pile up and cause confusion.
Common Mistakes
- Naming a range something that starts with a number or contains spaces, which Excel won't allow
- Creating a named range and then forgetting it exists, leading to confusion when a formula references a name instead of a visible cell address
Practice Exercise
Name cell D1 "TaxRate" and enter 0.08 into it. In column B, write a formula using the name TaxRate (not $D$1) to calculate tax on a column of prices in column A.
Key Takeaways
- A named range replaces a cell reference with a readable name
- Named ranges behave like absolute references automatically
- Name Manager (Formulas tab) lists and manages every named range in a workbook