#Excel drag and drop cells how to#
#Excel drag and drop cells plus#
#Excel drag and drop cells series#

Drag the fill handle across the cells where you wish the formula to be copied to.Select the cell that contains the formula you wish to copy, and then move your mouse pointer to the fill handle on the right-hand side of the cell.You can use the fill handle to drag and drop dynamic formulas. If there is already data in the destination cell or cells where you are dragging the data to, Excel warns you about over writing the data that already exists.Ĭlick OK to replace the data with the new data or Cancel to stop the drag and drop. This can of course, like moving the cell data, be down on a range of cells. Release the mouse button to copy the cell data.Still holding down the CTRL key, drag the mouse across to the destination cell.

#Excel drag and drop cells plus#

Hold down CTRL and notice the mouse pointer now has a small plus sign.

Select the cell you wish to copy and position your mouse at the bottom of the cell.

Release the mouse cursor to drop the cells into the correct position.Ĭopying cell data by drag and drop is similar to moving cell data explained above except when you drag the mouse, hold the CTRL key down on the keyboard.

Drag the mouse across or down to where you wish the cells to be moved to.

Your mouse pointer will change to an arrow with a small white cross attached to it.

If you want to move a range of cells, select all the cells you wish to move, and then move your mouse to the bottom row in the selection.

Release the mouse button to drop the data into the correct cell.

Drag the mouse to the cell where you wish to drop the data.

Your mouse pointer will change to an arrow with a small cross.

To move data from one cell to another, select the cell you wish to move and position your mouse at the bottom of the cell.

#Excel drag and drop cells series#

If you have a value in the first cell that is recognized as part of a list, then when you let the mouse go, Excel selects Fill Series to fill with the values from that list. If you want to fill the cells with a series, you can instead select Fill Series. Once you let the mouse button go, the cells you have dragged over are automatically filled, by default, with the value in the first cell ( Copy Cells). You can then hold down the mouse button and drag this cross either down the required number of rows, or across the required number of columns. When you rest your mouse on the fill handle, your mouse pointer will change to a small black cross. If you click in the bottom right-hand corner of the cell, you will see the fill handle. If you click on the fill handle and drag your mouse either down some rows or across some columns, when you let go of the mouse button (drop the cursor), the cells you have dragged over are automatically filled with relevant data. When you select a cell in Excel, the bottom right-hand corner of the cell contains a small square. It is an alternative to using cut and paste.

#Excel drag and drop cells how to#

This tutorial will demonstrate how to drag and drop cells in Excel and Google Sheets.ĭrag and drop is a way to copy or move data in Excel using the mouse.