Filter
Top Products
196
Office
Example: You might want
to sum up figures in cells C2
to C4 in cell C5; select cell
C5, press Point reference
and select the cell range
from C2 to C4. Press Enter or
OK to confirm the action.
The SUM will now appear in
C5.
In a formula, you can enter constant values or cell references. A cell reference tells
Sheet where to look for the values or data you want to use in the formula. To enter
a reference to a cell or cells in a formula:
1 Go to the cell you want to edit, and press Edit.
2 Move the cursor to the place where you want to insert a reference, and press
Point reference.
3 Select the cells that contain the values you want to use. See ‘To select cells’ on
page 135. The focus remains in the cell you are editing. Press Enter or OK to
confirm the action.
Figure 79
To select cells
There are two ways to select a cell or a range of cells in a worksheet:
Example: To select column
A, enter A:A. To select row 1,
enter 1:1. To select columns
B and C as well as rows 2
and 3, enter B2:C3
• Press the Menu key and select Edit > Select. Then enter the selection range or
choose a range from the list.
• Press and hold the Shift key, and increase the selection frame with the Arrows
key.
To select entire rows or columns, press and hold the Shift key, and select the
desired row or column headings with the Arrows key.
Linda1.book Page 196 Friday, April 12, 2002 8:31 PM