Insert, delete and manage hyperlinks in Google Sheets
Adding Hyperlinks is a great way to give readers access to a lot of information without including the content right in that sheet. Google Sheets lets user create links to an external web page, another document, another sheet in the file and even another part of the same sheet. Here is how you add a hyperlink.
How to Hyperlink to a Web Page
In your Google Sheet, select the cell or highlight the specific text which you would like to hyperlink. To highlight the text, double click on the cell and select the required portion.
After selecting the cell or text, click on ‘Insert’ menu and select ‘Insert Link’ from the drop-down list. Alternatively, you can use the
Ctrl+K keyboard shortcut too. This will open the ‘Insert Link’ dialogue box near the selected cell.
In the dialogue box, enter the URL in the ‘Link’ text box and click on ‘Apply’ button. This will hyperlink the text or cell to that URL.
The hyperlinked text will now be highlighted. You can have a quick view of the linked URL by hovering your cursor over the cell. Click on that link to go to the webpage.
Similarly, you can add hyperlinks to multiple web pages in a single cell of a Google Sheet. You can do so by selecting different parts of text and hyperlinking them with the above process or by directly entering the URLs in the single cell. Google sheet will detect a URL entered in its cell and hyperlink it automatically.
Hyperlink to another Google Document
Google Sheets also lets you direct the reader to another Google document. It can be another Google Sheet, Doc, Slide or Form saved in the same Google Drive. To hyperlink the document, follow the above steps till the ‘Link’ dialogue box appears.
To hyperlink, select the cell or text you would like to hyperlink. Click on ‘Insert’ Menu and select ‘Insert Link’ or press ‘Ctrl+K’. The ‘Link’ dialogue box will appear near the selected cell.
In the dialogue box, search for your document by typing its name in the ‘Link’ text box. Once found, Click on the document name to select it.
After selecting the document, click on the ‘Apply’ button next to the text box. This will hyperlink the document to the cell or text. Readers can open the document by hovering the cursor over the cell and clicking on the link in the quick view.
Hyperlink to sheets in the same spreadsheet
When working with multiple sheets in a spreadsheet, you have to often refer to data from a sheet while working in another sheet. Hyperlinking allows you to seamlessly traverse between the sheets. To add a hyperlink to another sheet, follow the above steps till the ‘Link’ dialogue box appears.
In the dialogue box, click on the ‘Link’ text box to reveal a drop-down list. Click on ‘Sheets in this spreadsheet’ to see the list of sheets in the spreadsheet. From the list of sheets, click on the one that is to be linked.
After selecting the sheet, click on ‘Apply’ button in the dialogue box. The cell or text is now hyperlinked to the desired sheet. You can access the sheet by hovering your cursor over the cell and clicking on the link in the quick view.
Hyperlink to a range of cells in the same sheet
When working with large sets of data, you have to access a bit of data on the same sheet. Hyperlinking will ease you of the pain of scrolling through the data every single time by giving access to a range of cells at one click. To hyperlink to a range of cells in the same sheet, follow the above steps till the ‘Link’ dialogue box appears.
In the dialogue box, Click on the ‘Link’ text box to reveal a drop down list. Click on ‘Select a range of cells to link’.
Once the ‘Select a data range’ box appears, select the range of cells using your cursor. Then, click on the ‘OK’ button the dialogue box.
You will be redirected to the ‘Link’ dialogue box once the data range is confirmed. Click on the ‘Apply’ button in the dialogue box.
You can now access the range of cells by hovering your cursor over the cell and clicking on the link in the quick view.
How to remove a hyperlink
Removing a hyperlink is quite a simple process. Simply hover your cursor over the hyperlinked cell. A quick view will appear with a link along with some icons. Click on the ‘Remove Link’ icon to remove the hyperlink.
Hyperlinking ability in Google Sheets enables users to access and refer to the right data at the right time. We hope the tips shared above help you create sophisticated and sleek documentation.