How to Convert Text to Hyperlink in Excel (5 Methods)

In this tutorial, we will demonstrate to you how to convert text to hyperlink in Excel. Hyperlinks in excel are used to link between websites. Also in this tutorial, we will cover how we can insert a hyperlink to go to another cell. Throughout this tutorial, we will go over different methods to convert text to hyperlink in excel.


Download Practice Workbook

You can download the practice workbook from here.


5 Quick Methods to Convert Text to Hyperlink in Excel

In this article, we will learn 5 convenient methods to convert text to hyperlink in excel. To illustrate these methods we will use a dataset of website URLs of 5 companies.


1. Activate Automatic Hyperlinks Option to Convert Text to Hyperlink in Excel

In Excel, if we insert any link it automatically turns into a hyperlink. This function works only when the option of automatic conversion of hyperlinks is activated. In the following dataset, we can see the URLs of 5 companies. Here, if we input the URLs manually, we will see the URLs don’t convert into links. It’s happening because the automatic hyperlink option is not activated. Let’s take a look at the steps of performing this action.

Activate Automatic Hyperlinks Option to Convert Text to Hyperlink in Excel

STEPS:

  • Firstly, go to the File tab.

Activate Automatic Hyperlinks Option to Convert Text to Hyperlink in Excel

  • Secondly, select Options.

Activate Automatic Hyperlinks Option to Convert Text to Hyperlink in Excel

  • A new dialogue box for “Excel Option” will appear.
  • Thirdly, go to the Proofing section and select the option “AutoCorrect Options”.

  • Now, one more new dialogue box named AutoCorrect will appear.
  • Fourthly, select the option “AutoFormat As You Type”. Then, check the option “Internet and network paths with hyperlinks”.
  • Click on OK.

  • After that, if we input our first URL manually in cell C5 and press Enter, it will automatically convert into a hyperlink.

Activate Automatic Hyperlinks Option to Convert Text to Hyperlink in Excel

  • Lastly, we will input all the URLs manually in column C. So we will get the hyperlinks in column C for all the URLs of column B.

Read More: How to Update Hyperlink in Excel Automatically (2 Ways)


2. Convert Text of a Cell into Clickable Hyperlink Using Excel Ribbon

In this example, we will convert a text word to a clickable hyperlink. We will do this by linking a text with a specific URL. In the following dataset, we have names of companies and their website URLs. We will convert the names of companies into clickable hyperlinks. So, we will be able to access their website only by clicking on the company name. Let’s see the steps regarding this method.

Convert Text of a Cell into Clickable Hyperlink Using Excel Ribbon

STEPS:

  • First, select cell B5.

Convert Text of a Cell into Clickable Hyperlink Using Excel Ribbon

  • Next, go to the Insert tab from the ribbon and select the option Link.

  • A new dialogue box will appear.
  • Then, select the option “Existing File or Web Page”. Insert the link to that company in the “Address”.
  • Now, click on OK.

  • So, we get a clickable link in the company name “Exceldemy”. If we click on the company name it will take us to their website.

Convert Text of a Cell into Clickable Hyperlink Using Excel Ribbon

  • Finally, like the previous one, we can convert all the company names into clickable links.

Convert Text of a Cell into Clickable Hyperlink Using Excel Ribbon

Read More: Excel Hyperlink with Shortcut Key (3 Uses)


3. Apply the HYPERLINK Function to Convert Text to Hyperlink

One more convenient and first process to convert text to hyperlink in excel is the use of the HYPERLINK function. Here, we have the following dataset of URLs of 5 companies in column B. We will create hyperlinks for these URLs in column C. Let’s see the following steps to how this function helps us to convert text to hyperlink.

Apply the HYPERLINK Function to Convert Text to Hyperlink

STEPS:

  • In the beginning, select cell C5 and insert the following formula:
=HYPERLINK(B5)
  • Next, press Enter.

Apply the HYPERLINK Function to Convert Text to Hyperlink

  • So, it creates a hyperlink for the URL in cell B5.

  • After that, drag the Fill Handle tool to the end of the data range.

  • Finally, in column C we get hyperlinks for all the URLs in column B.

Apply the HYPERLINK Function to Convert Text to Hyperlink

Read More: How to Use CELL Function in Excel (5 Easy Examples)


Similar Readings


4. Use VBA Code to Convert Text to Hyperlink in Excel

The use of VBA (Visual Basic for Applications) code is another effective method to convert text to hyperlink in excel. We can easily convert a range of URLs into hyperlinks by using VBA code. In this following dataset, we will convert the URLs of companies into hyperlinks with the use of VBA code. To apply VBA code to convert text to hyperlink in excel just follow the below steps.

Use VBA Code to Convert Text to Hyperlink in Excel

STEPS:

  • Firstly, go to the Developer tab and select the “Visual Basic” option from the ribbon.

Use VBA Code to Convert Text to Hyperlink in Excel

  • This will open the visual basic window.
  • Secondly, go to the Insert From the drop-down select the option Module.

  • A new blank VBA MODULE will appear.
  • Thirdly, insert the following code in that module:
Sub Convert_Hyperlink()
For Each x In Selection
ActiveSheet.Hyperlinks.Add Anchor:=x, Address:=x.Formula
Next x
End Sub
  • Now, click on the Run or press the F5 key to run the code.

Use VBA Code to Convert Text to Hyperlink in Excel

  • Lastly, we can see all the URLs of column C are now converted into hyperlinks.

Use VBA Code to Convert Text to Hyperlink in Excel

Read More: VBA to Add Hyperlink to Cell Value in Excel (4 Criteria)


5. Convert Text to Hyperlink to Link in Same Worksheet

This method is slightly different from the above ones. In this example, we will link one cell with another cell in the same worksheet whereas in the previous examples we linked a URL with a text value in a particular cell. In the following dataset, we will link between cells of column B and column C. For example, we will link cell C5 with cell B5. So, if we click on the hyperlink of cell C5 it will take us to cell B5. Let’s see the steps to implement this method.

Convert Text to Hyperlink to Link in Same Worksheet

STEPS:

  • First, select cell C5.
  • Next, go to the Insert tab and select the option Link.

Convert Text to Hyperlink to Link in Same Worksheet

  • A new dialogue box named “Insert Hyperlink” will appear.
  • Then from the “Link to” section select the option “Place in this Document”.
  • Input the value B5 in the section named “Type the cell reference”. The links the cell C5 with cell B5.
  • Select the option “Same Worksheet” to identify the place of this document.
  • Now, click on OK.

  • So, we can see the company name “Exceldemy” is now converted into a hyperlink.

  • After that, if we click on the hyperlink of cell C5, it will take us to cell B5.

Convert Text to Hyperlink to Link in Same Worksheet

  • Finally, if we do the same process for all the cells it will link all the cells of column C with the corresponding cells in column B.

Convert Text to Hyperlink to Link in Same Worksheet

Read More: Excel VBA: Add Hyperlink to Cell in Another Sheet (2 Examples)


Conclusion

In the end, this article will give you a complete overview of how to convert text to hyperlink in excel. To practice yourself download the practice workbook added with this article. If you feel any confusion just leave a comment in the below box. We will try to answer as soon as possible. Stay tuned with us for more interesting solutions to Microsoft Excel problems.


Related Articles

Mukesh Dipto

Mukesh Dipto

Hi there! I am Mukesh Dipto. I graduated with a bachelor's degree in engineering. Currently, I am working as a technical content writer in ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include sports and meeting new people. I also enjoy sports. My favorite sports are football (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo