6. Navigating With Hyperlinks

Overview

Hyperlinks let you navigate from one part of a spreadsheet to another, or to external content, quickly. Learn how to set up and use hyperlinks in this lesson.

To explore more Kubicle data literacy subjects, please refer to our full library.

Summary

  1. Lesson Goal (00:11)

    The goal of this lesson is to learn how to navigate through Excel using hyperlinks.

  2. Lesson Goal (00:11)

    The goal of this lesson is to learn how to navigate through Excel using hyperlinks.

  3. Creating Hyperlinks Within a Sheet (00:33)

    Hyperlinks are links in a cell that take you directly to content within or outside your current Excel file. Hyperlinks can be created with the HYPERLINK function or using the shortcut Ctrl + K to open the Create Hyperlink window. When creating a hyperlink, we can choose to link to a webpage, a place in our current document, a new document, or an email address.

    To link to a location in the current workbook, we specify the relevant sheet and the cell to link to. We can also adjust the text that is displayed in the cell containing the link. After creating a hyperlink, we can click it, and we will be taken to the specified cell.

  4. Creating Hyperlinks Within a Sheet (00:33)

    Hyperlinks are links in a cell that take you directly to content within or outside your current Excel file. Hyperlinks can be created with the HYPERLINK function or using the shortcut Ctrl + K to open the Create Hyperlink window. When creating a hyperlink, we can choose to link to a webpage, a place in our current document, a new document, or an email address.

    To link to a location in the current workbook, we specify the relevant sheet and the cell to link to. We can also adjust the text that is displayed in the cell containing the link. After creating a hyperlink, we can click it, and we will be taken to the specified cell.

  5. Linking to External Content (02:15)

    We can also link to external content, such as a website. To do this, we create a hyperlink and specify a link to an external webpage. In the address bar, we type the webpage we want to link to. When we do this, clicking the hyperlink in Excel will open a web browser and take us to the specified website.

  6. Linking to External Content (02:15)

    We can also link to external content, such as a website. To do this, we create a hyperlink and specify a link to an external webpage. In the address bar, we type the webpage we want to link to. When we do this, clicking the hyperlink in Excel will open a web browser and take us to the specified website.

  7. The Proper Use of Hyperlinks (03:14)

    By default, clicking a cell with a hyperlink takes you to the link’s destination. To select a cell containing a hyperlink without following the link, you can select the cell with the keyboard or hold Control and click the cell.

    Hyperlinks have some uses, but are not a particularly efficient method of navigation. Keyboard shortcuts are usually quicker than spending time setting up and using hyperlinks. The main use case for hyperlinks is creating a table of contents in a large and complex Excel model. Hyperlinks can help users unfamiliar with the workbook to find the locations they need quickly.

  8. The Proper Use of Hyperlinks (03:14)

    By default, clicking a cell with a hyperlink takes you to the link’s destination. To select a cell containing a hyperlink without following the link, you can select the cell with the keyboard or hold Control and click the cell.

    Hyperlinks have some uses, but are not a particularly efficient method of navigation. Keyboard shortcuts are usually quicker than spending time setting up and using hyperlinks. The main use case for hyperlinks is creating a table of contents in a large and complex Excel model. Hyperlinks can help users unfamiliar with the workbook to find the locations they need quickly.

Transcript

In the previous lessons, we've learned how to use keyboard shortcuts to navigate through a sheet and select cells. In this lesson, we'll learn how to navigate through Excel using hyperlinks. Hyperlinks are links that take you directly to content within or outside your current Excel file.

They can help you quickly navigate to content within your spreadsheet or to external websites.

Let's see how to create a simple hyperlink in our sheet.

Hyperlinks can be created with the hyperlink function or the hyperlink window.

In this lesson, we'll focus on the window.

We'll highlight cell A1, and insert a hyperlink with the shortcut, Ctrl+K.

As you can see, we can create links to a webpage, a place in this document, a new document or an email address.

Let's start with the simplest option and press Alt+A to create a link to a place in this document. First, we need to type a cell reference where our link will lead.

Note that we can select a cell in any sheet in this workbook which can make hyperlinks a useful way of navigating large workbooks.

In our case, we'll stick with the current sheet, Sheet1, which is already selected.

Let's type C4 to create a link that leads us to the first cell of data in our sheet.

We also want to adjust the text that will appear in cell A1.

We'll press Alt+T to adjust this text and then type First Cell of Data.

This means we'll create a link in cell A1 that will bring us immediately to cell C4 in the same sheet.

We'll press enter to create the link.

Now, if we click the link in cell A1, we can see the selected cell moves to cell C4.

Let's try creating an external hyperlink.

We'll select cell A2 and press Ctrl+K to create a new hyperlink.

This time, we'll press Alt+X to create a link to an external webpage.

This window allows us to link to a file on our computer or an external website.

In the address bar, we'll type www.kubicle.com We'll then press Alt+T to adjust the text to display and type Kubicle Homepage.

We'll then press Enter to create the link.

If we click on this link, it opens up a web browser and takes us to the Kubicle homepage.

Let's return to our spreadsheet.

By default, clicking on a cell with a hyperlink will take you to the link's destination.

If you want to select a cell containing a link without following the link, the easiest approach is to select the cell using the keyboard.

Alternatively, you can hold Ctrl and click the cell.

To delete a hyperlink, simply select the relevant cell and press Delete.

Hyperlinks can be useful in some situations but I don't personally use them a lot for navigation.

When navigating around a single Excel sheet, it's much quicker to understand and use the relevant keyboard shortcuts instead of spending time setting up and clicking on hyperlinks.

The main use case for hyperlinks is in creating a table of contents for a large Excel file containing multiple spreadsheets.

Here, we can see a table of contents for a large accounting model.

Selecting a link brings us to the relevant part of the model, which can be useful for someone not familiar with the workbook.

Apart from this use case, it's better to use the keyboard as your main tool for navigating Excel workbooks.