Page 19 - 2617_JSSPS_C-6

Mixed References

A mixed reference is one 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 to cell A2 in Sheet2 into cell A1 in Sheet1,
do this:

Select cell A1 in Sheet1, 1 Click on cell A2, and then 3 Select cell A1, and you will see that
and type an equal (=) sign. 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.

Hintbot

To switch between making the column, the row, or nothing ‘Absolute’:
press the F4 key repeatedly over a reference (cell).

Charts, Formulas & Functions in Excel 17