To create a clickable link to a named range in Excel for Microsoft 365 on Windows, use the HYPERLINK function with the name as the link location: =HYPERLINK("#SalesTotal","Go to sales total"). Replace SalesTotal with your defined name; clicking the resulting link takes you to the range. You can also create the link through Excel’s Insert Link dialog without writing a formula.
What a link to a named range does
A named range gives a cell or group of cells a descriptive name, such as SalesTotal or QuarterlyData. A hyperlink to that name is a navigation shortcut: it takes the user to the cell or range the name refers to. This is different from using the name in a calculation. For example, a formula can use a name to retrieve or calculate a value, while a hyperlink lets someone click and inspect the underlying cells.
The name must resolve to a cell or range for it to serve as a useful navigation destination. A name can also refer to a formula or constant, but those definitions do not necessarily correspond to a place on a worksheet that Excel can select. If your goal is to jump to visible worksheet data, check that the name refers to cells.
Internal links stay within the current workbook. They are useful in contents pages, dashboards, instructions, and summary sheets where readers need to move quickly to detail. A link does not copy or update the destination data; it simply navigates to it.
Create or check the named range
Before adding a link, confirm that the name exists and points to the intended cells. In Windows Excel, open Formulas > Name Manager to review names, their scope, and their “Refers to” definitions. You can also select a cell or range and inspect the Name Box to the left of the formula bar.
To make a new name for a selected range, click the Name Box, type a valid name, and press Enter. Alternatively, use Formulas > Define Name to enter the name, choose its scope, and set the cell reference. Names cannot contain spaces, and they cannot be written like a cell address such as A1. Use an underscore or period to separate words, for example Quarterly_Sales.
- Select the cells the name should represent before creating a name from the Name Box.
- Use Name Manager to check whether a similar name already exists.
- Confirm the “Refers to” entry points to the intended sheet and cells, not an old location.
- Decide whether the name should be available throughout the workbook or only on one worksheet.
Names can refer to a single cell, a block of cells, or a range whose size changes as data is added. A dynamic named range can be useful for expanding lists, but the link’s destination still depends on how that name is defined. If it refers to multiple cells, Excel generally navigates to the start of the referenced area; the link is not a command to select every cell for editing.
Make a clickable link with HYPERLINK
The HYPERLINK function creates a link in a worksheet cell. The first argument identifies the destination, and the second is the text displayed in the cell. For an internal link to a workbook-level name, place a hash sign before the name in the destination.
With no cell data required for this example, enter the following in the cell where you want the clickable text to appear:
=HYPERLINK("#SalesTotal","Go to sales total")
If SalesTotal is a defined name that refers to cells, the cell displays “Go to sales total.” Clicking it navigates to the named destination. The displayed text can be any clear label; it does not have to match the name. For example, a dashboard might show “Open detailed sales figures” while linking to a name called SalesDetail.
Use the name exactly as it appears in Name Manager. The initial # signals that the destination is within the current workbook. If you rename or delete the defined name later, review the link because its destination may no longer resolve as intended. For a workbook with many links, keep names stable and descriptive so the links are easier to maintain.
HYPERLINK is available in current Excel versions, including Microsoft 365. The formula creates a clickable cell, not a button or a visual hyperlink attached to an entire range. If you want a larger clickable area, a link in a nearby cell or a linked shape may be more appropriate.
Insert a link without writing a formula
The dialog is a good choice when you want to link existing text or a shape and prefer not to use a worksheet formula. In Excel for Microsoft 365 on Windows, select a cell containing the text to link, or select the text while editing the cell. Press Ctrl+K, or choose Insert > Link. In the link dialog, choose Place in This Document, then select the destination under the available sheet or defined-name options. Confirm the selection and choose OK.
If the link text does not exist yet, type it in a cell and select that cell before opening the dialog. Excel makes the selected text or cell clickable. You can also select a shape and use Insert > Link to attach a destination to it; the precise dialog options can depend on the selected object and Excel build.
On Excel for Mac, use Insert > Link or press Command+K to open the link dialog. The dialog’s layout and labels can differ from Windows, so look for the option to link to a place in the current workbook and then choose the named destination. In Excel for the web, use the Insert link command and select a location in the workbook if that option is available in the current interface. Web and desktop dialogs may not present the same choices.
To change or remove an existing link, right-click its cell or object and choose the relevant edit or remove hyperlink command. Removing a hyperlink does not delete the defined name or its cells. Likewise, deleting a name does not remove the data it used to refer to.
Workbook scope and worksheet scope
Excel names have scope. A workbook-level name can generally be used throughout the workbook, while a worksheet-level name is associated with one particular sheet. This distinction matters when two sheets use the same local name. A name that appears unambiguous on one sheet may refer to a different set of cells on another.
For a workbook-level name, the short destination form #SalesTotal is usually the clearest approach. If you need to target a worksheet-level name, use the destination format that identifies its sheet, such as #Sheet1!LocalTotal; for a sheet name containing spaces, the sheet name needs apostrophes, as in #'Sales Data'!LocalTotal. Because name scope and hyperlink-dialog behavior can make ambiguous names confusing, test a local-name link from the sheet where readers will click it. The dialog’s defined-name list may also help you choose the intended destination.
When a workbook has a name at both workbook and worksheet scope, Excel’s name resolution can depend on the context. Avoid creating duplicates unless there is a clear reason. If a link jumps to the wrong sheet, inspect the scope column in Name Manager and consider giving the names distinct identifiers. A unique workbook-level name is often simpler for a link intended to work from multiple sheets.
Linking to a range on a particular sheet
You do not have to create a named range to link to a worksheet location. A direct internal hyperlink can point to a cell address, while a named range provides a readable label that can remain useful if the referenced cells move. Names are especially valuable when the destination is meaningful to readers or when several links must point to the same area.
A name can also refer to a range on another sheet. For example, a workbook-level name such as InventoryTable can refer to a block on an Inventory worksheet, and the hyperlink can use that name from a dashboard. The sheet remains part of the name’s definition even though it is not written in the short HYPERLINK destination. If the range is moved or its definition is changed, inspect the name and test the link afterward.
Think of a named link as navigation rather than a bookmark with a fixed screen position. Excel selects the referenced cell or range, but the final visible view can depend on worksheet layout, zoom, frozen panes, and the current window. If readers need orientation after they arrive, include clear headings and labels near the destination.
Common problems and how to fix them
- The link displays an error or does nothing: Check the spelling of the name, including the
#in the internal destination. Open Name Manager and confirm the name still exists and refers to cells. - The link goes to the wrong sheet: Check whether the name has worksheet scope or whether another name with the same text exists. Make the name unique or specify the intended worksheet-level name.
- The link opens a browser or another file: Make sure the destination begins with
#for a location in the current workbook. Without the internal-location marker, Excel may interpret the text as a different kind of link. - The target appears to be missing: The name may refer to a deleted sheet, deleted cells, a formula, or a constant rather than a visible range. Review the “Refers to” field and correct it.
- The link works on one computer but not another: Internal links are generally more portable than links to files on a local drive, but confirm the workbook opens in the intended Excel version and that its defined names have not been changed.
After changing names or moving data, click important navigation links as part of a workbook review. This is especially worthwhile in shared reports, templates, or workbooks that readers use as a starting point. A link can remain visibly present even when its intended destination has become outdated.
Choosing between a formula, a link dialog, and a direct reference
Choose HYPERLINK when the link text should be generated by a formula, when a dashboard contains many consistent navigation links, or when you want the link’s label to be easy to edit in the formula. Choose the Insert Link dialog when you are linking existing text or a shape and want to select the destination interactively.
A direct cell reference is different: it displays or uses a cell’s value and does not act as a navigation link. A named range can be used in formulas for calculations as well as in hyperlinks for navigation, but those are separate purposes. If readers need to jump to detail, create a hyperlink. If a summary needs to show the value stored in a named cell, use a normal formula reference instead.
For a compact workbook, a few text links may be enough. For a large workbook, consider a contents sheet that groups destinations by task or topic. Use labels that describe where each link goes, not vague text such as “Click here.” That makes the workbook easier to scan and helps readers understand the destination before clicking.
Frequently Asked Questions
Can I hyperlink to a named range in Excel?
Yes. Use HYPERLINK with an internal destination such as #SalesTotal, or open Insert Link and select the named destination under the option for a place in the document. The name should refer to cells if the goal is to navigate to worksheet data.
What formula links to a named range?
With no cell data required, a basic example is =HYPERLINK("#SalesTotal","Go to sales total"). Replace the name and the display text with your own. The hash sign indicates a location in the current workbook.
Can a hyperlink point to a named range on another sheet?
Yes. A workbook-level name can refer to cells on another worksheet, and a link to that name can navigate there. For a worksheet-level name, check its scope and identify the sheet when needed so Excel resolves the intended name.
Does a named-range hyperlink update if I move the cells?
The link points to the name, and the name’s “Refers to” definition determines the destination. Excel may adjust a name’s cell reference when worksheet cells are moved or edited, but verify the definition and click the link after structural changes rather than assuming every change preserves the intended target.
Can I link to a named range in Excel for the web or on Mac?
Excel for Mac has an Insert Link command and uses Command+K rather than Windows Ctrl+K. Excel for the web also provides link tools, though dialog labels and available destination choices can vary. If the name is not offered in the dialog, try the formula method in a supported version and check that the workbook’s name is defined correctly.
Related
- Excel Import CSV and TXT Files: How It Works
- Excel Import CSV Into Template: Steps and Tips
- Excel Import CSV: How to Open and Load Files
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Sort an Excel Column Alphabetically Without Mixing RowsTo sort a column alphabetically in Excel for Microsoft 365 on Windows, click a cell in the column…
- SUMIFS Not Summing Correctly? Excel Causes and FixesSUMIFS usually returns an unexpected total because its ranges do not line up, a criterion does not match…
- Excel MATCH Function: Find a Value’s PositionExcel’s MATCH function finds a value in a range and returns its relative position, not the value itself.…
- Excel Cell Fill Shortcut: Fill Down, Fill Right, and ColorIn Excel for Microsoft 365 on Windows, press Ctrl+D to fill down from the top cell of a…
- IF Function in Excel: Examples and Practical Uses ExplainedThe Excel IF function checks whether a condition is true and returns one result if it is, and…
- Excel Formula for Time Difference: Examples and FixesTo find the time between two values in Excel, subtract the start time from the end time: with…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.