Copy a worksheet in the same workbook in Excel 2007

When you are working with a worksheet, you may do multiple changes to the data and might feel that the data that is in the original worksheet be preserved. In this case, you may copy the original worksheet and do the editing work in the copied worksheet. Perform the following to copy a worksheet.
1. On the sheet tab bar, click the worksheet that you need to copy.
2. Right-click the worksheet and click Move or Copy... to open the Move or Copy dialog box.
3. In the Move or Copy dialog box, specify a location for the copied worksheet. For example, to place the worksheet at the end of the existing worksheets, click (move to end). To move to a location between two worksheets, say between Sheet2 and Sheet3, click the worksheet that is to the right, in this example, it is Sheet3.
4. Click to place a checkmark besides Create a copy.
5. Click OK.

In this example, we have 7 worksheets labeled Sheet1, Sheet2, ... Sheet7 and we copy Sheet4 and place the copied worksheet between Sheet2 and Sheet3.

Once you copied the worksheet, the newly copied worksheet will have the name (2) at the end of the name. If you copy the same worksheet multiple times then the names will have (3), (4), and so on at the end.