How to Duplicate a Sheet in Excel in VBA? Use this shortcut as many times as you need. Now, click on the sheet tab and press Ctrl + D to instantly duplicate the sheet.
Open the workbook in which you want to place your duplicate.However, if you want to copy your sheet to another workbook, the method is slightly different: Drop the sheet tab and release the Option key.