Copying many cells to many other cells

The number of cells in the copy range must divide exactly into the paste range. In the following example, cells C4 and C5 have the correct formulas, which need copying to D4 through to F4 and D5 through to F5.

image\sp7.gif

  1. Select cells C4 through to C5.

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

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

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

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

See also:

Drag and drop

Copying and moving information