Cutting and Moving Rows and Columns

   Overview   

You can cut an entire row or column from a worksheet, or you can cut and paste it elsewhere in the file.

   Instructions   

  1. Step 1: Click the appropriate row or column of the cell that contains content you wish to copy or move.
  2. Step 2: Click the Scissors icon button to cut the contents of the selected row.
  3. Step 3: Click the appropriate row or column header where you want to paste the selected cell contents. 
  4. Step 4: Click the Paste button.
  5. Step 5: The contents are moved to the selected location in the worksheet.

In this article, you will learn the steps to cut or move a row or column to another location in an Excel worksheet.

1. Step 1

step image

In an Excel worksheet, click the appropriate row or column of the cell that contains content you wish to copy or move.

Example shown here: row header 3

2. Step 2

step image

The selection is highlighted.

On the Home tab, click the Scissors icon button to cut the contents of the selected row.

3. Step 3

step image

Click the appropriate row or column header where you want to paste the selected cell contents.  

Example shown here: row header 19 .

4. Step 4

step image

On the Home tab, click the Paste button.

5. Step 5

step image

The contents are moved to the selected location in the worksheet.