Page 53 - TP_Prime_v2.2_Class_6
P. 53
Step 4: Select cell A1, and you will see that it contains the formula = Sheet2! A2.
The exclamation point separates the worksheet portion of the reference from the cell
portion.
Soft Hint
To switch between making the column, the row, or nothing ‘Absolute’: press the F4 FORMULAS AND FUNCTIONS IN EXCEL
key repeatedly over a reference (cell).
Other Workbook References
You can refer to cells of a worksheet in other workbooks in the same way you refer
to cells in other worksheets within the same workbook. These references are called
external references.
For example, to enter a reference of Book2 in Book1, follow these steps: 51
Step 1: Create two workbooks named Book1 and Book2.
Step 2: Select cell A1 in Sheet1 of Book1, and type an equal (=) sign.
Step 3: Switch to Book2 by pressing Alt+Tab keys from the keyboard. Click to select cell
A2.
Step 4: Press Enter key.
After you press Enter key, your formula in Book1, Cell A1, should be
= [Book2] Sheet1! $A$2
This reference has 3 parts:
1. The workbook Book2 in square brackets,
2. The worksheet Sheet 1 followed by ! sign
3. The cell having absolute reference.
Hence, referencing cells in the external workbooks is done by selecting the workbook, then
worksheet, and then the cell you want to link reference to.
Envision your favourite tech personality as a Gizmo Gadget. How would you
paint their portrait in Excel?

