Excel Named Range Shortcut: Create, Edit, and Use Names

In Excel for Microsoft 365 on Windows, press Ctrl+F3 to open Name Manager and manage named ranges. To create names from selected row or column labels, press Ctrl+Shift+F3; to give a selected range one name yourself, type it in the Name Box and press Enter.

Which Excel named range shortcut do you need?

There is more than one useful shortcut because Excel treats creating, managing, and inserting names as different tasks. The most relevant Windows shortcuts are:

Ctrl+F3: Open Name Manager, where you can add, edit, delete, or inspect defined names.
Ctrl+Shift+F3: Create names from labels in the selected range. Excel asks whether the labels are in the top row, left column, bottom row, or right column.
F3: Open Paste Name while entering a formula, so you can insert an existing name into it.

For a single range with a name you choose, the quickest route is often the Name Box rather than a keyboard shortcut: select the cells, click the Name Box to the left of the formula bar, type a valid name, and press Enter. That distinction matters: Ctrl+Shift+F3 uses existing labels to generate names, while the Name Box lets you enter a name directly.

How Ctrl+Shift+F3 creates names from labels

This shortcut is especially useful when a table already has descriptive headings and you want a name for each row or column. For example, suppose A1:C4 contains headings in the top row—North, South, and West—and quarterly figures below them. Select A1:C4, press Ctrl+Shift+F3, check Top row, and confirm. Excel uses the headings to create names for the corresponding data beneath them. The heading cells themselves are not part of those named ranges.

Select the labels and the data cells they describe.
Press Ctrl+Shift+F3.
Choose the location of the labels in the Create Names from Selection dialog.
Confirm the dialog, then check the results in Formulas > Defined Names > Name Manager.

Choose the checkbox that matches the layout. If labels run down the first column and each label describes values in its row, select Left column. If both the top row and left column contain labels, you can select both options. Excel then creates names from each applicable label. Inspect the names afterward: headings with spaces or punctuation may be adjusted to fit Excel’s naming rules, and similar labels can produce names that need a closer look.

Creating one named range with the Name Box

Use this method when you want a particular name for a range, or when there is no label in the sheet to use. Select the cells, click the Name Box at the left end of the formula bar, enter a name such as MonthlySales, and press Enter. The selection remains the cells referred to by that name. You can also select a range first and use Formulas > Defined Names > Define Name to enter a name and confirm its reference in a dialog.

The Name Box is not just a place to create names. Click its drop-down arrow to select an existing name and jump to the cells it refers to. You can also type a cell address such as B2:B10 there to move the selection. If you accidentally type a name while a cell is active rather than the Name Box, Excel may enter that text into the cell; check that the cursor is in the Name Box before typing.

Managing and checking names in Name Manager

Press Ctrl+F3 to open Name Manager, or go to Formulas > Defined Names > Name Manager. The manager lists defined names and shows what each one refers to. It is the best place to check whether a name points to the intended cells, change its reference, or remove an obsolete name. Names can refer to a cell or range, but they can also represent a formula or a constant, so not every entry is necessarily a named range in the narrow sense.

To add a name from Name Manager, choose New, enter the name, select its scope, and set the reference in Refers to. To edit an existing entry, select it and use Edit. Be cautious when changing a name used in formulas: changing its reference can alter the results of every formula that uses it. Deleting a name can leave formulas that refer to it with a #NAME? error.

Using a named range in a formula

A main benefit of a name is that it can make formulas easier to read. Assume cells B2:B5 contain 120, 150, 90, and 140, and the range B2:B5 has been named QuarterSales. Enter this formula in any suitable cell:

=SUM(QuarterSales)

The result is 500, because 120 + 150 + 90 + 140 = 500. The name can also be selected from the Name Box or inserted while building a formula. In Windows desktop Excel, press F3 during formula entry to open Paste Name, choose a name, and confirm. This is handy if a workbook has many long names that would be easy to mistype.

Names can make formulas more understandable, but they do not automatically make a workbook error-proof. A name that points to the wrong cells still produces a plausible-looking but incorrect result. For calculations that use a name, verify the reference in Name Manager and check the result against a small, known example when possible.

Name rules, scope, and relative references

Excel applies naming rules that explain many failed attempts. A name cannot contain spaces, cannot be written like a cell address such as A1, and must begin with a letter, underscore, or backslash. After the first character, names can also include numbers and periods. Names are not case-sensitive, so Excel treats Sales and sales as the same name. A practical convention is to use a clear word or words joined with underscores, such as Annual_Total.

Every name has a scope: workbook or a particular worksheet. A workbook-scoped name can generally be used from any sheet in that workbook. A sheet-scoped name is associated with one worksheet and may take precedence over a workbook-scoped name with the same spelling when used on that sheet. The scope appears in Name Manager. If a formula cannot find the name you expect, check both its spelling and its scope before recreating it.

When Excel creates a name for a selected range, its reference is usually absolute, so it continues to point to the same cells when used in a formula copied elsewhere. Names can also be defined with relative references, which behave differently depending on the active cell. That behavior can be useful for specialized formulas, but it is a common source of confusion when a name seems to shift or return different results. For ordinary ranges, check the Refers to entry and use fixed cell references unless you deliberately need relative behavior.

Common named range problems and fixes

The name is rejected: Remove spaces and make sure it does not resemble a cell address. Use an underscore instead of a space, as in Quarter_One.
The shortcut opens the wrong feature: Ctrl+F3 manages names; Ctrl+Shift+F3 creates names from selected labels. Confirm that you are using the shortcut for the task you intend.
A formula shows #NAME?: Check for a misspelling, a deleted name, or a worksheet-scoped name being used from a different sheet. Name Manager can reveal whether the name exists and what it refers to.
The name refers to the wrong cells: Select it in Name Manager and inspect Refers to. Edit the reference rather than creating a second name with a similar spelling.
New rows are not included: A name that points to a fixed range such as B2:B20 may not expand when rows are added elsewhere. Update the reference, or consider using an Excel Table when the data grows over time.

A named range and an Excel Table are related but different. A name gives a label to a reference; a Table adds a structured data object with headers, filters, and formulas that can expand as records are added. For a stable input range or a small calculation area, a named range may be enough. For a growing list of transactions or records, a Table is often easier to maintain.

Excel for Mac and Excel for the web

The shortcuts above are for Excel for Microsoft 365 on Windows. Keyboard mappings can differ on Mac depending on the keyboard and function-key settings, so the most dependable Mac route is to use the Formulas tab and its name tools, or the Name Box to assign a name directly. If a keyboard shortcut is intercepted by macOS or a function key controls a hardware feature, use the ribbon command instead. The Name Box method does not depend on the Windows shortcut.

Excel for the web may also have browser-specific shortcut behavior, and its ribbon can vary slightly from the desktop layout. Use the Formulas tab to find the available name commands or use the Name Box to create and select names. If you are following instructions for the desktop app and cannot find a command in the web version, check whether the workbook is open in the installed Excel app; some interface details and keyboard behavior are not identical.

Frequently Asked Questions

What is the shortcut to create a named range in Excel?
For a name you choose, select the cells, type the name in the Name Box, and press Enter. Ctrl+Shift+F3 creates names from selected row or column labels; it does not simply prompt you for one custom name.

What does Ctrl+F3 do in Excel?
In Excel for Microsoft 365 on Windows, Ctrl+F3 opens Name Manager. Use it to view, create, edit, or delete defined names and check their scope and cell references.

How do I create names from column headings?
Select the headings together with the data beneath them, press Ctrl+Shift+F3, select Top row, and confirm. Excel creates names based on those headings for the cells below each one.

How do I insert a named range into a formula?
Type the formula and enter the name where the cell reference belongs. In Windows desktop Excel, F3 opens Paste Name during formula entry so you can choose an existing name.

Why does Excel say a name is invalid?
Names cannot include spaces or look like cell addresses such as A1. Start with a letter, underscore, or backslash, and use underscores between words—for example, Sales_2026.

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.