Maybe you want to make changes but preserve the original worksheet.

Right-click on the tab for the worksheet you want to copy and select Move or Copy from the popup menu.

If the workbook into which you want to copy the worksheet is not open, it will not be available in the To book drop-down list.

Because were creating a new workbook, there are no worksheets in the Before sheet list before which we can insert the copied worksheet.

You may want to do this if you want to make changes to a worksheet, but you dont want to change the original.

Open the Move or Copy dialog box the same way we described earlier in this article.

By default, the current workbook is selected in the To book drop-down list, so dont change that.

In the Before sheet list, select the sheet before which you want to insert the copied worksheet.

Well choose to insert the copy of the worksheet at the end of the current worksheets.

You may need do something such as providing only a certain worksheet from a workbook to someone without sending them the whole workbook.

Shes been a senior technical writer, worked as a programmer, and has even run her own multi-location business.

Since we launched in 2006, our articles have been read more than 1 billion times.

Duplicate A Worksheet In Excel For Mac