Quick, clean, and to the point

Drag to duplicate worksheet

Windows shortcut 
Mac shortcut 

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 demonstrate this shortcut.
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 video we show you how to move and copy worksheets in the same workbook.
In this lesson, we cover shortcuts you can use to cut, copy, and paste. We also cover drag and drop options.
In this video, we'll build a simple dashboard by setting up a slicer to control to more than one pivot chart.
In this lesson, we cover shortcuts you can use for drag and drop in Excel.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.