How to Link Sheets in Excel

PDF download Download Article
PDF download Download Article

This wikiHow teaches you how to link data between multiple worksheets in a Microsoft Excel workbook. Linking will dynamically pull data from a sheet into another, and update the data in your destination sheet whenever you change the contents of a cell in your source sheet. [1]

Quick Guide for Linking Sheets in Excel

Click an empty cell in your destination sheet, then type an equal sign (=) and click on the source sheet, then the source cell in the source sheet, and hit Enter. Check to make sure that the destination cell's formula has been altered.

Steps

PDF download Download Article
  1. The Excel icon looks like a green-and-white "X" icon.
  2. You will see a list of all your worksheets at the bottom of Excel. Click on the sheet you want to link to another worksheet. [2]
    Advertisement
  3. This will be your destination cell. When you link it to another sheet, the data in this cell will be automatically synchronized and updated whenever the data in your source cell changes. [3]
  4. It will start a formula in your destination cell.
  5. Find the sheet where you want to pull data from, and click on the tab to open the worksheet.
  6. The formula bar shows the value of your destination cell at the top of your workbook. When you switch to your source sheet, it should show the name of your current worksheet, following an equals sign, and followed by an exclamation mark. [4]
    • Alternatively, you can manually write this formula in the formula bar. It should look like =<SheetName>! , where "<SheetName>" is replaced with the name of your source sheet. [5]
  7. This will be your source cell. It could be an empty cell, or a cell with some data in it. When you link sheets, your destination cell will be automatically updated with the data in your source cell. [6]
    • For example, if you're pulling data from cell D12 in Sheet1, the formula should look like =Sheet1!D12 . [7]
  8. This will finalize the formula, and switch back to your destination sheet. Your destination cell is now linked to your source cell, and dynamically pulls data from it. Whenever you edit the data in your source cell, your destination cell will also be updated.
  9. This will highlight the cell.
  10. This will expand the range of linked cells between your source and destination sheets. Expanding your initial destination cell will link the adjacent cells from your source sheet.
    • You can drag and expand the range of linked cells in any direction. This could include the entire worksheet, or only parts of it.
    11. Advertisement

Community Q&A

Search
Add New Question
  • Question
    In the above linking of rows to multiple sheets, how do I keep the rows in the separate sheets together when sorting?
    Azmat najeeb
    Community Answer
    1. Open a workbook. By default, it has three sheets. If you want more, you can insert more sheets according to your requirements. 2. Press the CTRL key and select the sheet you want to group. Your sheets are now grouped. The changes made to one will replicate on the others.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 3 Helpful 10
  • Question
    What if I want the destination cell to add or subtract from the source cell?
    Azmat najeeb
    Community Answer
    A cell reference combines the column letter and row number, such as A1 or F345. 1.Type a number in cells C1 and D1. For example, a 5 and a 3. 2. In cell E1, type an equal sign (=) to start the formula. 3. Type "C1+D1" (without the quotes) to complete your formula. If your destination cell E1 is in another sheet, then use "=sheet1!C1+sheet1!D1". If the cell D1 is in the same sheet as E1, then use "=sheet1!C1+D1".
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 7 Helpful 5
  • Question
    Can you link a completely different Excel file to another Excel file, or does it work only if it's in the same file?
    Holly Hort
    Community Answer
    In Microsoft Excel, you can link data from one Excel file to another, even if they are in separate files. This is commonly done using the "External Links" feature.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 4 Helpful 5
See more answers
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Unprotect an Excel Sheet
      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Create a Graph in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      New to Excel? Here's Super Easy Tricks to Get You Started
      The Best Ways to Make & Format Lists in Excel
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/update-workbook-links-21e995b5-bab1-4328-8ab3-dd357fe0e653
      2. ↑ https://support.microsoft.com/en-gb/office/work-with-links-in-excel-7fc80d8d-68f9-482f-ab01-584c44d72b3e
      3. ↑ https://support.microsoft.com/en-gb/office/work-with-links-in-excel-7fc80d8d-68f9-482f-ab01-584c44d72b3e
      4. ↑ https://support.microsoft.com/en-us/office/create-workbook-links-c98d1803-dd75-4668-ac6a-d7cca2a9b95f
      5. ↑ https://support.microsoft.com/en-us/office/create-or-change-a-cell-reference-c7b8b95d-c594-4488-947e-c835903cebaa
      6. ↑ https://support.microsoft.com/en-us/office/create-workbook-links-c98d1803-dd75-4668-ac6a-d7cca2a9b95f
      7. ↑ https://support.microsoft.com/en-us/office/create-or-change-a-cell-reference-c7b8b95d-c594-4488-947e-c835903cebaa

      About This Article

      Article Summary X

      1. Open Excel.
      2. Click your destination cell.
      3. Type " = ".
      4. Click another sheet.
      5. Click your source cell.
      6. Press Enter on your keyboard.

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 494,631 times.

      Is this article up to date?

      Advertisement