Skip the menus and copy an Excel worksheet by using drag and drop. To do this, click the tab of the sheet to copy and hold Control as you drag a duplicate of the sheet into the desired position in the workbook. When you’re done, double click the sheet tab and change its name.