Copying and moving from one range to another range

You can also copy or move the contents of a range of cells from one place to another.

  1. Select the range of source cells.

  2. Select Copy image\copy.gif from either the toolbar or the Edit menu, or by right clicking your mouse. If you wish to move the information, select Cut image\cut.gif instead of Copy.

  3. Select the range of destination cells, and then select Paste image\paste.gif from the toolbar or Edit menu, or by right clicking your mouse.

Provided the copy range can fit exactly into the paste range (i.e. the paste range is an exact multiple of the copy range), you can copy information to a much larger area than the copy range. To do this, select the paste range before pasting. The paste range will contain an exact multiple of the copy range. This is extremely important when building spreadsheets. For example, you can make a formula work for one column and then copy it, in one operation, to many columns.

See also:

Drag and drop

Copying and moving information