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.

Table of Contents hide

Download Practice Workbook

4 Easy Methods to Copy Hyperlink in Excel

1. Use Mouse Click to Copy Hyperlink in Excel

2. Apply Paste Special Option to Copy Hyperlink in Excel

3. Copy Hyperlink in Excel to Multiple Sheets

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

Conclusion

Download Practice Workbook

You can download the practice workbook from here.

Copy Hyperlink.xlsm

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.

STEPS:

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.

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.

STEPS:

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.

Similar Readings

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.

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

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

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.

STEPS:

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.

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.

4 Comments

James Richmond Oct 11, 2022 at 12:04 AM

I have a spreadsheet “A” with a number of hyperlinks linked to cells in sheet “A”.
I would like to copy Sheet “A” with said hyperlinks into a blank Sheet “B” and have the hyperlinks that were copied into Sheet “B: be active to cells in Sheet “B”.

Is this possible? If so, How??

Thanks in advance.
- Reply
  Sabrina Ayon Oct 12, 2022 at 12:56 PM
  
  Hello, JAMES RICHMOND!
  Thanks for sharing your problem with us!
  Please follow the method below. You will find your solution there.
  
  https://www.exceldemy.com/copy-hyperlink-in-excel/#3_Copy_Hyperlink_in_Excel_to_Multiple_Sheets
  
  Good Luck!
  
  Regards,
  Sabrina Ayon,
  Author, ExcelDemy.
Greg Erkins Feb 25, 2023 at 3:29 AM

Maybe it is the limitations of Excel, but there should be a remarkably simple function to separate a friendly name from a hyperlink and copy the hyperlink into an adjoining cell.
For instance, The Name “Microsoft” is in Cell A1 with the underlying Hyperlink. https://www.microsoft.com/en-us/
I may want to copy https://www.microsoft.com/en-us/ into Cell B1 for US and https://www.microsoft.com/en-ca/ for CA in C1 and https://www.microsoft.com/en-gb for UK in D1.
Also, I would want to have those for different departments in Row while keeping the different countries in columns. I cannot find a straightforward way to do this, which would be as simple as PASTE Function with (Friendly_Name, URL). Just a thought.
- Reply
  Mohammad Shah Miran Feb 27, 2023 at 4:20 PM
  Thank you, Greg Erkins, for believing in ExcelDemy.
  Use the following Macro Code to get your desired output.
```
 Function UrlConstructor(FName, Rng)
FName = "http://www." & FName & ".com/"
Dim Arr() As Variant
ReDim Arr(Rng.Rows.Count - 1)
For i = 1 To Rng.Rows.Count
    Arr(i - 1) = FName & Rng.Cells(i)
Next i
UrlConstructor = Arr
End Function
```
  To aim the output, I have written the function name UrlConstructor and called friendly name and range of country code as an argument, like the picture given below.
  
  Download the Excel file for your better assistance (URL Construction from Friendly Name.xlsm). Also, let us know if you wish to learn more or have any concerns relevant to it. Good luck!

How to Copy Hyperlink in Excel (4 Easy Methods)

Download Practice Workbook

4 Easy Methods to Copy Hyperlink in Excel

1. Use Mouse Click to Copy Hyperlink in Excel

2. Apply Paste Special Option to Copy Hyperlink in Excel

3. Copy Hyperlink in Excel to Multiple Sheets

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

Conclusion

Related Articles

Mukesh Dipto

How to Find a Named Range in Excel (4 Easy Ways)

[Fixed!] Excel MATCH Function Not Working

How to Create a Weighted Sales Pipeline in Excel

[Fixed] Excel Failed to Launch in Safe Mode (4 Easy Solutions)

Leave a reply Cancel reply