Excel Guides

References to Hyperlinks aren't Hyperlinks in Excel

If you're working with data in Excel, you may have noticed that references to hyperlinks aren't hyperlinks. This can be frustrating, especially if you're trying to create a report or presentation that includes live links. Here's a look at why this happens and how you can work around it.

When you enter a URL into a cell in Excel, the cell will automatically format as a hyperlink. However, if you then reference that cell in another cell, the reference will not be formatted as a hyperlink. For example, if you enter "www.google.com" into cell A1 and then reference that cell in cell A2, the reference will just show up as plain text.

There are a few ways to work around this. One is to use the HYPERLINK function. For example, if you enter "www.google.com" into cell A1 and then use the HYPERLINK function in cell A2 to reference cell A1, the reference will be formatted as a hyperlink. Another way is to use an HTML anchor tag. For example, if you enter "www.google.com" into cell A1, the reference will be formatted as a hyperlink.

If you're working with data that includes URLs, it's important to be aware of this quirk in Excel. Otherwise, you may end up with links that don't work the way you expect them to.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.