If you are working regularly with MS excel related task along with web scraping, mail merges related work; you might find this article useful. Because we will discuss How to Insert Hyperlink in Excel Cell in this guide.
How to Insert Hyperlinks in MS Excel
MS Excel comes with the lot of feature for your office work & personal management work. You can also interlink two excel sheet together, that help you to jump to another sheet when you click specified cell.
This is a similar function, but this time, you don’t need to link to another cell. If you have an anchor text and link together and you want all anchor text should have specified link, you can merge both cells together using following formula.
You can also insert hyperlink text for email and web address. The Excel Sheet also allow you to edit and delete hyperlinks after inserting them. In this article, we will show you how to insert or add hyperlinks in Excel sheet.
Method 1: Using Hyperlink Formula
Using Hyperlink formula, you can add hyperlinks to your text in MS Excel easily. Refer below image for more details.
Follow these steps to add hyperlinks by using formula
Step 1: Open MS Excel on your Window Computer
Step 2: Select a cell or row where you want to add a hyperlink
Step 3: Now Choose Cell “C7” for result
Step 4: Type formula : =HYPERLINK(B7)
Step 5: Now press the Enter key to see generated hyperlink
If your want to create the hyperlink for any web address like www.google.com or if your type a valid web address in Excel cell, then Excel can automatically detect and create a hyperlink. To create hyperlink automatically in excel sheet, you need to type a valid web address then press “Enter” key to see your generated hyperlink in Excel.
Now follow these steps:
Step 1: Open Excel Sheet on your PC or laptop
Step 2: Now choose Cell where you want to create hyperlink
Step 3: After this, Only type a valid Web address like, (“www.google.co.in”).
Step 4: After typing a valid web address, hit the “Enter” key to see your result
Method 2: Insert hyperlink text in Excel
You can also add URLs as hyperlinks in MS Excel from text files. To add hyperlinks using the text file. Open Excel sheet on your computer, then choose “Insert” option on the top bar of excel. In the Insert section, select “Hyperlink” option. Now follow these steps:
First of all, copy all Web address from Excel and create a .txt file on desktop
Paste all Web address in text file and save it
Step 1: Open Excel on your PC or Laptop
Step 2: Now choose Column where you want to add hyperlink from text file
Step 3: Now click on “Insert” button on the top bar of Excel screen, then select “Hyperlink” option
Step 4: In the popup window, click on “Existing file or Web page” option
Step 5: Then find and select your text file from your computer
Step 6: After selecting option, press OK button to complete this action
Method 3: Add email as a hyperlink
In this process, we will show you how to add email as a hyperlink in Excel sheet. This is very simple and easy. Only you need to type an email address in a cell then press the enter key to complete the action. Now follow these steps:
Step 1: Open Excel sheet on your computer.
Step 2: Choose Cell or columns where you want to add email as a hyperlink
Step 3: In the Cell, You have to type valid email address then hit the “Enter” key
Now you can see your typed email address as a hyperlink
If your want to add any email address as a hyperlink to text in Excel sheet. Follow these steps.
Step 1: Open Excel Sheet on your computer
Step 2: Now Copy All email address from Excel and create a .txt file on desktop
Step 3: Paste all email in text file and save it
Step 4: In the Excel sheet, choose Insert button on the top bar of Excel screen
Step 5: In the Insert section, select “Hyperlink” option
Step 6: in the popup window, choose “Existing file or Web page” option
Step 7: Then find and select your text file from your computer
After selecting, press OK button to complete this action.
We hope you have enjoyed this tutorial. Do let us know if you want us to create any tutorial for you, feel free to let us know in the comment section below. Please check below video for a complete video guide on this.
We will create a video tutorial for you for your requested problem. Subscribe to our YouTube channel for more such how to guides.