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 $:
You can copy the formula to make it work for February, March and April:
Click on cell C4 to make it the active cell.
Click the Copy button on the toolbar.
Select cells D4 through to F4 to mark the destination range.
Click the Paste button 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: