Copying one cell to many other cells

You can copy one cell and paste it into any number of destination cells. In the example below, a formula has been entered in cell C4, =C3*$A4, to convert January’s figure from £ to $:

image\sp5.gif

You can copy the formula to make it work for February, March and April:

  1. Click on cell C4 to make it the active cell.

  2. Click the Copy button image\copy.gif on the toolbar.

  3. Select cells D4 through to F4 to mark the destination range.

  4. Click the Paste button image\paste.gif on the toolbar.

Note the use of the absolute reference in the formula – as you copy it to February, March and April, the reference to C3 changes to D3, E3, F3 respectively, but they all still refer to A4 to get the exchange rate (see Absolute addresses for more details).

The above operations can also be used to move the contents of one cell to many other cells, if Cut is used instead of Copy.

See also:

Drag and drop

Copying and moving information