Tip Details Add a Related Tip

Rate as: Positive Negative

Displaying links in Google spreadsheets

If you type a URL into a cell in a google spreadsheet, it'll show an icon and clicking on the icon will take the user to the URL that is entered. But if you don't want to have the icon shown in the cell, you can format the link so that you can specify the text that is shown. The format is:

=hyperlink("URL","title")

where URL is the link itself and title is the text to be shown in the cell. So an example would be entering this into a cell:

=hyperlink("www.tipstrs.com", "Click here to go to tiptrs")

Using this trick, you can customize your links in google spreadsheets to make them look better.
Rating: 100% positive, 1 Vote
Categories: spreadsheet google
Added: on Jun 11, 2008 at 1:51 pm
Added By: an anonymous user

Comments on this Tip

Add a Comment
There are no comments for this tip
Your Comment:
(how to format)
Rate This Tip:

Verify Humanity:
Sorry, we know it's annoying, but please enter the characters shown in the image to the left so that we know you're an actual person and not an evil spammer. Thanks.
       

Related Tips

Arranging RSS feeds in Google Reader

Categories: google RSS customization
100% positive, 0 comments
– Tip added by an anonymous user on Jun 21, 2008 at 3:28 pm

Undoing iGoogle themes

Categories: google customization
100% positive, 0 comments
– Tip added by an anonymous user on Apr 30, 2008 at 3:33 pm

Adjusting date range on Google Finance charts

100% positive, 0 comments
– Tip added by an anonymous user 2 days, 12 hours ago

Get the Chrome browser on Mac and Linux

100% positive, 0 comments
– Tip added by an anonymous user on Sep 16, 2008 at 11:58 am

Ad trade group opposes Yahoo-Google search deal

Categories: yahoo google Microsoft
100% positive, 0 comments
– Tip added by sunnyspeaks on Sep 08, 2008 at 1:24 am

Getting more search options in the Google Chrome browser

100% positive, 0 comments
– Tip added by an anonymous user on Sep 06, 2008 at 1:33 pm

Add a home button to the Chrome browser

Categories: chrome browsers google
100% positive, 0 comments
– Tip added by an anonymous user on Sep 03, 2008 at 8:28 am

Google Adwords Tip To Lower Your Cost

100% positive, 0 comments
– Tip added by Jensax12 on Jul 26, 2008 at 4:13 am

Google Adwords Tip For Domination

100% positive, 0 comments
– Tip added by NickE83 on Jul 25, 2008 at 6:10 pm

Getting site contents on mobile devices

100% positive, 0 comments
– Tip added by an anonymous user on Jul 25, 2008 at 6:46 am

Deciphering today's Google logo

Categories: google logos fun
100% positive, 0 comments
– Tip added by an anonymous user on May 16, 2008 at 2:11 pm

See real estate prices in Google Maps

Categories: google maps real estate
100% positive, 0 comments
– Tip added by an anonymous user on May 13, 2008 at 5:20 pm

Searching with google chrome

no ratings, 0 comments
– Tip added by an anonymous user on Sep 26, 2008 at 10:03 am

Manage Google Contacts directly

Categories: google address book
no ratings, 0 comments
– Tip added by an anonymous user on Sep 25, 2008 at 1:19 pm

Driving routes on google maps

no ratings, 0 comments
– Tip added by an anonymous user on Sep 22, 2008 at 8:44 pm

Creating applications in Google Chrome

no ratings, 0 comments
– Tip added by an anonymous user on Sep 05, 2008 at 1:23 pm

Reopen closed tabs in Google Chrome

no ratings, 0 comments
– Tip added by an anonymous user on Sep 05, 2008 at 7:40 am

New browser from Google

Categories: browsers Google chrome free
no ratings, 0 comments
– Tip added by an anonymous user on Sep 02, 2008 at 7:51 am

Searching Google images for faces

Categories: google images search
no ratings, 0 comments
– Tip added by an anonymous user on May 31, 2008 at 1:34 pm

Create your own web site for free

Categories: google hosting Website free
no ratings, 0 comments
– Tip added by an anonymous user on May 22, 2008 at 8:05 am