I assume that the worksheets are in the same workbook.
Select the cellarea on Sheet1 by
- select first cell and then hold down the left mousebutton to select the others cells.
Select a command for copying
- Edit | Copy
Paste to Sheet2
- Click on the Sheets2 tab (on the bottom of the screen if XL has a maximized window)
- Place the cursor in the first target cell
- Select a command for pasting, Edit | Paste
Please mail back if this does not solve the problem