Excel Move Columns (Table of Contents)
- Move Columns in Excel
- Drag Columns to Change the Position
- Move Columns in Excel by Using CUT & PASTE Method
- Manual and most Difficult way to Move columns in Excel
Move Columns in Excel
When we work with large data set in excel, we may often require to move our column from one place to another to arrange the data in order. Moving could be from left to right or from right to left.
We have seen adjusting column width and rows height to show the data intact in Excel. Usually, we move unwanted columns to the end of the data range, or we always keep closely related columns together; in these cases, we need to move our existing columns to swap, interchange, or play around with those columns to make the data structure well in place finally.
In Excel, we don’t have a straightforward button which performs the task for us. We need to apply our own logic to move columns from one place to another. In this article, we completely concentrate on the techniques of moving columns in Excel.
Drag Columns to Change the Position
We are all familiar with dragging formulas from one cell to many cells in Excel. Similarly, we can change the column position by the method of drag and drop. However, it is easier than done because of the complexity involved in it. You need some work experience to master this completely; otherwise, you will face a situation of possible data loss.
Assume you have Product List, Sold Units, and Product ID data in your spreadsheet. If you look at the data closely, you need to look at the familiar data structure to understand the data better.
In a general case scenario, an ideal data structure is the Product Name, Product ID, and Units Sold column. But here, our data structure is slightly interchanged; the Product ID is there at the right end of the data structure. So we need to move the Product ID column to the left side of the Units Sold column.
Follow the below steps to arrange the data in order.
Step 1: Select the entire column of Product ID.
Step 2: Place the mouse pointer to the left side of the selected column. You need to see the change of the mouse pointer symbol from a regular PLUS symbol to 4 sided navigation arrow type symbol.
Step 3: Hold the SHIFT Key, and the 4 sided arrow key with the left button of your mouse to drag the selected column to the location where you wish to place it. In this case, I want to place this column after the PRODUCT column. When you try to drag, you can notice the green-colored straight line as shown in the below image.
Step 4: Green line is the indication that if you release your holding keys (Shift + Mouse Pointer), the selected column will be placed here. So you can drag the column until you find this green-colored straight line next to the column you wish to move. Your newly moved column is in place now.
The key here is where you need to release the holding mouse key. It looks like an easy task but needs some working practical knowledge to get familiar with it.
Move Columns in Excel by Using CUT & PASTE Method
We’ve seen how to move columns in Excel easier but easier said than done. This is much simpler than the previous one, i.e., the cut & paste method.
Take the same data from the previous example.
Step 1: Select the entire column of Product ID.
Step 2: After selecting the desired column, CUT this column by using the familiar shortcut key CTRL + X. Or else you can right-click on the column select CUT.
Step 3: Now, you need to select the column which needs to come after the pasting column, i.e., If you wish you move column C to B, you need to select column B after you cut column C.
Step 4: Now, right-click on the selected column and select Insert Cut Cells.
Step 5: As soon as you select the option Insert Cut Cells, it will insert column C to Column B, and current column B will be moved to column C.
Manual and most Difficult way to Move columns in Excel
This is probably the most difficult way of moving columns in Excel, and you will probably hate me for showing this to you. The only reason I am showing this to you because, as a learner, it is always a good thing to know as much as possible; you never know when they come in handy to you.
Take a look at the below table; everything seems ok, but there is only one problem: all the months are not in order. Apr, May should come after Feb, Mar month. Follow the below steps to rearrange this in order.
Step 1: Insert two columns after Jan Month.
Step 2: Cut and paste the columns H & I to the newly inserted columns D & E.
Step 3: Now delete those newly vacated columns D & E.
Now we have the data in order.
Things to Remember about Move Columns in Excel
- Drag and drop is a tricky one because if you don’t hold the shift key, you will end up with losing out on the data.
- CUT & PASTE is the easiest way to do so, but we cannot simply paste the column; rather, we need to select the option INSERT CUT CELLS.
- Always hold onto the shift key until you are ok with the desired column to move in the drag and drop method in Excel.
This has been a guide to Move Columns in Excel. Here we discuss various methods to Move Columns in Excel like Drag Columns to Change the Position, Move Columns by Using CUT and PASTE methods, Manual and most difficult Way to Move Columns in Excel with practical examples and downloadable Excel template. You can also go through our other suggested articles –