When you move or copy rows and columns, by default Excel moves or copies all data that they contain, including formulas and their resulting values, comments, cell formats, and hidden cells.

When you copy cells that contain a formula, the relative cell references are not adjusted. Therefore, the contents of cells and of any cells that point to them might display the #REF! error value. If that happens, you can adjust the references manually. For more information, see Detect errors in formulas.

You can use the Cut command or Copy command to move or copy selected cells, rows, and columns, but you can also move or copy them by using the mouse.

By default, Excel displays the Paste Options button. If you need to redisplay it, go to Advanced in Excel Options. For more information, see Advanced options.

  1. Select the cell, row, or column that you want to move or copy.

  2. Do one of the following:

    • To move rows or columns, on the Home tab, in the Clipboard group, click Cut Button image or press CTRL+X.

    • To copy rows or columns, on the Home tab, in the Clipboard group, click Copy Button image or press CTRL+C.

  3. Right-click a row or column below or to the right of where you want to move or copy your selection, and then do one of the following:

    • When you are moving rows or columns, click Insert Cut Cells.

    • When you are copying rows or columns, click Insert Copied Cells.

    Tip: To move or copy a selection to a different worksheet or workbook, click another worksheet tab or switch to another workbook, and then select the upper-left cell of the paste area.

Note: Excel displays an animated moving border around cells that were cut or copied. To cancel a moving border, press Esc.

By default, drag-and-drop editing is turned on so that you can use the mouse to move and copy cells.

  1. Select the row or column that you want to move or copy.

  2. Do one of the following:

    • Cut and replace    Point to the border of the selection. When the pointer becomes a move pointer Move Pointer, drag the rows or columns to another location. Excel warns you if you are going to replace a column. Press Cancel to avoid replacing.

    • Copy and replace    Hold down CTRL while you point to the border of the selection. When the pointer becomes a copy pointer Excel Copy Pointer, drag the rows or columns to another location. Excel doesn't warn you if you are going to replace a column. Press CTRL+Z if you don't want to replace a row or column.

    • Cut and insert   Hold down SHIFT while you point to the border of the selection. When the pointer becomes a move pointer Move Pointer, drag the rows or columns to another location.

    • Copy and insert    Hold down SHIFT and CTRL  while you point to the border of the selection. When the pointer becomes a move pointer Move Pointer, drag the rows or columns to another location.

    Note: Make sure that you hold down CTRL or SHIFT during the drag-and-drop operation. If you release CTRL or SHIFT before you release the mouse button, you will move the rows or columns instead of copying them.

Note: You cannot move or copy nonadjacent rows and columns by using the mouse.

If some cells, rows, or columns on the worksheet are not displayed, you have the option of copying all cells or only the visible cells. For example, you can choose to copy only the displayed summary data on an outlined worksheet.

  1. Select the row or column that you want to move or copy.

  2. On the Home tab, in the Editing group, click Find & Select, and then click Go To Special.

    Excel  Ribbon Image

  3. Under Select, click Visible cells only, and then click OK.

  4. On the Home tab, in the Clipboard group, click Copy Button image or press Ctrl+C. .

  5. Select the upper-left cell of the paste area.

    Tip: To move or copy a selection to a different worksheet or workbook, click another worksheet tab or switch to another workbook, and then select the upper-left cell of the paste area.

  6. On the Home tab, in the Clipboard group, click Paste Button image or press Ctrl+V.

    If you click the arrow below Paste Button image, you can choose from several paste options to apply to your selection.

Excel pastes the copied data into consecutive rows or columns. If the paste area contains hidden rows or columns, you might have to unhide the paste area to see all of the copied cells.

When you copy or paste hidden or filtered data to another application or another instance of Excel, only visible cells are copied.

  1. Select the row or column that you want to move or copy.

  2. On the Home tab, in the Clipboard group, click Copy Button image or press Ctrl+C.

  3. Select the upper-left cell of the paste area.

  4. On the Home tab, in the Clipboard group, click the arrow below Paste Button image, and then click Paste Special.

  5. Select the Skip blanks check box.

  1. Double-click the cell that contains the data that you want to move or copy. You can also edit and select cell data in the formula bar.

  2. Select the row or column that you want to move or copy.

  3. On the Home tab, in the Clipboard group, do one of the following:

    • To move the selection, click Cut Button image or press Ctrl+X.

    • To copy the selection, click Copy Button image or press Ctrl+C.

  4. In the cell, click where you want to paste the characters, or double-click another cell to move or copy the data.

  5. On the Home tab, in the Clipboard group, click Paste Button image or press Ctrl+V.

  6. Press ENTER.

    Note: When you double-click a cell or press F2 to edit the active cell, the arrow keys work only within that cell. To use the arrow keys to move to another cell, first press Enter to complete your editing changes to the active cell.

When you paste copied data, you can do any of the following:

  • Paste only the cell formatting, such as font color or fill color (and not the contents of the cells).

  • Convert any formulas in the cell to the calculated values without overwriting the existing formatting.

  • Paste only the formulas (and not the calculated values).

Procedure

  1. Select the row or column that you want to move or copy.

  2. On the Home tab, in the Clipboard group, click Copy Button image or press Ctrl+C.
     

  3. Select the upper-left cell of the paste area or the cell where you want to paste the value, cell format, or formula.

  4. On the Home tab, in the Clipboard group, click the arrow below Paste Button image, and then do one of the following:

    • To paste values only, click Values.

    • To paste cell formats only, click Formatting.

    • To paste formulas only, click Formulas.

When you paste copied data, the pasted data uses the column width settings of the target cells. To correct the column widths so that they match the source cells, follow these steps.

  1. Select the row or column that you want to move or copy.

  2. On the Home tab, in the Clipboard group, do one of the following:

    • To move cells, click Cut Button image or press Ctrl+X.

    • To copy cells, click Copy Button image or press Ctrl+C.

  3. Select the upper-left cell of the paste area.

    Tip: To move or copy a selection to a different worksheet or workbook, click another worksheet tab or switch to another workbook, and then select the upper-left cell of the paste area.

  4. On the Home tab, in the Clipboard group, click the arrow under Paste Button image, and then click Keep Source Column Widths.

You can use the Cut command or Copy command to move or copy selected cells, rows, and columns, but you can also move or copy them by using the mouse.

  1. Select the cell, row, or column that you want to move or copy.

  2. Do one of the following:

    • To move rows or columns, on the Home tab, in the Clipboard group, click Cut Button image or press CTRL+X.

    • To copy rows or columns, on the Home tab, in the Clipboard group, click Copy Button image or press CTRL+C.

  3. Right-click a row or column below or to the right of where you want to move or copy your selection, and then do one of the following:

    • When you are moving rows or columns, click Insert Cut Cells.

    • When you are copying rows or columns, click Insert Copied Cells.

    Tip: To move or copy a selection to a different worksheet or workbook, click another worksheet tab or switch to another workbook, and then select the upper-left cell of the paste area.

Note: Excel displays an animated moving border around cells that were cut or copied. To cancel a moving border, press Esc.

  1. Select the row or column that you want to move or copy.

  2. Do one of the following:

    • Cut and insert    Point to the border of the selection. When the pointer becomes a hand pointer The Move Hand Icon, drag the row or column to another location

    • Cut and replace   Hold down SHIFT while you point to the border of the selection. When the pointer becomes a move pointer The Move Hand Icon, drag the row or column to another location. Excel warns you if you are going to replace a row or column. Press Cancel to avoid replacing.

    • Copy and insert    Hold down CTRL while you point to the border of the selection. When the pointer becomes a move pointer The Move Hand Icon, drag the row or column to another location.

    • Copy and replace    Hold down SHIFT and CTRL while you point to the border of the selection. When the pointer becomes a move pointer The Move Hand Icon, drag the row or column to another location. Excel warns you if you are going to replace a row or column. Press Cancel to avoid replacing.

    Note: Make sure that you hold down CTRL or SHIFT during the drag-and-drop operation. If you release CTRL or SHIFT before you release the mouse button, you will move the rows or columns instead of copying them.

Note: You cannot move or copy nonadjacent rows and columns by using the mouse.

  1. Double-click the cell that contains the data that you want to move or copy. You can also edit and select cell data in the formula bar.

  2. Select the row or column that you want to move or copy.

  3. On the Home tab, in the Clipboard group, do one of the following:

    • To move the selection, click Cut Button image or press Ctrl+X.

    • To copy the selection, click Copy Button image or press Ctrl+C.

  4. In the cell, click where you want to paste the characters, or double-click another cell to move or copy the data.

  5. On the Home tab, in the Clipboard group, click Paste Button image or press Ctrl+V.

  6. Press ENTER.

    Note: When you double-click a cell or press F2 to edit the active cell, the arrow keys work only within that cell. To use the arrow keys to move to another cell, first press Enter to complete your editing changes to the active cell.

When you paste copied data, you can do any of the following:

  • Paste only the cell formatting, such as font color or fill color (and not the contents of the cells).

  • Convert any formulas in the cell to the calculated values without overwriting the existing formatting.

  • Paste only the formulas (and not the calculated values).

Procedure

  1. Select the row or column that you want to move or copy.

  2. On the Home tab, in the Clipboard group, click Copy Button image or press Ctrl+C.
     

  3. Select the upper-left cell of the paste area or the cell where you want to paste the value, cell format, or formula.

  4. On the Home tab, in the Clipboard group, click the arrow below Paste Button image, and then do one of the following:

    • To paste values only, click Paste Values.

    • To paste cell formats only, click Paste Formatting.

    • To paste formulas only, click Paste Formulas.

You can move or copy selected cells, rows, and columns by using the mouse and Transpose.

  1. Select the cells or range of cells that you want to move or copy.

  2. Point to the border of the cell or range that you selected.

  3. When the pointer becomes a Hand pointer, do one of the following:

To

Do this

Move cells

Drag the cells to another location.

Copy cells

Hold down OPTION and drag the cells to another location.

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

  1. Select the rows or columns that you want to move or copy.

  2. Point to the border of the cell or range that you selected.

  3. When the pointer becomes a Hand pointer, do one of the following:

To

Do this

Move rows or columns

Drag the rows or columns to another location.

Copy rows or columns

Hold down OPTION and drag the rows or columns to another location.

Move or copy data between existing rows or columns

Hold down SHIFT and drag your row or column between existing rows or columns. Excel makes space for the new row or column.

  1. Copy the rows or columns that you want to transpose.

  2. Select the destination cell (the first cell of the row or column into which you want to paste your data) for the rows or columns that you are transposing.

  3. On the Home tab, under Edit, click the arrow next to Paste, and then click Transpose.

    Home tab, Edit group

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

See also

Insert or delete cells, rows, columns

Need more help?

Expand your skills

EXPLORE TRAINING >

Get new features first

JOIN MICROSOFT INSIDERS >

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×