How to Duplicate Sheets in Excel 2007

1. Open Excel 2007 and click the 'Office' button. Select the 'Open' option. Browse the files and locate the Excel workbook. Click the workbook and the 'Open' button. The workbook opens.
2. Right-click on the spreadsheet and click the 'Copy' option. The 'Move Or Copy' dialog box appears. Select the workbook to duplicate the worksheet to in the 'To Book' drop down list. Click the worksheet where this copied worksheet will appear before in the 'Before Sheet' drop down list.
3. Click the 'Create A Copy' check box. Click 'Ok' to complete the copy.