Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016 Office for business Microsoft Office

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.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

 

  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, select Cut cut icon image or press CTRL+X.

    • To copy rows or columns, on the Home tab, in the Clipboard group, select Copy copy icon 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, select Insert Cut Cells.

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

    Tip: To move or copy a selection to a different worksheet or workbook, select 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, select Find & Select, and then select Go To Special.

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

  4. On the Home tab, in the Clipboard group, select Copy copy icon 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, select 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, select Paste Button image or press Ctrl+V. If you select 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, select Copy copy icon 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 select 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, select Cut cut icon image or press Ctrl+X.

    • To copy the selection, select Copy copy icon 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, select 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, select Copy copy icon 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, select Values.

    • To paste cell formats only, select Formatting.

    • To paste formulas only, select 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, select Cut cut icon image or press Ctrl+X.

    • To copy cells, select Copy copy icon 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, select 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, select the arrow under Paste Button image, and then select Keep Source Column Widths.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.