• About
  • Contact
  • Cookie
  • Disclaimer
  • Privacy Policy
  • Change the purpose of use

Tnhelearning.edu.vn - Various useful general information portal

  • Photo
  • Bio
  • How To
  • Tech

How to Link Sheets in Excel

February 18, 2024 by admin Category: How To

You are viewing the article How to Link Sheets in Excel  at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.

X

This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.

The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.

This article has been viewed 4,255 times.

This wikiHow teaches you how to link data between multiple worksheets in a set of Microsoft Excel workbooks. The linking process automatically pulls data from one sheet to another, and updates the data on the destination sheet every time you change a column in the source sheet.

Steps

Image titled Link Sheets in Excel Step 1

Image titled Link Sheets in Excel Step 1

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/47/Link-Sheets-in-Excel-Step-1.jpg/v4-728px-Link-Sheets-in-Excel- Step-1.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/47/Link-Sheets-in-Excel-Step-1.jpg/v4-728px-Link- Sheets-in-Excel-Step-1.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser -output”></div>”}
Open the Microsoft Excel workbook. Excel has a blue and white “X” icon.
Image titled Link Sheets in Excel Step 2

Image titled Link Sheets in Excel Step 2

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/17/Link-Sheets-in-Excel-Step-2.jpg/v4-728px-Link-Sheets-in-Excel- Step-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/17/Link-Sheets-in-Excel-Step-2.jpg/v4-728px-Link- Sheets-in-Excel-Step-2.jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:541,”licensing”:”<div class=”mw-parser -output”></div>”}
Click the landing page from the sheet tabs. A list of sheets will display at the bottom of the Excel window. Click the sheet that you want to link to another sheet.
Image titled Link Sheets in Excel Step 3

Image titled Link Sheets in Excel Step 3

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4f/Link-Sheets-in-Excel-Step-3.jpg/v4-728px-Link-Sheets-in-Excel- Step-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/4f/Link-Sheets-in-Excel-Step-3.jpg/v4-728px-Link- Sheets-in-Excel-Step-3.jpg”,”smallWidth”:460,”smallHeight”:341,”bigWidth”:728,”bigHeight”:540,”licensing”:”<div class=”mw-parser -output”></div>”}
Click a blank cell on the destination sheet. This will be the destination cell. When you link the destination cell to another worksheet, the data in this cell is automatically synchronized and updated each time the data in the source cell changes.
Image titled Link Sheets in Excel Step 4

Image titled Link Sheets in Excel Step 4

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/12/Link-Sheets-in-Excel-Step-4.jpg/v4-728px-Link-Sheets-in-Excel- Step-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/12/Link-Sheets-in-Excel-Step-4.jpg/v4-728px-Link- Sheets-in-Excel-Step-4.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser -output”></div>”}
Type = in the cell to start the formula in the target cell.
Image titled Link Sheets in Excel Step 5

Image titled Link Sheets in Excel Step 5

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/fb/Link-Sheets-in-Excel-Step-5.jpg/v4-728px-Link-Sheets-in-Excel- Step-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/fb/Link-Sheets-in-Excel-Step-5.jpg/v4-728px-Link- Sheets-in-Excel-Step-5.jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:542,”licensing”:”<div class=”mw-parser -output”></div>”}
Click the source sheet from the sheet tabs. Find the sheet from which you want to get the data and click on that tab to open the sheet.
Image titled Link Sheets in Excel Step 6

READ More:   Ways to Improve Posture

Image titled Link Sheets in Excel Step 6

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d9/Link-Sheets-in-Excel-Step-6.jpg/v4-728px-Link-Sheets-in-Excel- Step-6.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d9/Link-Sheets-in-Excel-Step-6.jpg/v4-728px-Link- Sheets-in-Excel-Step-6.jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:542,”licensing”:”<div class=”mw-parser -output”></div>”}
Check the formula bar. The formula bar displays the value of the target cell at the top of the workbook. When you switch to the source sheet, the formula bar displays an equals sign, the name of the current sheet, and an exclamation point.

  • Or you can manually type in the formula bar. The formula should look something like this =<SheetName>! , where “<SheetName>” is your source page name.
Image titled Link Sheets in Excel Step 7

Image titled Link Sheets in Excel Step 7

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/0e/Link-Sheets-in-Excel-Step-7.jpg/v4-728px-Link-Sheets-in-Excel- Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/0e/Link-Sheets-in-Excel-Step-7.jpg/v4-728px-Link- Sheets-in-Excel-Step-7.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser -output”></div>”}
Click a cell on the source page. This is the source cell. The source cell can be an empty cell or a cell that already has data. When you link sheets, the destination cell is automatically updated with the data in the source cell.

  • For example, if you drag data from cell D12 in Sheet1, the formula will be =Sheet1!D12 .
Image titled Link Sheets in Excel Step 8

Image titled Link Sheets in Excel Step 8

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c5/Link-Sheets-in-Excel-Step-8.jpg/v4-728px-Link-Sheets-in-Excel- Step-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c5/Link-Sheets-in-Excel-Step-8.jpg/v4-728px-Link- Sheets-in-Excel-Step-8.jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:541,”licensing”:”<div class=”mw-parser -output”></div>”}
Press ↵ Enter to complete the formula and convert back to the destination sheet. Now that the destination cell has been linked to the source cell, the data will automatically be fetched and imported. Every time you edit the data in the source cell, the destination cell will also be updated.
Image titled Link Sheets in Excel Step 9

Image titled Link Sheets in Excel Step 9

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/94/Link-Sheets-in-Excel-Step-9.jpg/v4-728px-Link-Sheets-in-Excel- Step-9.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/94/Link-Sheets-in-Excel-Step-9.jpg/v4-728px-Link- Sheets-in-Excel-Step-9.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:548,”licensing”:”<div class=”mw-parser -output”></div>”}
Click the destination cell to highlight it.
  • Image titled Link Sheets in Excel Step 10

    Image titled Link Sheets in Excel Step 10

    {“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/94/Link-Sheets-in-Excel-Step-10.jpg/v4-728px-Link-Sheets-in-Excel- Step-10.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/94/Link-Sheets-in-Excel-Step-10.jpg/v4-728px-Link- Sheets-in-Excel-Step-10.jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:542,”licensing”:”<div class=”mw-parser -output”></div>”}
    Click and drag the square icon in the lower right corner of the target cell. This will expand the range of linked cells between the source and destination worksheets. When you expand the original destination cell, adjacent cells on the source sheet will also be linked.

    • You can drag and extend the range of linked cells in all directions, including part or all of the worksheet.
    READ More:   How to Find Out Who Blocked You on Facebook
  • X

    This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.

    The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.

    This article has been viewed 4,255 times.

    This wikiHow teaches you how to link data between multiple worksheets in a set of Microsoft Excel workbooks. The linking process automatically pulls data from one sheet to another, and updates the data on the destination sheet every time you change a column in the source sheet.

    Thank you for reading this post How to Link Sheets in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.

    Related Search:

    Related Posts

    How to Create Curved Text in Photoshop
    How to fall asleep faster
    How to Install FBReader to Read eBooks

    Category: How To

    Previous Post: « How to Kill Lice
    Next Post: How to Care for American Ferns »

    Copyright © 2025 · Tnhelearning.edu.vn - Useful Knowledge