Exceljet

Quick, clean, and to the point

Drag to duplicate worksheet

Windows shortcut 
Ctrldrag
Mac shortcut 
drag

Normally, when you click and drag worksheet tabs at the bottom of a workbook, you are reordering the tabs. Use this shortcut when you want to duplicate a worksheet. The cursor will change to a small plus (+) sign inside a document. When you release your mouse, a copy of the worksheet will be inserted at the location of the cursor.

Related videos

The videos below show how this shortcut can be used.
In this video, we'll build a simple dashboard by setting up a slicer to control to more than one pivot chart.
In this video, we show you how to move and copy worksheets in the same workbook.
In this lesson, we cover shortcuts you can use for drag and drop in Excel.
In this video, we'll look at how to add additional pivot charts based on the same data. When the data is refreshed, all charts will update at the same time.
In this lesson, we cover shortcuts you can use to cut, copy, and paste. We also cover drag and drop options.