Move rows or columns

Important notice for users of Office 2003    To continue receiving security updates for Office, make sure you're running Office 2003 Service Pack 3 (SP3). The support for Office 2003 ends April 8, 2014. If you’re running Office 2003 after support ends, to receive all important security updates for Office, you need to upgrade to a later version such as Office 365 or Office 2013. For more information, see Support is ending for Office 2003.

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

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

What do you want to do?

Move or copy rows and columns

Move or copy rows and columns by using the mouse

Move or copy rows and columns

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

ShowHow to select rows or columns

To select Do this
An entire row or column

Click the row or column heading.

Worksheet showing row and column headings

Callout 1 Row heading
Callout 2 Column heading
Adjacent rows or columns Drag across the row or column headings. Or select the first row or column; then hold down SHIFT while you select the last row or column.
Nonadjacent rows or columns Click the column or row heading of the first row or column in your selection; then hold down CTRL while you click the column or row headings of other rows or columns that you want to add to the selection.
  1. Do one of the following:
  2. Select a row or column below or to the right of where you want to move or copy your selection.
  3. Do one of the following:
    • When you are moving rows or columns, click Cut Cells on the Insert menu.
    • When you are copying rows or columns, click Copied Cells on the Insert menu.

 Note   If you click Paste Button Image on the Standard toolbar or press CTRL+V instead of clicking a command on the Insert menu, you will replace any contents of the destination cells.

Top of Page Top of Page

Move or copy rows and columns by using the mouse

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

ShowHow to select rows or columns

To select Do this
An entire row or column

Click the row or column heading.

Worksheet showing row heading and column heading

Callout 1 Row heading
Callout 2 Column heading
Adjacent rows or columns Drag across the row or column headings. Or select the first row or column; then hold down SHIFT while you select the last row or column.
  1. Do one of the following:
    • To move rows or columns, point to the border of the selection. When the pointer becomes a move pointer Excel Move Pointer, drag the rows or columns to another location.
    • To copy rows or columns, 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.

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


 Notes 

  • When you use the mouse to insert copied or cut columns or rows, the existing contents of the destination cells is replaced. To insert copied or cut rows and columns without replacing the existing contents, you should use the Cut Cells command or the Copied cells command on the Insert menu.
  • You cannot move or copy nonadjacent rows and columns by using the mouse.

Top of Page Top of Page

 
 
Applies to:
Excel 2003