Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, 2021, 2024, and Excel in Microsoft 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: References to Hyperlinks aren't Hyperlinks.
Written by Allen Wyatt (last updated April 25, 2026)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, 2021, 2024, and Excel in Microsoft 365
If you have a hyperlink in a cell (such as cell A1) and then you use a formula in another cell that references that hyperlink, the result of that formula is not a hyperlink. For instance, suppose cell B1 contains this simple formula:
=A1
The result of that formula will not be a hyperlink, even if cell A1 contains a hyperlink. The reason is that the formula extracts the value of the referenced cell, which is the text displayed in A1. If what is displayed in cell A1 is a URL, then you could modify your formula just a bit to result in a hyperlink:
=HYPERLINK(A1)
If cell A1 does not contain a URL, or if it is a hyperlink where the displayed text is different than the underlying URL, then the HYPERLINK function won't work as expected.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (9603) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, 2021, 2024, and Excel in Microsoft 365. You can find a version of this tip for the older menu interface of Excel here: References to Hyperlinks aren't Hyperlinks.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel Data Analysis and Business Modeling today!
Combining workbooks that have cross-links to each other can offer some special challenges. This tip examines how you can ...
Discover MoreTired of having Excel convert what you type into active hyperlinks? Here are things you can do to undo Excel's ...
Discover MoreNeed to change the various targets of a group of hyperlinks? Getting at the underlying link can seem challenging, but it ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2026-04-26 11:20:46
J. Woolley
Re. this formula in cell B1
=HYPERLINK(A1)
The Tip says, "If cell A1 does not contain a URL, or if it is a hyperlink where the displayed text is different than the underlying URL, then the HYPERLINK function won't work as expected."
Here's an alternate formula for cell B1:
=HYPERLINK("#A1", A1)
Now you can click cell B1 to activate cell A1, then you can cliick cell A1 to activate its hyperlink.
If cell A1 is on Sheet1 and B1 is on a different sheet, use this formula:
=HYPERLINK("#'Sheet1'!A1", 'Sheet1'!A1)
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2026 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, 2021, 2024, and Excel in Microsoft 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here:
Comments