We can move columns and rows by following simple steps. This tutorial will guide all levels of Excel users on how to move columns and rows.   

Figure 1 – How to move columns

How to Move Columns

  • We can move columns in Excel by following the steps below.

Figure 2 – Data to move column

  • We will take our cursor to click on the Column alphabet we want to move. In this case, we will move Column D to come after Branch (Column B). We will see that the column is highlighted once we click it

Figure 3 – Rearrange columns

  • With the column still highlighted, we will move our cursor to the line that demarcates Column C and Column D. Our cursor will change to four pointed arrows once we are on the demarcating line
  • We will hold the SHIFT keyLEFT-CLICK and drag the column to the demarcating line of Column B and Column C

Figure 4 – Move column

Note – We must hold the shift key, else, Excel we ask if we want to replace the cell content.

How to Move Rows

  • We can move rows by following the steps below

Figure 5 – How to move a row

  • We will take our cursor to click on the Row number we want to move. In this case, we will move Row 12 to Row 9. We will see that the Row is highlighted once we click it

Figure 6 – Moving rows

  • We will right-click and select cut. With the Row number still highlighted, we will move our cursor to Row 9 and click on it

Figure 7 – Move rows

  • We will right-click and select Insert Cut Cells

Figure 8 – How to rearrange rows