External Reference by Selecting

There are two ways to enter an external reference in a formula. With the first method, you begin typing the formula in the destination cell, then enter the external reference by selecting the appropriate range in the source document. With the second method, you copy the range in the source document, then use Paste Special... to paste it into the formula in the destination cell. These two methods are described in the following sections. 

To enter a reference from a source document into a formula in a dependent document, first select the cell where the value is to be entered and begin typing the formula. At the point in the formula where you want to enter an external reference, click on the sheet tab of the source (use the Window menu to switch to the source document if the source sheet is in a different workbook) and select the cell containing the value to be entered (let s say it s in cell H12 of the worksheet Expt XVIII-32). When you press the Enter button. Excel returns you to the dependent document, and the formula = Expt XVIII-32 H 12 is entered in the cell. 

---