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.
- 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.
- Press Ctrl+F3. In Name Manager, choose New.
- Enter a name in the Name field. Keep it descriptive, such as
QuarterSalesorTaxRate. - Choose the scope: the whole workbook or a particular worksheet. For a reusable name, workbook scope is often the more convenient choice.
- 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_RegionorNorthRegion. - A name cannot look like a cell address, such as
A1orR1C1. - 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
- How to Add Colour to Data Validation Cells in Excel
- Data Validation in Excel: Rules, Lists, and Setup Tips
- Excel Extract Text From the End of a String in 365
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Calculate VaR 99 in ExcelTo calculate one-day historical VaR at 99% confidence in Excel, use the first percentile of portfolio returns and…
- Conditional Formatting in Outlook: Setup and LimitsConditional formatting in Outlook automatically changes how matching messages look in the message list, such as displaying mail…
- How to Add Chicago Style Footnotes in Microsoft WordTo add a Chicago-style footnote in Word, place the cursor after the passage you are citing, then choose…
- ISERROR in Excel: How It Works and When to Use ItIn Excel, ISERROR checks whether a value or formula result is any Excel error and returns TRUE or…
- How to Add Automatic Page Numbers in Microsoft WordTo add automatic page numbers in Word, open the Insert tab, choose Page Number, select where the numbers…
- Excel Shortcut Keys: Essential Commands for WindowsFor Excel for Microsoft 365 on Windows, the most useful shortcut keys include Ctrl+C and Ctrl+V to copy…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.