How to Copy Hyperlink in Excel (4 Easy Methods)

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.


4 Easy Methods to Copy Hyperlink in Excel

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.


1. Use Mouse Click to Copy Hyperlink in Excel

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.

Use Mouse Click to Copy Hyperlink in Excel

STEPS:

  • Firstly, select cell C5 and do a right-click.
  • Secondly, select the option “Edit Hyperlink” from the menu.

Use Mouse Click to Copy Hyperlink in Excel

  • 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.

Use Mouse Click to Copy Hyperlink in Excel


2. Apply Paste Special Option to Copy Hyperlink in Excel

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.

Apply Paste Special Option to Copy Hyperlink in Excel

STEPS:

  • First, select cells C5 & C6 and do a right-click.
  • Next, select the option “Copy”.

Apply Paste Special Option to Copy Hyperlink in Excel

  • 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.

Apply Paste Special Option to Copy Hyperlink in Excel


3. Copy Hyperlink in Excel to Multiple Sheets

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.

Copy Hyperlink in Excel to Multiple Sheets

“Sheet-1” is the first sheet where will paste the hyperlinks.

Copy Hyperlink in Excel to Multiple Sheets

Another sheet where will paste the hyperlinks is “Sheet-2”.

Let’s see how we can do this by following simple steps.

STEPS:

  • In the beginning, select cells C5 to C9. Do right-click and select the option “Copy”.

Copy Hyperlink in Excel to Multiple Sheets

  • 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”.

Copy Hyperlink in Excel to Multiple Sheets

  • Finally, got to “Sheet-2”. We can see the hyperlinks are also copied in “Sheet-2”.

Copy Hyperlink in Excel to Multiple Sheets


4. Use VBA Code to Copy Hyperlink in Excel in Another Cell

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.

Use VBA Code to Copy Hyperlink in Excel in Another Cell

STEPS:

  • Firstly, from the “Developer” tab on the ribbon select the option “Visual Basic”.

Use VBA Code to Copy Hyperlink in Excel in Another Cell

  • 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.

Use VBA Code to Copy Hyperlink in Excel in Another Cell


Conclusion

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.

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