Page 48 - modular4.0
P. 48
Chapter Profile
When you copy the formula to the next cell, address of the cell D3 will remain same as shown.
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
‘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.
For example, to enter a reference of cell A2 in Sheet2 into cell A1 in Sheet1, do this:
1 Select cell A1 in Sheet1, 3 Click on cell A2. and 4 Select cell A1, and you will see that
and type an equal (=) sign. then press Enter key. it contains the formula =Sheet2!A2.
2 Click the Sheet2 tab.
The exclamation point separates the worksheet portion of the reference from the cell portion.
Tech Funda
Pressing F4 key repeatedly over a reference (cell) will allow you to switch between making the
column, the row, or nothing ‘Absolute’.
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 to Book2 in Book1, do as follows:
Ensure you have two separate workbooks named Book1 and Book2. In Sheet1 of Book1, select cell
A1. Type an equal sign (=) in cell A1. Use the Alt+Tab keys on your keyboard to switch to Book2.
46 Modular (Ver. 4.0)-VII

