Hyperlinking Text in Google Spreadsheets
One of my biggest complaints about Google Docs Spreadsheets is that their is no formatting menu to add hyperlinks to text in a cell. You actually have to use the following notation to make it happen:
=hyperlink(”URL”,”Hyperlinked Text”)
Beyond that to indicate a cell is hyperlinked you need to format it yourself or the cell will simply appear as having text in the box with no link. Mousing over gives you a little indicator that the cell is a link but you probably would want to format the text with a blue color and underline so you know that it’s a link. My other pet peeve is that the context sensitive help doesn’t indicate that you need the quotes around your pair so entering the example:
=hyperlink(www.trickflash.com, tricks)
This would yield an #ERROR!. See the example below for some of the things I am talking about.
Okay I am done griping it has just been a very big inconvenience for me today. I hope this helps someone.
No comments:
Post a Comment