Rearranging the Order of Sheets in a Workbook

To make a copy of a worksheet, hold down the CONTROL key (Excel for Windows) or the OPTION key (Excel for the Macintosh) while dragging the sheet tab. A small + sign appears in the icon. 

Excel Tip. To make copies of multiple sheets, select the sheets, begin dragging, then hold down the CONTROL key. 

You can also choose Move or Copy Sheet... from the Edit menu to move a worksheet. In addition to moving sheets within the active workbook, this menu command allows you to move one or more worksheets to another workbook. 

---