In Excel for the web, a named range is a descriptive name for a cell or range, which you can then use in formulas. To create one quickly, select the cells, type a name in the Name Box to the left of the formula bar, and press Enter; to manage names, use Formulas > Name Manager.
What a named range does
A cell reference such as B2:B5 tells Excel where values are, but it does not explain what those values represent. Naming that range Q1Sales makes a formula easier to read and maintain. A name can refer to one cell, a block of cells, or—in the Name Manager—a formula or constant. Named ranges are saved with the workbook, so they are not merely labels visible to the person who created them.
Names are useful when you reuse the same input or range in several formulas. For instance, a workbook might use names such as TaxRate, ProductList, or MonthlyExpenses. A descriptive name can also make it easier to recognize a formula’s purpose when reviewing a workbook or handing it to a colleague. A name does not change the underlying values, formatting, or location of the cells; it gives that reference a convenient identifier.
Create a named range in Excel for the web
The Name Box is the quickest way to name a selection. It sits at the left end of the formula bar and normally displays the active cell address, such as A1. Use a short name that describes the contents rather than the current position, since rows and columns may move as a workbook changes.
- Select the cell or range you want the name to refer to. For example, select B2:B5 if those cells contain quarterly sales figures.
- Click the Name Box, type a name such as
Q1Sales, and press Enter. Do not type the name into a worksheet cell. - To check it, open the Name Box dropdown and look for the name, or open Formulas > Name Manager and inspect the listed reference.
- To use the name, enter a formula in another cell that refers to it. Excel will resolve the name to its associated cell or range.
Excel names have rules. They cannot contain spaces, and they cannot look like cell references. Names are not case-sensitive, so Excel treats Q1Sales and q1sales as the same name. Use letters, numbers, underscores, or periods in a readable combination; starting with a letter or underscore is a dependable choice. If Excel rejects a name, remove spaces and punctuation such as hyphens, and check that it is not already in use.
View, edit, or delete names
Open Formulas > Name Manager to review the names defined in the workbook. The manager is more useful than the Name Box when a workbook has many names: it lets you inspect a name’s reference and, where the available controls permit, create, edit, or delete definitions. Select a name to see what it refers to before changing it. The exact controls can depend on the current Excel for the web interface and the workbook’s features.
When editing a definition, make sure the reference points to the intended sheet and cells. A name that points to the wrong range may still produce a valid-looking result, making the error easy to miss. After editing, check one or more formulas that use the name. Deleting a name removes the definition, not the cells or their contents; formulas that relied on it may then return a name error. If the manager does not offer the particular scope or edit control you need, open the workbook in the desktop Excel app and make the change there.
The Name Box is also handy for navigating. Choose a listed name from its dropdown to select the cells it refers to. This can save time in a large worksheet, but remember that the selection may be on a different sheet from the one currently visible.
Use a name in a formula
Once a range has a name, use it anywhere a compatible formula would accept a cell reference. For example, suppose A1:A5 contains labels, B2:B5 contains the four quarterly sales values 120, 135, 98, and 147, and B2:B5 is named Q1Sales. With that layout and name in place, enter this in B6:
=SUM(Q1Sales)
The result is 500, the total of 120 + 135 + 98 + 147. The formula remains readable even if you do not remember the range’s address. You can also use a name as part of a larger calculation, provided the formula is valid for the type of reference the name represents.
A name can refer to a single input cell as well as a multi-cell range. For example, if C2 contains a discount rate and is named DiscountRate, a formula can use that name in a calculation rather than repeating C2. With the original price in B2 and the discount rate in C2 named DiscountRate, enter this in D2:
=B2*(1-DiscountRate)
If B2 contains 80 and C2 contains 0.1, the result is 72. The cell’s percentage formatting affects how the rate is displayed, not the arithmetic. Names make the formula more expressive, but they do not validate whether the input itself is sensible.
Workbook scope and worksheet scope
A name’s scope determines where it is recognized. A workbook-scoped name is available throughout the workbook. A worksheet-scoped name is associated with one sheet and can be useful when different sheets need separate definitions with the same short name. Scope matters in formulas: if a local name and a workbook name share a name, Excel’s resolution rules can make a formula refer to the sheet-level definition. Avoid duplicate names unless there is a clear reason and you understand which definition each formula will use.
When creating or changing a name in Name Manager, inspect the Scope field if it is shown. The simple Name Box method is best for a straightforward name that should be available across the workbook. If you specifically need a worksheet-level name and the web interface does not expose the required scope option, use desktop Excel. Do not assume that two identically spelled names on different sheets are interchangeable; verify the scope and the reference displayed by the manager.
Names that expand as data grows
A common question is whether a named range automatically includes new rows. A name that refers to a fixed address, such as B2:B20, generally continues to refer to that defined range; typing data in B21 does not by itself guarantee the name expands to include it. This can cause totals or lookups to omit newly added records.
For a list that will grow, consider converting the data to an Excel table with Insert > Table. Tables expand as rows are added and provide structured references that identify columns by their headings. This is often a better fit for ongoing records, such as transactions or inventory, than a manually maintained fixed range. A named range remains useful for a stable block, a specific input, or a calculation area. If you keep a fixed named range, review its reference when adding rows and update it when appropriate.
Excel for the web compared with desktop Excel
Excel for the web can work with named ranges and offers the Name Box and Name Manager for common tasks. Desktop Excel for Microsoft 365 on Windows also has a Name Box and a Name Manager on the Formulas tab, and may provide additional controls for more complex definitions. For example, a workbook with worksheet-specific scope or intricate references may be easier to inspect and maintain in the desktop app if the web interface does not expose the needed option.
Names are part of the workbook rather than a browser-only feature. A colleague who opens the same workbook in desktop Excel can use its defined names too, subject to compatibility with any formula features involved. The desktop and web interfaces may differ, so a menu instruction for one should not automatically be assumed to match the other. On a Mac, the desktop ribbon and dialogs can look different from Windows; the browser-based Excel for the web workflow is generally through the same web ribbon regardless of the computer’s operating system.
Common problems and fixes
- Excel says the name is invalid: remove spaces, avoid a cell-like name such as A1, and use a name that starts with a letter or underscore.
- A formula displays a name error: check the spelling, confirm that the name still exists in Name Manager, and verify that the formula is using the intended scope. If the name was deleted or renamed, update the formula.
- The result leaves out recent rows: inspect the range listed for the name. A fixed range may not have grown; extend it or use a table for data that is routinely appended.
- The wrong cells are selected: check the name’s reference and sheet in Name Manager. A name can refer to a different worksheet than the one currently open.
- A name works in one place but not another: check for a worksheet-scoped name that overrides a workbook-scoped definition. Give names distinct, descriptive labels if the scope distinction is unnecessary.
Before making extensive changes to names in a shared workbook, coordinate with other editors. A name can feed many formulas, charts, or validation settings, and changing its reference may affect more than the cell currently on screen. If an unfamiliar workbook contains many definitions, inspect them before deleting anything.
When to use a named range instead of an alternative
Use a named range when a reference has a stable meaning and is reused, such as an assumptions cell or a fixed block used in several calculations. Use ordinary cell references for a one-off calculation where naming would add little clarity. For expanding datasets, a table is often more robust because its rows and columns have meaningful headings and the table grows with new entries. For a formula that needs a value only once, a descriptive variable-like name may not justify adding a separate workbook definition.
Names are not the same as table column headings, worksheet tab names, or labels typed into cells. They are workbook definitions that formulas can reference. Choosing among these tools depends on the shape of the data: a named range is clear for a stable area, while a table is usually easier to maintain for a list that changes over time.
Frequently Asked Questions
Can I create a named range in Excel for the web?
Yes. Select the cell or range, type a valid name in the Name Box beside the formula bar, and press Enter. Formulas > Name Manager is the place to review names and use the management controls available in your version of Excel for the web.
How do I use a named range in a formula?
Write the name where the formula would normally use the corresponding cell or range reference. For instance, a range named Q1Sales can be used as the argument in a sum formula. Check that the name points to the intended cells if the result is unexpected.
Can named ranges include spaces?
No. Use a space-free name such as AnnualSales or Annual_Sales. Names also cannot be written in a way that Excel interprets as a cell reference.
Will a named range automatically include new rows?
Not necessarily. A name referring to a fixed address may continue to cover only that address. For records that keep growing, an Excel table is often a more reliable option; otherwise, check and expand the named range when you add data.
Can I rename or delete a named range?
Open Formulas > Name Manager and select the definition. Use the available edit or delete controls, then check formulas that depend on it. Deleting a name does not delete the worksheet cells, but formulas that use the name can stop working.
Related
- Excel Text to Columns Wizard: Split Data Easily
- Excel Text to Columns: Split Data Cleanly and Safely
- Excel Text to Columns: Why Leading Zeros Disappear
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Hide Columns Just for Me? Use a Personal Sheet ViewYes. In Excel for Microsoft 365, create a Sheet View, then hide the columns while that view is…
- Ethanol Blending Percentage in Google SheetsTo calculate an ethanol blend percentage in Google Sheets, divide the volume of ethanol by the total volume…
- How to Add a Header to Every Page in Microsoft WordTo add a header to every page in Word, choose Insert > Header, select a layout, and type…
- How to Split an Excel Sheet in Half Using Split PanesTo split an Excel worksheet into independently scrollable sections, select the cell where the split should meet, then…
- Excel Hide Page Break Dotted Lines: What to ChangeTo hide page-break dotted lines in Excel for Microsoft 365 on Windows, open File > Options > Advanced,…
- How to Create Inbox Rules in New Outlook Step by StepTo create an inbox rule in New Outlook, open Settings > Mail > Rules, select Add new rule,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.