# How to Link Sheets in Excel with a Formula – 4 Methods

The following dataset showcases Salesman, Product, and Net Sales of a company.

### Method 1 – Creating a Link Formula in Excel to Link Sheets

#### 1.1 Same Workbook

Data is missing in the link formula1 sheet and you want to insert data from the link formula2 sheet.

STEPS:

• Select C7 in link formula1 and enter the formula:

• Press Enter, and it’ll return the cell value in link formula2.

• Use the AutoFill .
• Check Fill Without Formatting in the AutoFill Options.

• Use the AutoFill  to fill the rest of the missing data.

#### 1.2 Different Workbook

The source workbook is Book1 and the sheet name is X sheet.

To fill the missing data in the red-colored box:

STEPS:

• Select C9 and enter the formula:
='[Book1]X sheet'!C9

• Press Enter and use the AutoFill.
• Check Fill Without Formatting in the AutoFill Options to keep the format.

• Use the AutoFill to fill the rest of the missing data.

### Method 2 – Using the Excel HYPERLINK Function to Link Sheets

There is missing data in D7.

STEPS:

• Select D7 and enter the formula:

• Press Enter and you’ll see the link location underlined in blue.

• Press the link location to go to the source worksheet.

### Method 3 – Linking Sheets with an Excel 3D Formula

To find the total of Net Sales by adding the values from sheets sheet1 and sheet2.

STEPS:

• Select D5 and enter the formula:
=SUM(sheet1:sheet2!D5)

• Press Enter and use the Fill Handle to fill the series.

This is the output.

If you have a Space in your worksheet title, you have to change the formula:

STEPS:

• Select D5.
• Enter the formula:
=SUM('sheet 1:sheet 2'!D5)

• Press Enter and use the AutoFill.

### Method 4 – Using the SUM Formula to Link Sheets in Excel

The SUM summary sheet will be linked to sheet3 and sheet4 and D5 values in sheets sheet3 and sheet4 will be added.

STEPS:

• Select D5.
• Enter the formula:
=SUM(sheet3!D5,sheet4!D5)

• Press Enter and use the Fill Handle to fill the rest of the cells.
• This is the output.

## Related Articles

<< Go Back To Excel Link Sheets | Linking in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Aung Shine

Aung Shine completed his bachelor’s in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. It has been almost 2 years since he joined SOFTEKO and actively working on the ExcelDemy project. Currently he works as a Team Leader where he guides his team members to create technical content. He has published 150+ articles and reviewed 50+ articles. He has also solved various user problems before. He has interests in Data Analysis, Power Query, Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF