Page 22 - Trackpad_ipro 4.1_Class8
P. 22
Tech
Funda
Pressing the F4 key repeatedly over a reference (cell) will allow you to switch
between making the column, the row, or nothing ‘Absolute’.
Mixed References
A mixed reference is a reference that refers to a specific row or column. It is basically a combination
of relative and absolute references. In some situations, you may need to make the cell reference
as a ‘Mixed’ reference so that you can lock either a column or a row by preceding it with a Dollar
($) symbol.
For example, $A1 or A$1.
References to Other Worksheets
You can refer to cells in other worksheets within the same workbook just as easily as you refer to
cells in the same worksheet.
To reference a cell in another worksheet, follow these steps:
Step 1 Select the cell where you want to enter the reference, such as A1 in Sheet1.
Step 2 Type an equal sign (=).
Step 3 Click on the tab for the other worksheet (e.g., Sheet2).
Step 4 Click on the cell you want to reference (e.g., A2 in Sheet2).
Step 5 Press the Enter key. You will return to Sheet1.
Step 6 Click on cell A1, and you will see the formula in the formula bar =Sheet2!A2.
The exclamation point separates the worksheet portion of the reference from the cell portion.
Other Workbook References
You can refer to cells in a worksheet in other workbooks in the same way as you refer to
cells in other worksheets within the same workbook. These references are called external
references.
To enter a reference to Book2 in Book1, follow these steps:
Step 1 Create two workbooks named Book1 and Book2.
Step 2 In Book1, select cell A1 in Sheet1 and type an equal (=) sign.
Step 3 Switch to Book2 by pressing Alt+Tab. Click to select cell A2 in Sheet1 of Book2.
Step 4 Press the Enter key.
After pressing Enter, the formula in Book1 cell A1 should appear as:
= [Book2] Sheet1! $A$2
This reference has 3 parts:
1. Workbook: Book2 enclosed in square brackets
2. Worksheet: Sheet1 followed by an exclamation mark (!)
3. Cell: Absolute reference A2
20 iPro (Ver. 4.1)-VIII

