Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 19 - 2617_JSSPS_C-6
P. 19

    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

| 14 15 16 17 18 19 20 21 22 23 24 |