Placing Hyperlinks in New Google Sheets

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:

Click image to enlarge

Click image to enlarge

Or, use the link icon in the toolbar:

Click image to enlarge

Click image to enlarge

Or, right click in the appropriate cell of your spreadsheet and choose Insert link:

Click image to enlarge

Click image to enlarge

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.

Click image to enlarge

Click image to enlarge

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.

Click image to enlarge

Click image to enlarge

Of course, you can also still use the HYPERLINK() function described in the previous post.