Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and 2021. 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 July 26, 2023)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and 2021
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, and 2021. You can find a version of this tip for the older menu interface of Excel here: References to Hyperlinks aren't Hyperlinks.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2019 For Dummies today!
Need to create links to many filenames on your system? Here are a couple of quick ways to get just the connection you need.
Discover MoreIf you use UNC paths in your links to external information, those paths may need to be changed at some point. You can ...
Discover MoreNeed to get rid of the links in your workbook but save the values that were retrieved by those links? It could be easy or ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2025-10-11 14:25:22
Bruski
Thank you for the answer to that question! Also, I discovered that it you want to link one cell on a tab to another cell on a different tab cell that contains a hyperlink the formula would look like this =HYPERLINK('NameOfYourOtherTab'!A1)
cheers!
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 © 2025 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and 2021. 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