There are different methods to move columns in Microsoft Excel. In this article, I’ll show the most suitable 5 ways to move columns in an Excel sheet which are too easy and time-saving. Just follow the steps and have a close look at the screenshots.
Download Practice Book
Download the following Excel workbook that we’ve used to prepare this article.
5 Quick Ways to Move Columns in Excel
Method 1: Shift+Mouse Method to Move Column In Excel
Let’s get introduced to our dataset first. In the following table, we have three columns with the headers of some random names, sales amounts, and countries.
In this method, we’ll move the Last Names column to the middle (Column C). And the Sales column will thus automatically move to the first column (Column B).
One of the easiest methods to do this process is by using keyboard shortcuts and a mouse.
➥ First of all, select the cells of a column by clicking the left button of the mouse and dragging it.
➥Then move the mouse pointer to any border side of the selected area. You will see a four-direction arrow sign
➥Then press and hold the shift key and by pressing the left button of the mouse move it to your desired location where a vertical bold line will be shown.
➥And then release the left click and Shift buttons serially.
➥ Here I have moved the B column before the C column
Method 2: Cut Command Method for Moving Column In an Excel Sheet
This method is very simple to apply because we are very familiar with the Cut command. Here I will cut the D column and will bring it before the C column.
➥ Just select the range of cells of a column by using the mouse then click the right button and press the Cut option.
➥ Or just press the Ctrl+X button from the keyboard. Here I have selected the Country column.
➥ Then select the first cell of the column before which you want to move. I will move before the sales column. That’s why I have selected that cell.
➥ Then click the right button and press the “Insert Cut cells” option.
And you’ll find the column has been moved.
Method 3: Magic Move to Move Column
Really it’s like a magical method. According to this method, I will arrange the columns in the serial of Country > Sales > Last Name by moving the columns.
➥ Select the first row.
➥ Press the right-click button.
➥ Press the “Insert” option.
A new row will be added. Note that this new row will be placed on the 1st row.
➥ Put numbers in that row according to your desired serial like 3,2,1.
➥ Then select the full range of cells (A1:C10) by using a mouse.
➥ Then go to the Data tab and select the Sort command from the Sort & Filter drop-down.
It will open a dialog box.
➥ Press the Options tab and then select the radio button “Sort left to right”.
➥ Then select sort by “Row 1” and press OK.
See here the columns have been arranged according to the number.
➥ Now just delete the number row representing the first row.
And finally, you’ll get the following output.
Method 4: Swap Two Columns Using Keyboard Shortcuts in Excel
If you have a large spreadsheet then this method will be helpful to apply. In this method, I will swap column C with column D.
➥ First, select column C and then press Ctrl+X.
➥ After that, select column D and hold Ctrl + Plus Sign (+) on the numeric keypad.
➥ Now select column D and press Ctrl+X.
➥ Then select column C again and press Ctrl + the Plus Sign (+) on the numeric keypad.
The columns have been swapped as shown in the screenshot below.
Method 5: Swapping Multiple Columns in Excel
With this method, you will be able to move multiple columns smoothly both in small or large spreadsheets. Here I will swap columns B and C after column D
➥ Select the area of multiple columns, press the left click button, and drag.
➥ Then move the mouse to any edge of the selected border. We will see a 4 direction arrow sign then.
➥ At that moment, press and hold the Shift key and then press the left click button and drag to your desired location where you will see a vertical bold line.
➥ Then release the left click button and Shift key serially.
I have moved it after the “Country” column.
I hope these methods will be helpful enough to move columns in Excel. Please give me feedback and feel free to ask any questions in the comment section