In Excel for Microsoft 365 on Windows, select a named range by clicking the Name Box to the left of the formula bar, choosing the range’s name from its drop-down list, and pressing Enter. You can also press F5 or Ctrl+G, enter the name in the Go To dialog, and select Go To.
What selecting a named range does
A named range is a name assigned to a cell, a group of cells, or—in some cases—a formula or constant. Selecting a name that refers to cells moves the active selection to those cells. For example, if a workbook has a name called QuarterSales that refers to the sales cells for a quarter, choosing QuarterSales takes you to those cells without requiring you to remember their address.
Selection is different from creating, editing, or using a name in a formula. It simply navigates to the range and makes it active. You can then inspect its contents, copy it, format it, or use it in another operation. If the name refers to more than one separate area, Excel can select those areas together; the active cell is still only one cell within the selection.
Method 1: Use the Name Box
The Name Box is the small box at the left end of the formula bar. It normally displays the address of the active cell, such as A1. It is also a quick navigation control for named ranges.
- Click the Name Box’s drop-down arrow.
- Look through the listed names and click the one you want.
- Press Enter if needed. Excel moves to and selects the range.
You can also click directly inside the Name Box, type a name, and press Enter. This is convenient when the list is long or when you already know the name. If you type a name that Excel does not recognize, it may treat the entry as a cell reference or report that the reference is invalid, so check the spelling and the name’s scope.
The Name Box list is useful for quick navigation, but it is not a complete explanation of what each name means. A name may refer to a large area, a single cell, multiple areas, or something that is not a cell range. To check the definition before jumping, use Name Manager.
Method 2: Use Go To
Go To offers another direct route, particularly if you prefer a keyboard shortcut or want to see a list of defined names in a dialog.
- Press
F5orCtrl+Gon Windows to open Go To. - Choose a name from the list, or type its name in the Reference box.
- Select OK or press Enter.
Go To can also navigate to an ordinary cell address or a typed range address, so it is useful even when you do not know whether a workbook has named ranges. If the name refers to cells, Excel selects those cells. If the reference contains several areas, the selection can be noncontiguous rather than one solid rectangle.
On a Mac, use Control+G to open Go To. The function-key behavior can depend on your keyboard settings, so Control+G is a practical alternative to F5. Excel for the web has a Name Box for navigating to cells and named ranges, though the available dialog options and keyboard behavior can differ from the desktop app.
Find out what a name refers to
Before selecting an unfamiliar name, inspect its definition. In desktop Excel for Windows, open Formulas > Name Manager. The manager lists names along with information such as their value, reference, and scope. Select a name to review what it refers to; use Edit only if you intend to change its definition.
A name that looks like a range may instead be a constant or a formula. A constant does not identify worksheet cells, so there is no cell selection for Excel to navigate to. A formula-based name may return a value or calculate a reference, depending on how it was defined. If Go To cannot select it, Name Manager can help establish whether the name actually points to cells.
Also check whether the name refers to an external workbook or a sheet that is hidden. An external reference may depend on another file being available. A hidden sheet may complicate navigation, and a protected workbook or sheet can restrict what you are allowed to select or change. These are workbook conditions, not evidence that the name itself is misspelled.
Understand workbook scope and sheet scope
Excel names can have workbook scope or worksheet scope. A workbook-scoped name is available throughout the workbook. A worksheet-scoped name is associated with a particular sheet. This distinction matters when two names have the same spelling: a sheet-scoped name can coexist with a workbook-scoped name, and the applicable one can depend on the sheet from which you are working.
If the name seems to select the wrong cells, open Name Manager and check its Scope column. Confirm that you are on the intended worksheet and that the name’s definition points to the expected cells. For a sheet-scoped name, selecting it while its sheet is active is often the clearest approach. Avoid assuming that the first matching name in a list is necessarily the one you meant.
- Workbook scope: intended to be available from different worksheets in the workbook.
- Worksheet scope: tied to one worksheet, so another name with the same text may have a different meaning elsewhere.
- Duplicate-looking entries: inspect scope and the reference in Name Manager before editing or deleting anything.
Select a named range for a specific task
Once a named range is selected, the selection can be used as the starting point for other work. For example, select a name before applying a fill color, copying the data, or checking the values in the formula bar. If you intend to edit only part of a named range, first confirm that the selected cells are the intended ones; a name could cover many rows or include cells beyond the visible portion of the sheet.
Names can also appear in formula entry and other Excel features. That does not mean you have to select the range first to use the name in a formula. Selection is primarily a navigation action. If your goal is to reference named cells in a calculation, enter the name in the formula where appropriate instead of moving the selection just to locate the cells.
For example, a name such as InputCells might refer to a set of cells users fill in. Selecting it helps you review or format those inputs. If the name is defined as a multi-area reference, actions that require one continuous block may not work as expected. In that case, inspect the definition and work with each area separately if the operation requires a contiguous selection.
Common problems and fixes
- The name is missing from the list: Check Name Manager for spelling and scope. A worksheet-scoped name may not be relevant on the active sheet, and an entry may not be a range at all.
- Excel selects unexpected cells: Review the name’s reference in Name Manager. The definition may include extra rows, point to another sheet, or have changed since you last used it.
- The name does not navigate anywhere: It may represent a constant or a formula that does not resolve to a cell reference. Confirm the definition rather than repeatedly trying the same navigation command.
- Only part of the range is visible: The selected range may extend beyond the current window or include hidden rows or columns. Check the selected cell addresses and the worksheet’s hidden content.
- You cannot change the selected cells: The sheet may be protected, or the workbook may restrict editing. Selecting a range does not remove protection or grant permission to modify it.
Names also follow Excel’s naming rules. For example, a name cannot contain spaces, and a name cannot be confused with a valid cell reference. If a name was entered incorrectly when it was created, it may be hard to find by guessing. Name Manager provides a more reliable way to inspect the exact spelling and definition.
Name Box, Go To, or Name Manager?
Choose the Name Box when you want the fastest route to a known name or want to browse names while staying on the worksheet. Choose Go To when you prefer a keyboard-driven method or want to enter a name in a navigation dialog. Use Name Manager when you need to verify what a name means, distinguish names with different scopes, or correct a definition.
These tools do different jobs, so they are complementary rather than interchangeable. The Name Box and Go To are designed for navigation. Name Manager is for reviewing and managing definitions. If a name is unfamiliar, a good sequence is to check it in Name Manager first, then select it through Go To or the Name Box.
Frequently Asked Questions
What is the keyboard shortcut to select a named range in Excel?
Press F5 or Ctrl+G on Windows to open Go To, enter or choose the name, and press Enter. On Mac, Control+G opens Go To; function-key behavior can depend on keyboard settings.
Where do I find the Name Box in Excel?
It is to the left of the formula bar, above the worksheet grid. It usually shows the active cell address. Click its drop-down arrow to browse names or type a name there and press Enter.
Why can’t I see my named range in the Name Box?
Check the name in Formulas > Name Manager. Confirm its spelling and scope, and determine whether it refers to cells rather than a constant or a formula that does not return a cell reference.
Can I select a named range on another worksheet?
Yes, if the name refers to that worksheet and you can access it. Use Go To or the Name Box, and check the name’s scope and reference if Excel selects a different range or cannot navigate to it.
Does selecting a named range change its definition?
No. Selecting a name navigates to the cells it refers to; it does not rename the range or alter its reference. To inspect or edit the definition, use Formulas > Name Manager.
Related
- Excel Print Area: Set It, Clear It, and Print Automatically
- Excel Print Area Button Greyed Out? Causes and Fixes
- Excel Power Query: Extract a Year from Date Columns
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 Set Double Spacing in WordTo double-space text in a Word document, select the text, then choose Home > Line and Paragraph Spacing…
- How to Move Cells in Excel Without Overwriting DataTo move cells in Excel, select the cell or range, press Ctrl+X, select the destination, and press Ctrl+V.…
- Excel Shortcut to Highlight a Cell Yellow in Microsoft 365In Excel for Microsoft 365 on Windows, select the cell or range and press Alt, H, H to…
- Change Date Format in Excel Cells: A Step-by-Step GuideTo change how a date appears in an Excel cell, select the cell or range, press Ctrl+1 on…
- How to Create Email Rules in Outlook 365To create an email rule in Outlook 365, open Settings, go to Mail > Rules, choose Add new…
- How to Insert an Image in Google Sheets: In a CellTo insert an image in Google Sheets, open the sheet in a web browser, select Insert > Image,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.