Content

• Steps

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

Steps

1. 

   Open the Microsoft Excel workbook. Excel has a blue and white "X" symbol.

2. 

   
   
   Click the landing page from the sheet tabs. A list of worksheets displays at the bottom of the Excel window. Click the sheet that you want to link to another sheet.

3. 

   Click an empty cell on the destination worksheet. This will be the target cell. When you link a destination cell to another worksheet, the data in this cell is automatically synchronized and updated every time the data in the source cell changes.

4. 

   
   
   Import = in the cell to start the formula in the target cell.

5. 

   Click the source sheet from the sheet tabs. Find the sheet where you want to get the data, and click that tab to open the sheet.

6. 

   
   
   Check out the recipe bar. The formula bar displays the value of the target cell at the top of the workbook. When you switch to the source worksheet, the formula bar displays an equal sign, the name of the current sheet, and an exclamation point.
   • Or you can enter it yourself in the formula bar.The formula will look similar to the following =!, Inside ""is the name of your source page.

7. 

   Click a cell on the source page. This is going to the source box. The source cell can be either an empty cell or a cell for which data is available. When you link the worksheets, the destination cells are automatically updated with the data in the source cell.
   • For example, if you pull data from cell D12 in Sheet1, the formula will be = Sheet1! D12.

8. 

   Press ↵ Enter to complete the formula and convert it back to the target sheet. Now that the destination cell has been linked to the source cell, the data will be retrieved and imported automatically. Every time you edit data in the source cell, the destination cell is also updated.

9. 

   Click the target cell to highlight it.

10. 

    Click and drag the square icon in the lower right corner of the target cell. This expands the range of cells linked between the source and destination sheet. When you expand the original target cell, adjacent cells on the source worksheet are also linked.
    • You can drag and expand the range of linked cells in any direction, including part or the entire worksheet.
    advertisement