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.socializedSoftware.com, Socialized Software)

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.

Popularity: 1% [?]