You can also copy or move the contents of a range of cells from one place to another.
Select the range of source cells.
Select Copy from either the toolbar or the Edit menu, or by right clicking your mouse. If you wish to move the information, select Cut
instead of Copy.
Select the range of destination cells, and then select Paste 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: