How to Copy Excel 2010 sheet to another sheet

Duplicating your Excel data can be useful if you need to make changes you might want to undo. This tutorial shows you how to copy excel sheet to another sheet.


Step # 1 – Choosing the Sheet You Want to Copy

Open Excel with the sheet that you want to copy. In the bottom you will see a series of tabs that detail the different sheets in the workbook, right click on the currently selected one, in this case “Cost Data”. In the menu that appears click “Move or Copy…”

Choosing the sheet to copy

Step # 2 – Copying the Sheet

The “Move or Copy” window will appear and you need to make sure that in the drop down box the current workbook is selected, in this case “Book1”. You should also select the “Create a copy” check box as we want to copy, not just move the sheet. Click “OK”

Choosing where to copy the sheet to

Step # 3 – Viewing the Copied Sheet

A new sheet will appear in the sheets bar at the bottom, you can see the computer has labeled it “Cost Data (2)”. This sheet is an exact copy of “Cost Data” and you can see that the data between the two sheets is identical. This is how to copy excel sheet to another sheet.

The data in the new sheet is identical to the copied sheet