|
| |
Microsoft Excel
Linking Cells
Description
In Microsoft Excel, you can link cells in one worksheet
to cells in the same worksheet, the same workbook or in a different
workbook. When you change the information in the source cell, the
information in the linked destination cell will be automatically changed.
In the example shown below, we will create a formula to
link cells in the Summary worksheet (destination) to cells in the January,
February, and March worksheets (source).
In the Destination Worksheet
Use a Formula to Link the Cells
-
Type the equal sign = to begin the formula
-
On the bottom of the Excel window, click the
sheet tab for the cell that contains the source information
-
Click in the cell that contains the source
information
-
Next, type the plus sign +
-
Click on the February sheet tab, click
on cell C5, then type the plus sign +
-
Click on the March sheet tab, click on
cell C5, then finish the formula by depressing the <Enter>
key
-
The formula will now read
=January!C5+February!C5+March!C5
-
NOTE: if the source cell is in a different
workbook than the destination cell, then the formula will
display the workbook name in square brackets. For example:
=[Sales.xls]January!C5+[Sales.xls]February!C5+[Sales.xls]March!C5
Formula with Linked Cells
|
