You often want to make multiple copies
of a cell. The example below shows how
you can fill a range.
- Select the cell containing the
formula you want to copy
- Move the cursor over the little
black square at the bottom right
corner of the cell ( its correct
when the cursor changes to the
little black cross)
- Keep the
mouse button depressed and drag
the Button to Play >
Notice that the formula in each cell
has updated its cell references, in the
same way as it did with the copy operation.
Note also that you are not restricted
to filling just one column at a time.
You could have selected a row of several
cells and dragged them all down at once.