Browse » Home
Tuesday, January 17, 2012
How to Link Data to Different Worksheets in Microsoft Excel
1. Launch Microsoft Excel and open each of the source spreadsheets that contain information to link into the target spreadsheet. Open the target spreadsheet last.
2. Click on the cell in the target spreadsheet that is to contain linked information from a source spreadsheet and press the 'Equal' key ('='). Switch to the source spreadsheet and click on the cell that contains the information to be linked and then press 'Enter.' The target spreadsheet now contains a link to the data in the source spreadsheet as indicated in the formula bar. Changes made to the source spreadsheet will be reflected in the target spreadsheet automatically.
3. Click on a cell in the target spreadsheet that is to contain calculated information from cells in multiple source spreadsheets and press the 'Equal' key ('='). Switch to the first source spreadsheet and click on the first cell that contains the information to be linked. Type an operator such as the 'Plus' key (' ') and click on the next cell in the formula, from the same source spreadsheet or a different one, or even from the target spreadsheet if desired. Continue to add operators and cell references until the formula is complete, then press 'Enter' to store the formula and display the results of the calculation.