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 key, LEFT-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