Move Excel Columns
We can move Excel columns in at least three different ways: using Shift Key, inserting cut cells, and using the Excel menu.
Using Shift Key
1. Select a column. Hover the mouse pointer over the border of the selected cell. When a four-sided arrow appears, press and hold the Shift key then click and hold the left mouse button. Now move the column to a new location of your choice.
![move a column](https://overallmoney.com/wp-content/uploads/2022/03/Move-column1-1.png)
2. To see the result, release both the left mouse button and shift key on your keyboard.
![moved column](https://overallmoney.com/wp-content/uploads/2022/03/Move-column2.png)
Note: Holding down shift key allows moving column without overwriting existing data. Additionally, if you want to move multiple columns at a time, you can follow the same steps described above.
Inserting Cut Cells
1. Select a column as in the picture below.
![select a column](https://overallmoney.com/wp-content/uploads/2022/03/Move-column1.png)
2. Right-click, and then click Cut.
![cut a column](https://overallmoney.com/wp-content/uploads/2022/03/Move-column3.png)
3. Select a column where you want to insert the cut cell. Right-click and then click Insert Cut Cells
![insert a cut column](https://overallmoney.com/wp-content/uploads/2022/03/Move-column4.png)
The result is given below.
![inserted column](https://overallmoney.com/wp-content/uploads/2022/03/Move-column5.png)
Note: If you like to move multiple columns at a time, you can follow the same steps described above.
Using Excel Menue
1. If you have a lot of columns to be rearranged in a single command, use the first row to indicate the new order of the columns. Select the entire data range.
![select a range](https://overallmoney.com/wp-content/uploads/2022/03/Move-column6.png)
2. Select Sort & Filter group on the Data tab. Click Sort.
![sort command in Data tab](https://overallmoney.com/wp-content/uploads/2022/03/Move-column7.png)
3. In the Sort dialog box, click Options.
![sort dialog box](https://overallmoney.com/wp-content/uploads/2022/03/Move-column8-1.png)
4. Click Sort Left to Right and click OK.
![excel sort options](https://overallmoney.com/wp-content/uploads/2022/03/Move-column9.png)
5. Select Row 1 from the Sort by drop-down list and click OK.
![drop-down list from the sort dialog box](https://overallmoney.com/wp-content/uploads/2022/03/Move-column10.png)
Result: you will have the sorted results as below. You may want to delete the first row, which was used to order the columns.
![sorted excel result](https://overallmoney.com/wp-content/uploads/2022/03/Move-column11.png)
2 of 12 finished! Recommending more on the Range: Next Example >> |
<< Previous Example | Skip to Next Chapter 03: Understanding Workbook |