Windows Mac
Ctrldrag ⌥drag

About This Shortcut 

The default behavior for drag and drop is to cut data in cells, but you can also copy cells during drag and drop. To copy cells, use this shortcut before or after you start to drag the selection. Excel will display a small plus (+) symbol to indicate the copy operation.

Related videos

Excel How to copy and lock structured references

How to copy and lock structured references

In this video, we'll look at how to copy and lock structured references in a formula. Structured references behave differently from other references when copied. Let's look at some examples. First, notice if I copy and paste a formula that contains structured references, column names won't change. …
Excel How to copy and resize charts

How to copy and resize charts

In this video, we'll look at how you can resize and copy charts. After you've created a chart, you can select the chart and resize manually using any one of the 8 drag handles. To constrain the chart to the cell grid as you drag, hold down the Alt key. You'll then see the chart snap to the gridlines …
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 Conditional formatting with two variable inputs

Conditional formatting with two variable inputs

In this video, we'll look at how to extend a conditional formatting formula so that so that it checks more than just one condition. Let's take a look. Here we have the example we looked at previously. We have a single conditional formatting rule that uses a formula to highlight cells that have a …
Excel How to make an exact copy of a formula

How to make an exact copy of a formula

When you copy and paste formulas, Excel will change all relative references to reflect the new location of the formula. Usually, this is exactly what you want. However, there are times when you'll want to copy a formula exactly so that cell references don't change. Let's take a look at a few ways to …
Excel How to group values with VLOOKUP

How to group values with VLOOKUP

In this video we'll look at how to use VLOOKUP to group data into specific categories. Let's take a look. Sometimes you need to group values into discreet categories that don't exist in your data. For example, in this case, we have a list of employees and each employee is in one department. What if …
Excel How to sort a pivot table with a custom list

How to sort a pivot table with a custom list

Excel has the ability to sort using custom lists, and you can use these same lists to sort your pivot tables in a custom order. Let’s take a look. Before we sort our pivot table using a custom list, let’s first review how to sort by a custom list generally. Custom lists are useful when you want to …
Excel How to use drag and drop in Excel

How to use drag and drop in Excel

Another way to duplicate or move data in Excel is to use drag and drop. Drag and drop is an elegant alternative to using copy and paste. It can save you a few steps, but it requires a little more dexterity. Let's take a look. To move some information in Excel using drag and drop, first select the …

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.