Page 53 - TP_Prime_v2.2_Class_6
P. 53

Step 4:  Select cell A1, and you will see that it contains the formula = Sheet2! A2.

                 The exclamation point separates the worksheet portion of the reference from the cell
                 portion.


                                                             Soft Hint


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



                   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 of Book2 in Book1, follow these steps:                                 51

                 Step 1:  Create two workbooks named Book1 and Book2.

                 Step 2:  Select cell A1 in Sheet1 of Book1, and type an equal (=) sign.

                 Step 3:   Switch to Book2 by pressing Alt+Tab keys from the keyboard. Click to select cell
                          A2.


                 Step 4:  Press Enter key.

                          After you press Enter key, your formula in Book1, Cell A1, should be

                          = [Book2] Sheet1! $A$2

                 This reference has 3 parts:

                 1.  The workbook Book2 in square brackets,

                 2.  The worksheet Sheet 1 followed by ! sign

                 3.  The cell having absolute reference.

                 Hence, referencing cells in the external workbooks is done by selecting the workbook, then

                 worksheet, and then the cell you want to link reference to.






                                   Envision your favourite tech  personality  as  a  Gizmo Gadget.  How  would you
                                   paint their portrait in Excel?
   48   49   50   51   52   53   54   55   56   57   58