Drag and Drop in Excel: How to Easily Move Data in 3 Steps

In case you work in corporate companies or a statistics student, we know Drag and Drop in Excel is essential part of your daily lives. It is go to solution for creating spreadsheets and managing data. One of its useful features is the drag and drop functionality. Because this feature can move data around the spreadsheet with ease. In this article tough, we will explore the different ways to do drag and drop with mouse and short keys.

Introduction to how to drag excel cells

Here at first, it is essential to understand what it is and how it works. Drag and drop is a basic feature indeed. So you can select and move data from one cell to another by clicking on the cell. Then you will be holding the mouse button down and dragging it to the new location. This is quite handy when you want to move data around your spreadsheet and even in between sheets.

how do you drag and drop in excel Within a Worksheet

The most common way to use drag and drop in Excel is to move data around it with mouse.

1. You will click on the cell you want to move.
2. And basically you will hold down the left mouse button and drag it to new location.
3. Voila, you only need to release the mouse button.

how to enable drag-and-drop in excel

You can also use the Ctrl key to copy the data to the new location.

1. Again you should click on the cell you wanna move.
2. This time hold down the Ctrl key and drag the data to the new location.
3. And just you release it again.

Drag and Drop Between Worksheets

You can use drag and drop in Excel is to move data between worksheets. And this option is a life saver rather than doing manual copy paste in dozen of times.

1. First, you open both worksheets in Excel.
2. You click on the tab of the worksheet with cell data you want to move.
3. And you should click on the cell to move.
4. Like you do it in the same sheet, you should hold down the left mouse button and drag the data to the new worksheet.
5. And now, just release the mouse button.

Drag and Drop Between Workbooks

You can also use drag and drop to move data between workbooks too. And it is great for moving data because otherwise you will do it manually in tons of repetitions.

1. Now, you open both workbooks in Excel.
2. You will click on the tab of the workbook having data you want to move.
3. And again, this time you click on the cell for moving.
4. You will hold down the left mouse button and drag your cell to new workbook and release it.

Drag and Drop With AutoFill

AutoFill is a feature in Excel here can fill in data quickly. You can also use drag and drop to AutoFill data in Excel like a magic.

1. You first type the data you want to AutoFill into a cell.
2. Then again, you should click on the cell with the data.
3. You press in the left mouse button and drag the data to the cells you want to AutoFill.

Drag and Drop With SmartArt: Drag and drop rows in Excel

SmartArt is can create diagrams and charts. You can use drag and drop to move SmartArt around in your worksheet as well.

1. This time you will click on the SmartArt object you want to move not the cell.
2. You again press left mouse button and drag the SmartArt to the new location and release.

Drag and Drop With PivotTables

PivotTables can be moveable as well. You can use drag and drop to move fields around in your PivotTable.