How to Convert All Links You Can’t Click on to Links You Can Click on in Google Sheets

How to Convert All Links You Can’t Click on to Links You Can Click on in Google Sheets

When you copy a table that contains links, it often happens that the links are copied as plain text. This is a problem because you can’t simply click on a link to open it, you have to copy the text to a URL field, which takes a lot more time than one click.

It is easy to turn such links into clickable links, but the process is not immediately obvious. Watch our video where we show you how to convert all links you can’t click on to links you can click on in Google Sheets using Windows 10 and Google Chrome.

Video transcript:

  1. How to Convert All Links You Can’t Click on to Links You Can Click on in Google Sheets
  2. When we copy links to Google Sheets table, the links may be copied as plain text. We’ll show you an easy way to turn them into real links.
  3. Click on Edit
  4. Click on Find and replace
  5. In the Find field, type http
  6. In the Replace with field, type http
  7. Click on Replace all and then on Done

Rate:

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Share: Share to Facebook to Facebook Share to LinkedIn to LinkedIn Share to Twitter to Twitter

Send: Send to Viber to Viber Send to WhatsApp to WhatsApp Send to Telegram to Telegram Send to Facebook Messenger to Messenger Send to Email to Email

If you enjoyed this article, you might also like...

Leave a Reply

Your email address will not be published. Required fields are marked *