How to add hyperlinks in Google SpreadsheetsWas linking a few sheets together using =importrange and wanted to put a quick link back to the linked sheet. Had to look up how to do this as it was not obvious. You use the function =hyperlink.
So type this into the cell
=hyperlink("url of website","Link text to appear in the cell")