Adding an active hyperlink to an Excel spreadsheet

In many Office 2013 applications, pasting a URL into the document or file will automatically make it a clickable link. Excel 2013 is different, in that you have to click back into the cell to make it active.

In the image below, I pasted the URL for SparkOne into cell B2:

excel-hyperlink-20170313-1

When I click into cell B3, the URL isn’t active or clickable. It’s basically just a line of text:

excel-hyperlink-20170313-2

To make it active, I have to go back into cell B2 and double-click that cell. Then when I move away from the cell, the link will be active:

excel-hyperlink-20170313-3

You can make the link be active as soon as you click away if you double-click the cell you’re pasting the link into. If I double-clicked cell B2 and then pasted the link in there, then it would be active as soon as I clicked away from that cell. I wouldn’t have to go back into it again.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s