Sometimes we need to copy and paste link in Google Sheets. We can use different commands and functions like the HYPERLINK function to copy and paste link in Google Sheets. In this article, I’ll discuss 6 fast methods for doing so.
A Sample of Practice Spreadsheet
You can download Google Sheets from here and practice very quickly.
6 Easy Methods to Copy and Paste Links in Google Sheets
Let’s get introduced to our dataset first. Here we have a few company’s names in Column B and their corresponding website links in Column C. We have to copy and paste these links into another column. So we’ll see 6 easy methods to copy and paste links in Google Sheets.
1. Applying Copy and Paste Command
We can simply copy and paste link in Google Sheets by using the Copy And Paste Command. This command directly put the links into new cells without any change.
- Firstly, copy the cells from Cell C5 to C10 by pressing Ctrl+C together.
- Then simply paste it into Cell D5 by pressing Ctrl+V together.
2. Using Right Click on Mouse
Now we have a different scenario. We want to copy the link but also want to put it into some texts. We can do this by using Right Click on the mouse. Here are the steps for doing so.
- Next, select Cell D5 and Right-Click on the mouse.
- After that, select Insert link.
- Then, type any text into the Text Menu. Here we type Google.
- Next, paste the copied link in the link box as shown in the picture and click on the Apply Button.
- In the end, you can repeat the process and get results like this in the picture.
3. Applying Insert Menu
We can also repeat the previous process by applying the Insert Menu option. This process is also pretty straightforward.
- Before all, copy the link as shown in the first step of Method 2.
- Afterward, select Cell D5 and go to Insert > Link.
- Finally, follow steps 4, 5, and 6 from Method 2 to get the output.
- How to Copy and Paste Formatting in Google Sheets (5 Ways)
- Copy Horizontal and Paste Vertical in Google Sheets
- How to Copy and Paste Conditional Formatting in Google Sheets
- Copy and Paste Image in Google Sheets (5 Simple Ways)
4. Assigning Toolbar Option
Moreover, we can use the Link Button from Toolbar easily to copy and paste link in Google Sheets. This process is also very simple.
- In the beginning, copy the link like the first step of Method 2.
- Secondly, select Cell D5 and click on the Link Button on the Toolbar.
- In the end, do steps 4, 5, and 6 from Method 2 to get the result.
5. Applying Keyboard Shortcut
We can simply use the keyboard shortcut Ctrl+K together to get the output quickly. The difference between this method from the previous ones is that it takes a few seconds to perform.
- Foremost, copy the link as the first step of Method 2.
- Then, select Cell D5 and press Ctrl+K together.
- Next, give the text name, paste the link and click Apply. Here we give the text name Google.
- At last, apply the processes from steps 6 and 7 of the Method 2 to get the link copied and pasted.
6. Inserting HYPERLINK Function
At present we want to join the company name in Column B with the website link in Column C. we’ll use the HYPERLINK function to do that. This function connects the texts and links together and shows them as text. So it’s not a direct way but seems to copy and paste.
- First, select Cell D5 and type the following formula-
- Hit Enter to get the result.
- Then apply the Fill Handle tool to apply the formula in all columns.
- Finally, you’ll get the result quickly.
That’s all for now. Thank you for reading this article. In this article, I have tried to discuss 6 superfast methods to copy and paste link in Google Sheets. Please comment in the comment section if you have any queries about this article. You will also find different articles related to google sheets on our officewheel.com. Visit the site and explore more.