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.
2. To see the result, release both the left mouse button and shift key on your keyboard.
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.
2. Right-click, and then click Cut.
3. Select a column where you want to insert the cut cell. Right-click and then click Insert Cut Cells
The result is given below.
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.
2. Select Sort & Filter group on the Data tab. Click Sort.
3. In the Sort dialog box, click Options.
4. Click Sort Left to Right and click OK.
5. Select Row 1 from the Sort by drop-down list and click OK.
Result: you will have the sorted results as below. You may want to delete the first row, which was used to order the columns.
| 2 of 12 finished! Recommending more on the Range: Next Example >> |
| << Previous Example | Skip to Next Chapter 03: Understanding Workbook |