How To Move A Row In Excel

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 More...Less

When yous motion or copy rows and columns, Excel moves or copies all data that they comprise, including formulas and their resulting values, comments, cell formats, and subconscious cells.

If the cell contains a formula, the jail cell reference are not adjusted. Therefore, the contents of the moved or copied cell and of any cells that signal to them might brandish the #REF! fault value. If that happens, you volition have to adjust the references manually. For more information, see Discover errors in formulas

You lot can apply the Cut command or Re-create command to move or copy selected cells, rows, and columns, but you can also move or copy them by using the mouse.

Follow these steps to move or copy cells:

Select the prison cell, row, or column that you want to move or copy.
Do one of the following:
- To move rows or columns, on the Habitation tab, in the Clipboard grouping, click Cut .
  
  Keyboard shortcut: Press CTRL+Ten.
- To copy rows or columns, on the Domicile tab, in the Clipboard group, click Copy .
  
  Keyboard shortcut: Press CTRL+C.
Correct-click a row or column beneath or to the right of where yous want to move or copy your selection, and and then exercise 1 of the post-obit:
- When you are moving rows or columns, click Insert Cut Cells.
- When you are copying rows or columns, click Insert Copied Cells.
  
  Annotation:If you lot click Paste on the Home tab, in the Clipboard grouping (or press CTRL+V) instead of clicking a command on the shortcut menu, you lot will supervene upon the existing content of the destination cells.

Move or copy rows and columns by using the mouse

Select the row or column that you lot want to motion or copy.
Do ane of the post-obit:
- To move rows or columns, point to the border of the selection. When the arrow becomes a motility pointer , drag the rows or columns to another location.
- To re-create rows or columns, hold down CTRL while you betoken to the border of the choice. When the arrow becomes a copy arrow , elevate the rows or columns to another location.
  
  Important:Make sure that yous concord downwards CTRL during the drag-and-drop functioning. If y'all release CTRL earlier you release the mouse button, y'all volition move the rows or columns instead of copying them.
When y'all utilize the mouse to insert copied or cut columns or rows, the existing content of the destination cells is replaced. To insert copied or cutting rows and columns without replacing the existing content, y'all should right-click the row or column beneath or to the right of where you want to movement or copy your selection, and and so click Insert Cutting Cells or Insert Copied Cells.

Note:You cannot move or re-create nonadjacent rows and columns by using the mouse.

Motility or copy cells

Select the cells or range of cells that y'all want to move or copy.
Point to the edge of the cell or range that you selected.
When the arrow becomes a , do i of the following:

To	Do this
Move cells	Drag the cells to another location.
Copy cells	Concur down OPTION and drag the cells to another location.

Annotation:When you drag or paste cells to a new location, if there is pre-existing information in that location, Excel volition overwrite the original data.

Move or copy rows or columns

Select the rows or columns that you want to move or copy.
Point to the border of the cell or range that you selected.
When the pointer becomes a , do one of the post-obit:

To	Do this
Move rows or columns	Drag the rows or columns to another location.
Re-create rows or columns	Concord down OPTION and drag the rows or columns to another location.
Motility or copy data between existing rows or columns	Hold down SHIFT and drag your row or column between existing rows or columns. Excel makes infinite for the new row or column.

Catechumen columns to rows, or rows to columns

Copy the rows or columns that you lot want to transpose.
Select the destination cell (the start cell of the row or column into which you want to paste your data) for the rows or columns that yous are transposing.
On the Habitation tab, under Edit, click the arrow next to Paste, and then click Transpose.

Note:Columns and rows cannot overlap. For instance, if you lot select values in Column C, and endeavor to paste them into a row that overlaps Column C, Excel displays an mistake message. The destination surface area of a pasted column or row must be exterior the original values.