Excel Shortcut to Go to a Named Range

In Excel for Microsoft 365 on Windows, press Ctrl+G or F5 to open the Go To dialog, select or type the named range, and press Enter. Excel jumps to the cells that the name refers to; the same dialog is also useful for moving to a cell address or another worksheet.

How the Go To shortcut works

Ctrl+G and F5 open the same Go To dialog in desktop Excel for Windows. In its Reference box, enter a cell address such as D25, a range such as B2:E12, or a defined name such as QuarterlySales. Press Enter or click OK to move the selection to that target. If the name refers to a multi-cell range, Excel selects the range rather than just its top-left cell.

The dialog can also show a list of available named references. Choose an entry there if you are unsure of the exact spelling, then confirm the selection. This is often more reliable than guessing whether a name contains an underscore or a shortened word. A name must ultimately refer to cells for this navigation to select a range; a defined name that represents a value or formula instead of a cell reference is not a destination range.

Press Ctrl+G or F5.
Select the desired name from the list, or type it in the Reference box.
Press Enter to move the active selection.

What Excel selects when you go to a name

A named range is a readable label attached to a cell or range reference. For example, a workbook might define TaxRate as a name for cell B3, or define SalesData as a name for A2:D100. Going to TaxRate selects B3; going to SalesData selects the full rectangular range. The name is an alias for the reference, not a separate copy of the data.

When you jump to a multi-cell range, the active cell is typically its upper-left cell, while the whole range remains selected. This distinction matters if you start typing: typing a value and pressing Enter replaces the content of the active cell, not every cell in the selected range. To fill an entire selection deliberately, use the appropriate fill or paste action rather than assuming navigation changed all its cells.

Go To changes the active selection, but it does not edit the name or move the underlying cells. If a named range points to a location on a different worksheet, Excel activates that sheet and selects the target. You can then inspect the formula bar, view surrounding data, or use the selection as the starting point for another operation.

Use the Name Box as an alternative

The Name Box is the small field to the left of the formula bar, where Excel normally displays the active cell address, such as A1. Click it, type a defined name, and press Enter to navigate directly. This is convenient when you already know the name and want to skip the Go To dialog. It can also accept ordinary cell references and range addresses.

The Name Box has a drop-down list that can help you locate names in a workbook. Choosing a listed name moves the selection to its reference. It is also where you can create a name quickly: select the target cells, click the Name Box, type a valid name, and press Enter. Take care not to overwrite a name accidentally when the wrong cells are selected.

For example, suppose NorthRegion refers to cells A2:C40. Click the Name Box, type NorthRegion, and press Enter; Excel selects that range. The result is the same navigation outcome as entering the name through Ctrl+G. The Go To dialog is generally clearer when you want to browse a list, while the Name Box is faster for a name you know by heart.

Named ranges, tables, and cell addresses

A named range is not the same thing as an Excel table name, although both provide labels that can be used in formulas. Tables have structured names such as Table1, and their columns can be referenced with structured-reference syntax. A table name by itself is not always handled like a simple cell-range name in every navigation context, so use the table’s range or select the table through the Name Box list if available.

Ordinary addresses work in Go To too. You can enter F8 for a single cell, A1:C20 for a block, or a sheet-qualified reference such as Summary!B4. If the worksheet name contains spaces, put it in single quotation marks, as in 'Annual Summary'!B4. This can be useful when a name is missing, unclear, or refers to a part of a larger area.

Some defined names use formulas, constants, or dynamic references rather than a fixed block. Those names can be useful in calculations, but not every such name represents a range that Excel can select. If a name works in a formula but does not behave like a destination in Go To, inspect what the name refers to rather than assuming the shortcut is broken.

Workbook scope and worksheet scope

Excel names can have workbook scope or worksheet scope. A workbook-scoped name is available throughout the workbook. A worksheet-scoped name belongs to one particular sheet, which allows different sheets to use the same local name for different ranges. Scope therefore affects which name Excel can resolve from the current context.

If you cannot find a name in Go To, first activate the sheet where a sheet-scoped name belongs and open the dialog again. You can inspect names and their scope by choosing Formulas > Name Manager, or press Ctrl+F3 on Windows. In Name Manager, check the name, its scope, and the Refers to field. The latter shows the reference or expression that Excel associates with it.

Duplicate-looking names are a common source of confusion. A workbook-level name and a sheet-level name may share the same text while referring to different cells. If the destination seems wrong, confirm the active worksheet and inspect the scope in Name Manager. Renaming one of the definitions can make the workbook easier to navigate, but change names cautiously because formulas may depend on them.

Common problems and fixes

If Ctrl+G opens a different feature, confirm that Excel has focus and that you are using the desktop application rather than another program. You can also try F5. In Excel, the Go To command is available from Home > Find & Select > Go To, so the ribbon provides a fallback when a keyboard shortcut is unavailable.

The name is not listed: Check its spelling and scope in Formulas > Name Manager, and make sure the correct worksheet is active for a sheet-scoped name.
Excel reports an invalid reference: Inspect the Refers to field. The name may have been deleted, may contain an error, or may refer to something that is not a selectable cell range.
Excel goes to an unexpected place: Look for another name with the same text but a different scope, then verify the name’s reference.
The wrong cells are selected: The name may intentionally cover a larger area than expected. Check the range in Name Manager before editing data.

Names can also become misleading after a workbook is changed. For example, someone may rename a worksheet, delete rows, or repurpose a range while leaving a broad name in place. Excel often adjusts references when cells are inserted or deleted, but that does not guarantee that a name still describes the intended business area. Reviewing the reference is a sensible step before using a name to edit or format data.

Windows, Mac, and Excel for the web

On Windows desktop Excel, Ctrl+G and F5 open Go To. On Excel for Mac, Control+G is the commonly used Go To shortcut, and F5 can also open the dialog; on some Mac keyboards, you may need to hold Fn to use a function key as F5. Keyboard settings and hardware can affect function-key behavior, so the menu route is a dependable alternative: use the Go To command from Excel’s Edit menu or the ribbon, depending on the interface version.

Excel for the web has a Go To command and supports keyboard shortcuts, but browser and operating-system shortcuts can affect which command receives a key combination. If Ctrl+G does not open Excel’s dialog in the browser, use the app’s ribbon command or the Name Box. The web version’s menus and available name-management features can differ from desktop Excel; for detailed inspection or editing of definitions, the desktop Name Manager is the more complete place to check.

Related navigation shortcuts

Go To is one of several ways to move around a workbook. It is especially useful for named areas because you can enter a label rather than remember a distant cell address. Other shortcuts serve different purposes:

Ctrl+Home moves to the beginning of the worksheet, usually cell A1.
Ctrl+End moves to the last used cell in the worksheet, which may be farther down or right than the visible data.
Ctrl+F opens Find for searching cell contents; it does not serve as a substitute for selecting a defined name.
Ctrl+F3 opens Name Manager, where names can be reviewed and managed rather than simply navigated to.

These commands solve different problems. Use Go To when you know a destination or want to browse named references, Find when you need to locate matching text or values, and Name Manager when you need to understand or change a definition. Keeping those purposes separate prevents a common mix-up: Ctrl+F3 is for managing names, while Ctrl+G or F5 is the direct shortcut for going to one.

Frequently Asked Questions

What is the Excel shortcut to go to a named range?
Press Ctrl+G or F5 in Excel for Windows. Choose the name in the Go To list or type it in the Reference box, then press Enter.

Can I type a named range into the Name Box?
Yes. Click the Name Box to the left of the formula bar, enter the defined name, and press Enter. Excel selects the cells that name refers to.

Why is my named range missing from the Go To list?
Check its spelling and scope in Formulas > Name Manager. A worksheet-scoped name may only be available in the context of its own sheet, and a name that refers to a constant or formula may not be a selectable range.

Does Ctrl+F3 go to a named range?
No. In Windows desktop Excel, Ctrl+F3 opens Name Manager. Use Ctrl+G or F5 to navigate to a name; use Name Manager to inspect or edit its definition.

What is the Mac shortcut for Go To?
Control+G opens Go To in Excel for Mac. F5 may also work, but some keyboards require Fn+F5. You can use the menu command if your keyboard settings intercept the shortcut.

Can I use Go To to jump to a named range on another sheet?
Yes, if the name resolves to a cell reference in the workbook. Excel activates the destination sheet and selects the referenced cells. For a sheet-scoped name, check that name’s worksheet scope if it does not resolve as expected.

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.