Move Or Copy Sheet In Excel 2016 For Mac. Here I want to copy the sheet at the end of the sheets hence selected the last option which is a move to end. Then do one of the following.
In the Review Tab go to Protect Workbook. Click the sheet that you want to copy. Select the Create a copy checkbox.
Copying to another workbook.
On the Move or Copy dialog box select the workbook into which you want to copy the worksheet from the To book drop-down list. Choose Move or Copy Sheet. Under Before sheet select where you want to place the copy. Select the workbook name from the To Book list click Create a Copy and then click OK.