In this article, we will explain how to copy a hyperlink in excel. While working in excel, it is a very common piece of work to copy a hyperlink. Copy a hyperlink in excel and paste it to another cell creates a link between an excel file and a specific location or website. You need to remember that we want to copy a hyperlink and paste it to another cell or sheet as a link, not as text.
Download Practice Workbook
You can download the practice workbook from here.
We will illustrate 4 easy methods to copy a hyperlink in excel throughout this article. We have created a dataset of hyperlinks of websites for different companies. With the help of this dataset, we will demonstrate the 4 methods to you.
To copy a hyperlink in excel, the use of a mouse click is the easiest and most convenient way. In the following dataset, we will copy the hyperlink of the company “Exceldemy”. After that, we will paste it to cell C12. Let’s take a look at the following steps to perform this action.
- Firstly, select cell C5 and do a right-click.
- Secondly, select the option “Edit Hyperlink” from the menu.
- Thirdly, a new dialogue box will appear. Copy the hyperlink from the Address section of the dialogue box.
- After that, do right-click in cell C12. Select the paste option to paste the copied link in cell C12.
- Lastly, we can see the company “Exceldemy” link in cell C12.
We can also use the Paste Special option to copy a hyperlink in excel. Paste special is used to paste a link or picture without changing its formatting. We will copy the hyperlinks for the first two companies in the following dataset. Then, we will paste the links in cells C11 & C12. Just go through the following steps to do this.
- First, select cells C5 & C6 and do a right-click.
- Next, select the option “Copy”.
- Then, select cells C11 & C12. Go to the “Paste” option from the ribbon and select the option “Paste Special” from the drop-down.
- After that, a new dialogue box will appear. From the box, select the option “Paste Link”.
- Now, click on OK.
- Finally, we get the copied value of hyperlinks of the first two companies in cells C11 & C12.
Suppose you want to copy hyperlinks in excel from a worksheet to multiple sheets at the same time. This method lets us avoid repetitive work and also saves time. To illustrate this method to you, we will use the following dataset. We will copy all the hyperlinks and then paste them into two different worksheets at the same time.
“Sheet-1” is the first sheet where will paste the hyperlinks.
Another sheet where will paste the hyperlinks is “Sheet-2”.
Let’s see how we can do this by following simple steps.
- In the beginning, select cells C5 to C9. Do right-click and select the option “Copy”.
- Then, press the Shift key and select the sheets “Sheet-1” and “Sheet-2”. You have to hold the shift key while you are selecting both sheets.
- After that, in “Sheet-1” select cell C5 and do a right-click.
- Now, select the option Paste.
- So, we can see the hyperlinks are copied in “Sheet-1”.
- Finally, got to “Sheet-2”. We can see the hyperlinks are also copied in “Sheet-2”.
The use of VBA (Visual Basics for Applications) code is another convenient approach to copy a hyperlink in excel. In this method, we will use VBA code to copy the hyperlinks of column C. Then we will paste the copied values to column D. So, just follow the simple steps to implement this method.
- Firstly, from the “Developer” tab on the ribbon select the option “Visual Basic”.
- 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 Copy_Hyperlinks() Dim Hyper_Link As Hyperlink For Each Hyper_Link In ActiveSheet.Hyperlinks Hyper_Link.Range.Offset(0, 1).Value = Hyper_Link.Address Next End Sub
- After that, click on the Run or press the F5 key to run the code.
- Finally, we get all the hyperlinks of column C in column D.
The above article gives you a am overview of how to copy a 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.