Move or copy cells, rows, and columns, Office SupportHow to copy and insert row multiple times or duplicate.

When you move or copy rows and columns, you can include formulas and their resulting values, comments, cell formats, and hidden cells.

The cell reference is not adjusted if the cell contains a formula.The contents of the moved or copied cell and any cells that point to them might display the #REF!There is an error value.You will have to adjust the references manually if that happens.You can see how to detect errors in formulas.

The Cut and Copy commands can be used to move or copy selected cells, rows, and columns, but you can also use the mouse to do so.

Right-click a row or column below or to the right of where you want to copy it, and then do one of the following:

If you click Paste on the Home tab, in the Clipboard group, instead of clicking a command, you will replace the existing content of the destination cells.

Point to the border of the selection to move rows or columns.If the pointer becomes a move pointer, drag the rows or columns to another location.

While pointing to the border of the selection, hold down the CTRL and copy rows or columns.If the pointer becomes a copy pointer, drag the rows or columns to another location.

During the drag-and-drop operation, make sure to hold down CTRL.When you release the mouse button, you will move the rows or columns instead of copying them.

The existing content of the destination cells is replaced when you use the mouse to insert copied or cut columns or rows.To insert copied or cut rows and columns without replacing the existing content, you should right-click the row or column below or to the right of where you want to move or copy your selection, and then click Insert Cut Cells or Insert Copied Cells.

If there is pre-existing data in that location, the original data will be lost.

Drag your row or column between rows if you hold down SHIFT.There is space for the new row or column in excel.

The first cell of the row or column that you want to paste is the destination cell.

Columns and rows can't overlap.If you try to paste values into a row that overlaps Column C, you will get an error message.The destination area of a pasted column or row has to be outside the original values.