Google Sheets – How to Add a Hyperlink to a Cell

google sheetshyperlinks

In Excel, I can easily add a hyperlink to a cell by choosing the corresponding toolbar button. How do I do the same thing in a Google Doc spreadsheet?

I don't see any corresponding toolbar button or menu item. I'm using a Google Apps, if that makes any difference.

Best Answer

It is the HYPERLINK function in the format of =HYPERLINK(URL; TEXT TO DISPLAY)

e.g.

=HYPERLINK("www.google.co.uk"; "Google")

Do not forget there is semicolon used between the actual link from the text.

Related Solutions

Google Sheets – Generate Hyperlinks from Cell Contents

Assuming your values are in column A, you can do this in column B:

=HYPERLINK(CONCATENATE("http://mywebsite.com?id=",A1);"link text")

Then you can auto-fill down the rest of the column.

If you want the text of the link to be the same as the id you're linking, that's as simple as

=HYPERLINK(CONCATENATE("http://mywebsite.com?id=",A1);A1)

Google-sheets – Notes In Published Google Spreadsheets

The actual version of Google spreadsheets doesn't publish the notes. This "unsupported feature" isn't yet documented in the Docs editors help.

References
Check out the new Google Sheets - Docs editores Help

Best Answer

Related Solutions

Google Sheets – Generate Hyperlinks from Cell Contents

Google-sheets – Notes In Published Google Spreadsheets

Related Topic