To copy a range of cells, select the range that you wish to copy and press the Copy Cells toolbar button in the toolbar.
This will highlight the range you have chosen to copy with a dotted line. Now select the cell which defines the top left cell of the destination range (this can be in another worksheet within the same workbook). Then press the Paste Cells toolbar button.
The range of values will be copied to the new destination. Any cells containing formulas will have their formulas updated to reflect the new destination.
