Referencing Cells on Other Sheets and Spreadsheets
Before we leave the subject of creating formulas and referencing cells, we should discuss how you reference cells on other sheets of your spreadsheet or on sheets in another spreadsheet file when you create your formulas. Referencing cells on another sheet or spreadsheet can be done by typing the information into the formula or by actually clicking on the cell that you are referring to as you create the formula.
If you wish to reference a cell on another sheet in the same spreadsheet, the syntax is sheet name.cell address. For example, if a formula included cell A3 on a sheet named Quarter 1, the cell would be referenced in the formula by Quarter 1.A3, where the sheet name is separated from the ...
Get StarOffice™ 5.2 Calc Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
