Windows Mac
Ctrldrag ⌥drag

About This 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

Excel How to build a simple pivot chart dashboard

How to build a simple pivot chart dashboard

In this video, we'll build a simple dashboard by setting up a slicer to control to more than one pivot chart. Here's the chocolate sales data we looked at earlier. Using the techniques discussed in this section, let's build a simple dashboard to show sales by city and top 5 chocolate flavors. …
Excel How to add a second pivot chart

How to add a second pivot chart

In this video, we'll look at how to add additional pivot charts based on the same data. Once you have a pivot chart, you might want to create additional pivot charts to provide different views of the same data. This worksheet has a simple pivot table and pivot chart already set up. As always, any …
Excel Shortcuts for drag and drop

Shortcuts for drag and drop

In this video, we'll look at shortcuts related to drag and drop in Excel. To drag and drop in Excel, just make a selection and hover the mouse over the edge of the selection. When the cursor changes, you can drag the selection to a new location. With this method, drag and drop is equivalent to cut …
Excel Shortcuts to cut copy paste

Shortcuts to cut copy paste

In this video, we'll look at shortcuts for the operations Cut, Copy, and Paste, and related Drag and Drop commands. To copy cells to the clipboard, use the shortcut Control + C on Windows, and Command C on the Mac. To paste, use Control + V on Windows and Command + V on the Mac. Note that when …
Excel How to move and copy worksheets in Excel

How to move and copy worksheets in Excel

In this lesson, we'll look at how to move and copy worksheets in the same workbook. This allows you to put worksheets into a sequence that makes sense and to duplicate worksheets when needed. Let's take a look. Here we have a workbook that contains several sheets. Let's rearrange these worksheets …

Support Exceljet

Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.

Get the Lifetime Pass

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.