How to Name the Inventory Range in Excel (Step-by-Step)

How-to basics · Updated November 18, 2026

To name an inventory range in Excel for Microsoft 365 on Windows, select the cells you want to name, click the Name Box to the left of the formula bar, type Inventory, and press Enter. The name then refers to those cells, so you can select the range quickly or use it in formulas instead of repeating its cell addresses. Before starting, decide exactly which cells the name should cover; for a stock-count range, include the numbers but usually leave out the column heading.

What You’ll Need

  • An Excel workbook containing the inventory data you want to name.
  • A clear idea of the range’s purpose and boundaries. For example, name only the stock-on-hand values if you intend to total inventory quantities.
  • Permission to edit the workbook. If it is protected or read-only, you may need to remove protection or save an editable copy first.

Step-by-Step

  1. Identify the cells to include. Find the inventory data on the worksheet and decide whether the name should refer to one column, several columns, or a complete rectangular block. For example, if the heading “Stock on hand” is in B1 and the five item counts are in B2:B6, select B2:B6—not B1:B6—when you want a name that represents the quantities. Including a heading can cause it to appear in calculations or other operations that use the named range.
  2. Select the range. Use the mouse to drag across the cells, or click the first cell, hold Shift, and click the last cell. For a known address, click the Name Box, type the address such as B2:B6, and press Enter; Excel selects those cells. The Name Box is the small field immediately to the left of the formula bar, and it normally displays the active cell address, such as B2.
  3. Enter the range name. With the intended cells selected, click the Name Box, replace the displayed address with Inventory, and press Enter. Do not type the name into the formula bar or into a worksheet cell. Excel accepts the name when you press Enter, and the selection remains in place. If Excel rejects it, check the naming rules in Common Mistakes below.
  4. Confirm that the name was created. Click the Name Box’s drop-down arrow. Inventory should appear in the list of available names. Choose it to jump back to the named cells. You can also click the Name Box, type Inventory, and press Enter; Excel should select the range that the name refers to. If the selection is not the one you expected, inspect the name in Name Manager before using it.
  5. Check the reference and scope in Name Manager. On Windows, select Formulas > Name Manager, or press Ctrl+F3. Find Inventory in the list and review its “Refers to” entry. It should show the correct sheet and cell address, such as =Sheet1!$B$2:$B$6. Check the “Scope” entry too: choose Workbook if the name should work from any sheet, or a particular worksheet if it is intended for use only there. Close Name Manager when you are done; changes made there are applied to the workbook.
  6. Try the name in a formula or selection. If Inventory refers to the five stock counts in B2:B6, enter =SUM(Inventory) in an empty cell. For the example values 12, 8, 0, 15, and 5, the result is 40. This confirms that Excel can resolve the name and that the named cells contain the values you meant to total. If the result is unexpected, check the range boundaries and the values inside them.
  7. Save the workbook. Save with Ctrl+S on Windows so the defined name is retained in the file. If the workbook will be shared, consider telling collaborators what the name represents and whether it has workbook or worksheet scope. On Excel for Mac, the Name Box method works similarly; ribbon labels or their positions can differ slightly, but look under the Formulas tab for the name-definition and name-management commands. In Excel for the web, use the Name Box to create or select a name when that control is available; for advanced name edits, open the workbook in the desktop app if the web interface does not offer the options you need.

Common Mistakes

Including the heading by accident. If the name is meant for quantities, selecting the heading along with the values can lead to confusing results in formulas or downstream tasks. Select just the data cells, or deliberately include the heading only when the range’s purpose requires it.

Using spaces or punctuation that names do not allow. Excel names cannot contain spaces, and a hyphen is not allowed. Use Inventory_2026 or Inventory2026 rather than “Inventory 2026.” A name must start with a letter, an underscore, or a backslash; it can contain letters, numbers, periods, and underscores after that. Names are not case-sensitive, so Excel treats Inventory and inventory as the same name.

Choosing a name that looks like a cell address. Names such as B2 or R1C1 can be rejected because they resemble cell references. Choose a descriptive word or phrase that cannot be mistaken for an address.

Giving a name the wrong scope. A worksheet-scoped name is available only on its worksheet and can coexist with a workbook-scoped name of the same spelling. That can make formulas behave differently depending on where they are entered. If you need the name across multiple sheets, use workbook scope and confirm it in Name Manager.

Assuming the name expands automatically. A name that refers to B2:B6 will normally keep referring to that fixed address even when new inventory rows are added elsewhere. Review the reference after changing the layout, or use an Excel Table if the list will grow frequently and you want table columns to adjust as rows are added.

Tips

  • Choose a name that explains its contents. Inventory is reasonable if it has one clear purpose in the workbook. If the name refers specifically to stock quantities, InventoryQty or StockOnHand may help prevent confusion with product descriptions, prices, or the entire inventory table.
  • Use a consistent naming pattern. If the workbook has several named ranges, keep names descriptive and predictable, such as InventoryQty, InventoryCost, and ReorderLevel. Avoid changing the meaning of an existing name without checking formulas that already use it.
  • Use absolute references for a stable range. In Name Manager, a reference such as =Sheet1!$B$2:$B$6 uses dollar signs to keep the range fixed. Excel commonly creates an absolute reference when you define a name from a selection. Confirm the reference if you need the name to move or expand in a particular way.
  • Remember that names make formulas easier to read, not automatically more correct. A formula using Inventory can still give a wrong result if the name points to the wrong cells. Keep the “Refers to” address aligned with the range’s purpose, and verify important totals against the source data.
  • Consider a Table for a growing list. If inventory records are regularly appended, select the data and use Insert > Table to create a table. A table has its own name and structured column references, which can adapt as records are added. A defined range name and a table name are related ways to refer to data, but they are not the same feature.

Troubleshooting

Excel says the name is invalid. Remove spaces, hyphens, and other unsupported characters; make sure the first character is permitted; and check that the name does not look like a cell address. If you are entering the name in the Name Box, make sure the intended cells are selected first and press Enter after typing it.

The name does not appear in the Name Box list. Open Formulas > Name Manager and search the list. The name may have a worksheet-level scope, may be misspelled, or may not have been committed because Enter was not pressed. If it is missing, select the cells and create it again. If the workbook is protected or read-only, check whether you can edit its names or save an editable copy.

The name selects the wrong cells. In Name Manager, select the name and inspect “Refers to.” Correct the address there, or delete the incorrect name and recreate it from the proper selection. Check the sheet name as well as the row and column numbers; a reference to another worksheet can be valid but not what you intended.

A formula returns an unexpected total or an error. First use the Name Box to select the name and visually check the highlighted range. Then inspect “Refers to,” confirm the cells contain the intended numbers, and check for a heading or extra column included by mistake. If Excel reports an unrecognized name in a formula, confirm its spelling and scope. A worksheet-scoped name may not be available to a formula on a different worksheet.

You cannot find Name Manager or the command is unavailable. In the Windows desktop app, use Formulas > Name Manager or Ctrl+F3. If the workbook is open in a browser or a simplified ribbon, some management options may be presented differently or may not be available. Try the desktop version of Excel, and check whether the workbook is protected or opened with view-only permissions.

Frequently Asked Questions

Can I name a range “Inventory” even if a worksheet is also named Inventory?
Yes. A worksheet name and a defined range name are separate things. However, make the range name distinctive enough that you can recognize it in formulas and Name Manager.

Can one name refer to more than one separate area?
Yes, a defined name can refer to a noncontiguous reference, but that can complicate formulas and is not necessary for a simple inventory column. For easier maintenance, consider creating separate names for separate areas or using a single continuous data range.

How do I rename or delete the range later?
Open Formulas > Name Manager, select the name, and choose Edit to change its name or reference. To remove it, select Delete and confirm. Before deleting a name, check formulas that use it; they may stop working or show a name error.

Will the name update when I add new inventory items?
Not necessarily. A basic defined name usually refers to the cells specified in its address. Check Name Manager after adding rows. If the list changes often, an Excel Table is generally easier to maintain because its data area can expand when rows are added.

Can I use the name in formulas on other worksheets?
Yes, if its scope is Workbook. A name scoped to one worksheet is local to that sheet, so it may not work as expected elsewhere. Check the Scope column in Name Manager before using the name across the workbook.

Can I use a range name in place of every cell reference?
Only when the named range matches the cells the formula needs. For example, =SUM(Inventory) is suitable when Inventory refers to numeric stock counts. If it refers to an entire multi-column inventory list, SUM may add numbers from more than one column, so name the quantity column separately or use a formula designed for the specific table column.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.