Excel Linking – how do I create links between worksheets in a workbook and also between workbooks Excel? Watch the video to learn more

This week’s hint and tip is about how to create links within Excel. This is for creating links between worksheets in a workbook and also for between workbooks. This is on our Intermediate Excel course and covers how to create the links in your spreadsheets.Excel environment: Excel icon We are going to go through it now below.

 

Creating links between worksheets in the same workbook

Firstly, you begin by making sure you have the workbook open that you want to create the links in. It is best to go through all the sheets so that you know where you want to create the links from before you begin.

To create a link from one worksheet to another, firstly select the worksheet that you want the link to go to. Once in that worksheet, select the cell that you want the linked data to go into. From here, type in = and then go to the worksheet where you are linking from. Once in this worksheet, select the cell that you are linking from and hit the Enter key on your keyboard. This will have now created the link from one worksheet to the other.

 

Creating links between workbooks

Before you begin, it is often helpful to split your screen so that you can see both workbooks at the same time. This makes it easier for you when you are creating the links between the workbooks.

To create a link between workbooks, you follow the same steps as you would above within a workbook. The main difference is the ‘path’ in the link is significantly longer as it contains the location of the workbook the link is being created from. When you create links between workbooks, they do not have to be open for the links to update; the links will update with the workbooks open or closed.

 

The video below shows you how to create both these types of links in Excel. Creating links between your worksheets and workbook can be very powerful for your spreadsheets. An example of its power, is that it can be used to display summaries of your data.

Take a look below at the video to find out more and then try it out on your own computer!

We hope you have enjoyed this hint and tip on Excel linking. Why not take a look at our previous one on Filtering?

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy