Page 208 - Trackpad 402_Class-X_Final
P. 208

Subject: To create reference to an Individual Cell

                       Syntax: Sheet_name.Cell_address
                       Example: To refer to cell A1 in Sheet2, type 'Sheet2.A1'




        Cell Reference Using Another Workbook
        OpenOffice Calc gives you the facility of using a cell reference of some other workbook. To refer a cell in another
        workbook, follow the given steps:
        Step 1:  Open an existing workbook.

        Step 2:  The reference to a cell of another workbook contains:
                •  Name of the other workbook in single inverted commas ('..') followed
                   by '#' and '$'.
                •  Name of the sheet of the other workbook followed by a dot (.).
                •  Name of the cell.
        Step 3:   Confirm the formula by clicking the ‘Accept’ button in the formula bar.
                For example:
                =’file.ods’#sheet1.A3

                The reference will be similar to the given example:















                                                                                      To rearrange the relative or
                                                                                 Short key  Shift  +  F4
                                                                                       absolute references in the
                                                                                             input field:











                       Subject: To create reference to a Range of Cells
                       Syntax: Sheet_name.First_cell:Last_cell
                       Example: To refer to cells A1:A10 in Sheet2, type 'Sheet2.A1:A10'










          208   Trackpad Information Technology-X
   203   204   205   206   207   208   209   210   211   212   213