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

