Question: how to copy sheet in excel mac?
Answer: Hold down OPTION.
Drag the sheet tab to the location that you want the copied sheet to appear along the row of sheet tabs. Important: Release the mouse button before you release the OPTION key.