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.
How to Copy Hyperlink in Excel: 4 Easy Methods
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.
Read More: Excel Hyperlink with Shortcut Key
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.
Read More: How to Edit 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.
“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”.
Read More: How to Activate Multiple Hyperlinks in Excel
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.
Read More: How to Hyperlink to Cell in Excel
Download Practice Workbook
You can download the practice workbook from here.
Conclusion
The above article gives you an 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.
Related Articles
- How to Hyperlink to Cell in Same Sheet in Excel
- Excel Hyperlink to Cell in Another Sheet with VLOOKUP
- How to Combine Text and Hyperlink in Excel Cell
- How to Add Hyperlink to Another Sheet in Excel
- Excel Hyperlink to Another Sheet Based on Cell Value
- How to Create a Drop Down List Hyperlink to Another Sheet in Excel
- How to Create Dynamic Hyperlink in Excel
- How to Convert Text to Hyperlink in Excel
- How to Create Button to Link to Another Sheet in Excel
<< Go Back To Hyperlink in Excel | Linking in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
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.
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.
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.
Thank you, Greg Erkins, for believing in ExcelDemy.
Use the following Macro Code to get your desired output.
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!
Thanks. But a bit weird for me. I copy a URL from chrome, et al. I want to paste it as a working link in excel. I CAN paste it (control c, control v). But it is just text, not clickable.
I can click on the cell, right click, paste special. but it doesn’t offer anything about adding as a link.
I can click on the cell, right click, choose add link. And it will accept the URL and the url text will show, and the link is clickable.
There’s loads of pages doing what you are describing. But I can’t paste special as a link. Operator error?
Hello Mike,
Thank you for sharing your experience with us!
I understand you are getting non-clickable link text when you are copying the URL from web browsers. Also, the Paste Special command is not responding which would solve the issue in your case. Unfortunately, Paste Special command does not offer the Paste Link option while pasting web URLs.
But Excel directly inserts a hyperlink to a copied URL when you:
1. Copy the URL from a web browser >> select the cell where you want to paste >> paste the URL in the Formula Bar.
2. Alternatively, you can directly paste the URL to a cell >> go to Formula Bar >> press Enter.
This will convert the Text link to Hyperlink. You can also use the HYPERLINK function to get clickable URL links(read the article).
How to Use Excel HYPERLINK Function
Regards,
Yousuf Shovon