Computer Training

Microsoft Excel 2003/07 - Copying Worksheets

Click on the video icon for a demonstration

Excel workbooks can contain up to 256 worksheets. Using this shortcut you can easily copy a worksheet, either within the current workbook or to a new or existing workbook.

How to:
Current Workbook

1. Right-click on the tab of the sheet you want to copy.
2. Select the menu "Move or Copy."
3. Check the box "Create a copy" located in the lower left corner of the Move or Copy dialog box.
4. Choose a location under the menu "Before sheet" and then click "OK."

Click on the video icon for a demonstration

New or Existing Workbook

1. Keep the workbook with the sheet to copy open.
2. Next, open the workbook that will include the copy.
3. Select the menu Move or Copy, and then remember to check the box "Create a copy."
4. Right-click on the tab of the sheet you want to copy.
5. Choose the workbook's name from the To Book drop-down list, and then click "OK."
6. To create a new workbook choose "new book."