Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 35 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 35

    The data of the referenced cell address will appear in the selected cell.

                              Tech Funda

                           Pressing F4 key repeatedly over a reference (cell) will allow you to switch between
                           making the column, the row or both absolute or keeping them relative.

                     Other Workbook References

                     You can refer to cells in worksheets 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, follow these steps:

                     Step 1  Create two workbooks named Book1 and Book2 and save them.
                     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:

                     = ‘[fileaddress]’#$Sheet1.A2.
                     This reference has three parts:

                     1. The workbook name and address in square brackets.
                     2. The worksheet Sheet 1 preceded by #$ signs.

                     3. The cell having relative reference preceded by period (.) sign.

                     Hence, referencing cells in external workbooks is done by selecting the workbook, then worksheet
                     and then the cell you want to link reference to.

                                                                                     Formulas and Functions in Calc      33

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