5 Handy Ways to Convert Text to Hyperlink in Excel

HYPERLINK function generates shortcuts that can open documents on network server, intranet, or Internet or move to another position in the currently open workbook. After clicking a cell containing HYPERLINK function, basically Excel steers to the particular location or, in specific cases, opens that document. Therefore, this article will show how to add this hyperlink to text in a dataset. In brief, we will demonstrate 5 easy methods to convert a text to a hyperlink in Excel.


📁 Download Excel File

Download the Excel file used for the demonstration from the link below.


Learn to Convert Text to Hyperlink in Excel with These 5 Handy Methods

Firstly, let us get acquainted with our dataset used throughout the article as an example. We have the name of some websites in text form, and we want the texts to convert into hyperlinks. Therefore, we will use this dataset to illustrate 5 straightforward methods of converting text to hyperlinks.

Dataset to convert text to hyperlink in excel


Method 1

1. Using HYPERLINK function

This first method will demonstrate the HYPERLINK function for converting text to a hyperlink. The HYPERLINK function generates a shortcut that opens a document on a network server, an intranet, or the Internet or moves to another position in the current workbook. Now, let us see the steps.

⬇️⬇️ STEPS ⬇️⬇️

  • First, select cell C6 and enter the formula.

=HYPERLINK(B6)

HYPERLINK function to convert text to hyperlink in excel

  • Now, drag or double-click the Fill Handle, and the texts will be converted to hyperlinks.


Method 2

2. Applying Hyperlinks Automatically

This method will demonstrate how to apply hyperlinks so that text takes hyperlinks automatically. Now, let us go through the steps.

⬇️⬇️ STEPS ⬇️⬇️

  • First, select the File tab from the Ribbon.

  • Then, select Options.

  • After that, Excel Options named window will appear. Click on Autocorrect Options after going to the Proofing option.

Excel options to convert text to hyperlink in excel

  • Next, go to AutoFormat As You Type and click on the option Replace as you type in the Autocorrect named dialog box and click OK.

Autocorrect to convert text to hyperlink in excel

  • Now, select cell B6 and manually type what you as a hyperlink. We are typing “excelden.com”.

  • Lastly, type all the texts, which will turn into hyperlinks automatically.

Automatically adding hyperlink to convert text in excel


Method 3

3. Manually Adding Hyperlink to Web Pages

Now, we will show how to add hyperlinks to texts using Ribbon. Let us see steps.

⬇️⬇️ STEPS ⬇️⬇️

  • Initially, select cell C6, click on Insert tab in the Ribbon, and click on Link.

  • After that, Insert Hyperlink named box will pop up. Select Existing File or Web Page from Link To group, type “https://www.excelden.com/” in Text to Display, and in Address, select Current Folder to look in and click OK.

  • Next, select cell C6, drag or double-click on Fill handle, and select the Flash Fill option from AutoFill. Finally, we will have the texts converted into hyperlinks.

Using ribbon to convert text to hyperlink in excel


Method 4

4. Creating Hyperlink to Cells of Worksheet

In this following method, we will show how to add hyperlinks to the same worksheet. Now, let us go through the steps.

⬇️⬇️ STEPS ⬇️⬇️

  • First, select cell C6, go to the Insert tab in Ribbon and select Link.

  • Then, select Place in this Document from Link to options, type B6 in Type the cell reference, or select “In the Same Worksheet” and press OK in the Insert Hyperlink.

  • Now, select cell C6, drag Fill handle, and select Flash Fill from the AutoFill options, and we will have our outcome.

In the same worksheet convert text to hyperlink in excel

📕 Read More: How to Fix Automatic Update of Links Has Been Disabled in Excel


Method 5

5. Embedding VBA

This method will demonstrate converting text to hyperlinks using Microsoft Visual Basic Application (VBA). Also, make sure you have the Developer tab in the ribbon before you start applying this code. If you do not have the Developer tab, click here to see how to enable the Developer tab on your ribbon.

Now, let us go through the steps.

⬇️⬇️ STEPS ⬇️⬇️

  • At first, select Visual Basic from the code group in Developer tab.

  • Then, Microsoft Visual Basic for Application named box will appear. Go to Insert tab and select the Module.

  • Next, enter the code and press F5.
Sub Convert_Text_to_Hyperlink()

For Each a In Range("B6:B9")
ActiveSheet.Hyperlinks.Add Anchor:=a, Address:="https://" & a.Value
Next a

End Sub
  • To run this code, press Alt+F8, select Convert_Text_to_Hyperlink, and then Run.

  • Lastly, we will have the output.

Embedding VBA to convert text to hyperlink in excel


📄 Important Notes

🖊️  To apply VBA codes, ensure you have the Developer tab in the ribbon before the application.

🖊️  To select a cell containing a hyperlink, click the cell and hold down the mouse button until the pointer changes to an Excel selection cursor, then release the button.


📝 Takeaways from This Article

📌 This article demonstrated five ways to convert text to a hyperlink in Excel.

📌 In the first method, we showed the HYPERLINK function to convert text to a hyperlink in Excel.

📌 Then, we demonstrated how to add hyperlinks automatically in Excel.

📌 Next, we will show how to add hyperlinks to texts by utilizing Ribbon in Excel.

📌 After that, we will show how to add hyperlinks in the same worksheet in Excel

📌  Lastly, we showed how to embed VBA code to convert text to a hyperlink in Excel.


Conclusion

This article has demonstrated five ways to convert a text to a hyperlink in excel. All these methods are incredibly effective and simple to use. We hope this article helps you. Please leave a remark if you have any queries. The author will do their best to find an appropriate answer.

For more guides like this, visit Excelden.com.


Related Articles

(Visited 95 times, 1 visits today)
Priti

Priti

Hello! Welcome to my Profile. I am Priti. I'm now working and researching Microsoft Excel, and I'll share articles on it here. I am passionate about problem-solving, and I hope these articles will help you. Please leave a remark if you have any queries, and I will do my best to find an appropriate answer.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo