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.
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!
Need to change the various targets of a group of hyperlinks? Getting at the underlying link can seem challenging, but it ...
Discover MoreIf you need to modify the URL used in a large number of hyperlinks, you can do so by using a macro and a little ...
Discover MoreConnect your worksheets with other workbooks or with the world of the Internet. The ability to add hyperlinks makes this ...
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