To quickly copy or move a sheet inside an Excel workbook first click on tab of the sheet to copy or move. If making a copy of the sheet, hold the Control key and drag the sheet tab to duplicate it. If moving the sheet, simply drag the sheet to its new position.