Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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.

share|improve this question

2 Answers 2

up vote 6 down vote accepted

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.

share|improve this answer
  1. Click the Insert link icon in the toolbar:
    toolbar screenshot
    or press Ctrl+K (or) right-click the cell and select Insert link.
  2. Enter the text and link in the popup box and click Apply.
  3. Hyperlink will be added to the text.

Note that this is for the new Google Spreadsheets. If you're editing an older spreadsheet, these intstructions do not apply.

Click Hyperlink Options to know more about editing and deleting links.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.