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.
=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 |

