How to Move Columns in Excel (5 Quick Methods)

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.

Shift+Mouse Method to Move Column In Excel

Steps:

➥ 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.

Shift+Mouse Method to Move Column In Excel

➥ Here I have moved the B column before the C column

Shift+Mouse Method to Move Column In Excel

Read More: How to Move Columns in Excel Table (5 Methods)


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.

Step 1:

➥ 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.

Method 2: Cut Command Method for Moving Column In an Excel Sheet

Step 2:

➥ 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.

Method 2: Cut Command Method for Moving Column In an Excel Sheet

And you’ll find the column has been moved.

Method 2: Cut Command Method for Moving Column In an Excel Sheet

Read More: Excel VBA: Cut and Insert Column (5 Examples)


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.

Step 1:

➥ 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.

Method 3: Magic Move to Move Column

Step 2:

➥ Put numbers in that row according to your desired serial like 3,2,1.

Method 3: Magic Move to Move Column

Step 3:

➥ 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.

Method 3: Magic Move to Move Column

Step 4:

➥ Press the Options tab and then select the radio button “Sort left to right”.

Method 3: Magic Move to Move Column

Step 5:

➥ Then select sort by “Row 1” and press OK.

Method 3: Magic Move to Move Column

 

See here the columns have been arranged according to the number.

Step 6:

➥ Now just delete the number row representing the first row.

And finally, you’ll get the following output.

Method 3: Magic Move to Move Column


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.

Step 1:

➥ First, select column C and then press Ctrl+X.

Method 4: Swap Two Columns Using Keyboard Shortcuts in Excel

Step 2:

➥ After that, select column D and hold CtrlPlus Sign (+) on the numeric keypad.

Method 4: Swap Two Columns Using Keyboard Shortcuts in Excel

Step 3:

➥ Now select column D and press Ctrl+X.

Method 4: Swap Two Columns Using Keyboard Shortcuts in Excel

Step 4:

➥ Then select column C again and press Ctrl + the Plus Sign (+) on the numeric keypad.

Method 4: Swap Two Columns Using Keyboard Shortcuts in Excel

The columns have been swapped as shown in the screenshot below.

Method 4: Swap Two Columns Using Keyboard Shortcuts in Excel

Read More: How to Move Columns in Excel without Overwriting (3 Methods)


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

Steps:

➥ 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.

Method 5: Swapping Multiple Columns in Excel

I have moved it after the “Countrycolumn.

Method 5: Swapping Multiple Columns in Excel

Read More: How to Move Multiple Columns in Excel (4 Quick Ways)


Conclusion

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


Related Articles

 

Mithun

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo