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.

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

The Excel worksheet is displayed with row header 3 highlighted.

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

The Excel worksheet is displayed with the scissors icon button highlighted.

The selection is highlighted.

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

3. Step 3

Row header 19 is highlighted.

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

The paste button is highlighted.

On the Home tab, click the Paste button.

5. Step 5

Row 19 is highlighted.

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