Question: how to copy an excel sheet to a new tab?
Answer: Simply, click on the sheet tab that you want to copy, hold the Ctrl key and drag the tab where you want it: ...  For instance, that's how you can make a copy of Sheet1 and place it before Sheet3: ...  To copy a sheet, go to the Home tab > Cells group, click Format, and then click Move or Copy Sheet: ...  Note. ...  Awesome, isn't it?