I previously discussed here how to insert hyperlinks into Google Sheets. In the new Google Sheets, you have several new ways in which you can insert hyperlinks.
Click the cell in your spreadsheet where you’d like the link to appear, then use one of the following methods:
Select Insert from the top menu and then click Link:
Or, use the link icon in the toolbar:
Or, right click in the appropriate cell of your spreadsheet and choose Insert link:
Finally, you can use the keyboard shortcut Ctrl + K.
A text entry field appears in which you can type the link text you’d like displayed for the link. If you leave this field empty the full URL will be displayed instead of anchor text.
In the Link field, you can paste/type a URL, an email address, or type something into the field to launch a search of relevant links across both your Google Drive files and the wider internet.
Of course, you can also still use the HYPERLINK() function described in the previous post.