Calc Guide

Figure 243: Checking ledger
Referencing other sheets
On the Summary sheet we display the balance from each of the other
sheets. If you copy the example in Figure 243 onto each account, the
current balances will be in cell F3 of each sheet.
There are two ways to reference cells in other sheets: by entering the
formula directly using the keyboard or by using the mouse. We will
look at the mouse method first.
Creating the reference with the mouse
On the Summary sheet, set up a place for all five account balances, so
we know where to put the cell reference. Figure 244 shows a summary
sheet with a blank Balance column. We want to place the reference for
the checking account balance in cell B3.
Figure 244: Blank summary
To make the cell reference in cell B3, select the cell and follow these
steps.
1) Click on the = icon next to the input line. The icons change and
an equals sign appears in the input line as in Figure 245.
Chapter 10 Linking Calc Data 299