How to convert selected text into hyperlinks in Google spreadsheets?


In this article, I will explain how to convert selected text in Google spreadsheets to clickable hyperlinks. You may use the function =HYPERLINK to create hyperlinks in Google spreadsheets.

Google spreadsheets is part of the Google Docs family of tools and is the equivalent of Microsoft Excel. You can create spreadsheets in the cloud and access or edit from any computer or supported device connected to the web. The Google spreadsheets is a very powerful program which allow you to do lot of calculations, store tabular data, embed powerful formulas to automatically calculate certain values with respect to other data in the spreadsheet.
One of the cool things in Google spreadsheets is, if you type any urls (text that start with http://), it will be automatically converted to a clickable hyperlink.

For example, if you type the following text in Google spreadsheets:
http://www.techulator.com

it will be automatically converted to a clickable link like this:

http://www.techulator.com

This is a very handy feature. You do not need to type any complex html to create hyperlinks in Google spreadsheets.

How to make some text clickable link in Google spreadsheets?


The above approach would make any urls a clickable link. But there may be occasions where you want to convert certain pieces of text to a clickable link without showing the link itself. For example, you may want to show something like this:

To learn more about how to use Google Spreadsheets, visit this website.

In the above text, the words "this website" is highlighted and is made to a clickable link that points to http://www.techulator.com.

In order to make some specific text in a cell to a hyperlink, you can use a formulae in Google Spreadsheets, as shown below:

=hyperlink("http://www.techulator.com", "Visit this site")


By using the formulae as shown above, you can make the text in any cell to a hyperlink pointing to the url you want.

One of the shortcomings in current version of Google spreadsheets is, you cannot convert partial text in a cell to hyperlink using the function mentioned above. In order to use the formula or function, you must use it for the entire cell. So, you cannot make few words within a bigger piece of text to hyperlink using the approach mentioned above.

The following example will not work in Google spreadsheets:

To learn more about how to use Google Spreadsheets, visit
=hyperlink("http://www.techulator.com", "this website").


If you type the above text in a Google spreadsheets cell, the formula will be simply displayed as text instead of enabling the hyperlink.

I wish Google will add a menu item or some other option to enable hyperlink for selected text in a cell in Google spreadsheets.

Conclusion on using clickable hyperlinks in Google spreadsheets


I have been using Google Docs and Google spreadsheets for few years now, but converting selected to text to hyperlinks is a new piece of information to me. It is a very useful feature and I have already started using it a lot.


Article by Tony John
Tony John is a professional blogger from India, who started his first Weblog in 1998 at Tripod.com. Tony switched to blogging as a passion blended business in the year 2000 and currently operates several popular web properties including IndiaStudyChannel.com, Techulator.com, dotnetspider.com and many more.

Follow Tony John or read 646 articles authored by Tony John

Related Articles

Top 10 Tips for Google Docs

Google Docs is one of the most popular Word Processing app among the suite of Google Apps. Docs not only replaces the need for the desktop Word processor but it also helps make things easier with online collaboration. In this article we are going to take a look at some of the interesting tips for Google Docs.

Comparison of Office 365 with Google Apps and Google Docs

In this article, I will talk about Microsoft Office 365 and the interesting features it offers. We will compare the features available in Office 365 and Google Apps/Docs. A feature comparison table of Office 365 and Google Apps is given at the end.

Google Drive- A new way to store files

Google Drive is an endeavor to facilitate file storing and managing in ones Google Docs. With the beautiful feature of accessing any file anywhere anytime Google drive is surely the next thing in demand

More articles: Google Docs

Comments

Guest Author: jeff brown25 Feb 2012

In my spreadsheet, I have an entire column that I'd like to convert to hyperlinks. In other words, I enter different addresses in those cells, but would love it if others, when they click on those addresses, if it would take them to a google map of that specific address. Is there anyway to change a shared document so that when anyone puts a new address in this column, that it will make it clickable to the google map for everyone else? Does that make sense?

Thank you!



  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: