Excel Shortcuts for Naming a Range and Managing Names

How-to basics · Updated November 18, 2026

In Excel for Microsoft 365 on Windows, press Ctrl+F3 to open Name Manager, then choose New to name a selected range. To create names from row or column labels in a selection, press Ctrl+Shift+F3. You can also select a range, type a name in the Name Box to the left of the formula bar, and press Enter.

What the Excel name-range shortcuts do

Excel has more than one shortcut connected to range names, and they do different jobs. Ctrl+F3 opens Name Manager, where you can create, inspect, edit, and delete defined names. It does not instantly name the current selection: after the window opens, select New, enter a name, check the range it refers to, and confirm.

Ctrl+Shift+F3 creates names from labels next to the selected cells. For example, if a table has field labels in its top row, select the labels and the data beneath them, then use the shortcut. Excel offers a choice of where the labels are located, such as the top row or left column. The result is a set of names based on those labels, rather than one name for the entire selection.

  • Ctrl+F3: open Name Manager and create or manage names.
  • Ctrl+Shift+F3: create names from labels in a selected range.
  • Name Box: quickly assign a single name to the current selection by typing it into the box and pressing Enter.

On some laptops, the function keys have hardware functions, so you may need to hold Fn as well. If a shortcut does something unexpected, use the Formulas tab or the Name Box instead.

Name a range with Name Manager

Use Name Manager when you want to specify the name, check its scope, or confirm exactly which cells it refers to. This is a useful method for a name you plan to use in formulas or share with other workbook users.

  1. Select the cells you want to name. You can also open Name Manager first, but selecting the cells beforehand usually makes it easier to verify the reference.
  2. Press Ctrl+F3. In Name Manager, choose New.
  3. Enter a name in the Name field. Keep it descriptive, such as QuarterSales or TaxRate.
  4. Choose the scope: the whole workbook or a particular worksheet. For a reusable name, workbook scope is often the more convenient choice.
  5. Check the Refers to field. Confirm that it points to the intended cells on the intended sheet, then choose OK and close Name Manager.

A defined name can refer to a cell or range, but names can also represent a formula or a constant. For a range name, the Refers to field should identify the relevant cells. A reference might point to a fixed block such as cells B2 through B50 on a worksheet named Sales. If the worksheet name contains spaces, Excel normally surrounds it with apostrophes in the reference.

Use the Name Box for a quick name

The Name Box sits at the left end of the formula bar and normally displays the address of the active cell, such as A1. To name a range without opening a dialog, select the cells, click the Name Box, type a valid name, and press Enter. The name is assigned to the selection. This is often the fastest option when you already know the name and do not need to adjust its scope.

For example, select B2:B50, type QuarterSales in the Name Box, and press Enter. To check that it worked, click the Name Box arrow and look for the name, or type the name into the box and press Enter to jump back to the named cells. The Name Box is also a quick way to select a known range without scrolling through a large worksheet.

Typing a name into the Name Box is not the same as typing an address into Go To. Ctrl+G opens the Go To dialog, which can take you to a name that already exists, but it is not the shortcut for defining a new name. If you need to inspect or change an existing definition, use Ctrl+F3.

Create names from selected labels

Ctrl+Shift+F3 is especially helpful when a worksheet has clear headings and you want names for several columns or rows at once. Suppose the top row contains headings such as January, February, and March, and the rows below contain the corresponding figures. Select the heading cells together with their data, press Ctrl+Shift+F3, and choose Top row in the dialog. Excel creates a name for each labeled column.

The selection must include both the labels and the cells they describe. If you select only the numbers, Excel has no adjacent labels from which to build names. Likewise, if the headings are in the first column, choose Left column. Check the names and references afterward: headings with spaces or punctuation may be adjusted to fit Excel’s naming rules, and repeated or unsuitable labels may not produce the names you expect.

This shortcut creates separate names based on labels; it does not turn the selected block into an Excel Table. Tables have their own structured references and can expand as data is added. If your goal is a growing, filterable data set, consider using Insert > Table as well as, or instead of, defined names.

Excel naming rules to know

A name must follow Excel’s naming rules or Excel will reject it. Names are not case-sensitive, so QuarterSales and quartersales refer to the same name. A clear name is usually easier to maintain than a short, ambiguous one.

  • A name must begin with a letter, an underscore, or a backslash. It cannot begin with a number.
  • Spaces are not allowed. Use an underscore or write words together, as in North_Region or NorthRegion.
  • A name cannot look like a cell address, such as A1 or R1C1.
  • Names can contain letters, numbers, periods, and underscores, subject to Excel’s other restrictions. Avoid punctuation that Excel does not permit.
  • Names can be up to 255 characters, but concise, meaningful names are much easier to recognize in formulas and Name Manager.

Names also have scope. A workbook-level name is available throughout the workbook. A worksheet-level name is limited to its sheet and can coexist with a workbook-level name of the same spelling. That coexistence can be confusing: a formula on a sheet may resolve to the local name rather than the workbook-level one. Use distinct names where possible, especially in shared workbooks.

Use a range name in a formula

A name can make a formula easier to read, especially when the cell address alone does not explain what the values represent. After defining QuarterSales for the cells B2:B4 on the active worksheet, you can use the name in a formula instead of entering the cell addresses directly.

With the values 12, 18, and 20 in B2:B4 and the name QuarterSales referring to those three cells, enter =SUM(QuarterSales) in another cell. The result is 50. If the name refers to the wrong sheet or a different range, the formula may still calculate but return an unexpected result, so verify the name’s definition when checking a result.

Names can also be useful for frequently reused inputs. For example, a workbook might use a named cell called TaxRate rather than embedding the same cell address in several formulas. A name does not automatically make a workbook more accurate, though: if the definition points to an outdated or incorrect cell, formulas that use it inherit that problem.

Edit, delete, or troubleshoot a name

Press Ctrl+F3 to review defined names. Name Manager shows details such as each name’s scope and its Refers to entry. Select a name and choose Edit to change its spelling, reference, or other available details. Choose Delete to remove a name that is no longer needed. Deleting a name can break formulas that use it, so check its use before removing it; Excel may display an error in dependent formulas afterward.

If a name sends you to the wrong cells, check the Refers to field and the sheet name. A common source of confusion is selecting a range on one sheet while editing a reference that points to another. Another is choosing worksheet scope when you intended workbook scope. You can also select the name in Name Manager and use the range selector beside Refers to, where available, to choose the intended cells again.

If Excel says a name is invalid, check for spaces, a leading number, or a spelling that resembles a cell address. If a formula does not recognize a name, confirm that the name exists, that its scope is visible from the formula’s sheet, and that it has not been deleted or mistyped. In formulas, names generally do not need quotation marks. A worksheet name with spaces is different: Excel uses apostrophes around that sheet name in a cell reference.

Windows, Mac, and Excel for the web

The shortcuts above are for Excel for Microsoft 365 on Windows. On a Mac, keyboard mappings can differ with the Excel release, macOS settings, and keyboard layout. Use the Formulas tab and its name-management commands if Ctrl+F3 or Ctrl+Shift+F3 does not behave as expected; the Name Box method also works as a direct alternative. Mac users with function keys assigned to system controls may need to adjust their keyboard settings or use Fn with a key combination.

Excel for the web has a different interface and may not support every desktop shortcut in the same way. Look on the Formulas tab for name-management commands, or use the Name Box if it is available in the current workbook view. For advanced name-management tasks, opening the workbook in the desktop Excel app provides the familiar Name Manager workflow. Do not assume that a Windows shortcut will work identically in a browser, where browser shortcuts can also take priority.

Frequently Asked Questions

What is the shortcut to name a range in Excel?
On Windows, Ctrl+F3 opens Name Manager, where you can choose New and define a name for the selected range. For a quick assignment, select the cells, type a name in the Name Box, and press Enter.

What does Ctrl+Shift+F3 do in Excel?
It opens the Create Names from Selection dialog. Select cells that include labels and their related data, then choose whether Excel should use the top row, bottom row, left column, or right column as the source of names.

Can I name a range without using Name Manager?
Yes. Select the range, click the Name Box to the left of the formula bar, type a valid name, and press Enter. Use Name Manager when you need to review scope, edit a definition, or manage several names.

Why can’t I use spaces in an Excel range name?
Excel defined names cannot contain spaces. Replace them with underscores or join the words, such as MonthlySales. Also check that the name does not begin with a number or resemble a cell reference.

How do I see all named ranges in a workbook?
Press Ctrl+F3 on Windows to open Name Manager. It lists names and their definitions, including scope and the cells or expression each name refers to.

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.