Find out how to effectively link to websites, your own Google docs and within your very own Google Sheets. In this tutorial, I’ll cover,
- Types of linking in Google Sheets 00:00
- Simple copy and paste approach 00:11
- How the link is displayed and it’s properties 00:20
- Add a link to an existing cell with text in it. 00:50
- Other access points to use the link tool. 01:22
- The link window tools. 01:34
- The shortcut command to the link tool 02:05
- Add both the title and the link with the link tool. 02:30
- Link to another Google doc in your Drive 02:48
- Link to another Sheet Tab within your Google Sheet 03:35
- Link to a cell within your Google sheet 04:30
- Link to a selected range within your Google Sheet 05:34
- Link to a specific piece of text within a string of text in a cell 04:30
- Different links to different pieces of text within a cell 07:22
- Get a URL to a specific cell in a specific Sheet Tab and share it. 08:33
Linking can be a really handy tool for you when building your Google Sheet project. You can use it to reference a long list of external documents. Create a table of contents Google Sheet Tab for your monster of a Google Sheets project. Or even create a mini centralised information hub for your organisation or team.
Oh! Did you know that there is also a Google Sheets functions for HYPERLINKS. Why use it over the link too? Well, it is great for concurrent automation of cells down a row. Or you might want to add it to a greater formula to, say, add URL extensions automatically.
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.