Click OK. Excel will open a new workbook with the copied sheet. If you’re using Excel 2007, do the following: Select the tab of the sheet you want to copy (or move).

Next, click the Share button at the top right of the Excel workbook, as shown below. You will get three options to share: Share, Copy Link, and Manage Access. See the screenshot below. By choosing the ...