Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 34 - ClickGPT V4.0 C-5
P. 34

    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 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).

                     32     Premium Edition-V

| 29 30 31 32 33 34 35 36 37 38 39 |