WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Move Columns in Excel

Move Columns in Excel

How to Move Columns in Excel?

We can move columns in excel from one position to another using two simple methods –

  1. Method #1 – Drag Option
  2. Method #2 – Cut and Paste Option

Let us discuss the two methods in detail –

You can download this How to Move Columns Excel Template here – How to Move Columns Excel Template

#1 Move Columns using Drag Option

Usually, when we apply the basic excel formula in the first cell, we either copy and paste to remaining cells, or we just simply drag the formula cell to other remaining cells. This is where our first hands-on dragging comes into the picture.

For the practical example of moving or swapping columns, I have created the below data.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Move Columns Example 1

In an ideal data structure of organizations, data of employees should start with Emp ID, Emp Name, and Department. But in the above example, we have the opposite of this completely; we need to sort this issue by arranging the data in order. To make the data organized, we will show you a simple dragging method but a tricky one.

  • Step 1: First, select the Emp ID column.

Move Columns Example 1-1

  • Step 2: Now, on the selected column at the right side of the selected place a cursor on the column as shown below.

Move Columns Example 1-2

  • Step 3: As soon as you can see this icon, hold on the SHIFT key, and hold the left click of the mouse, and drag the column to the required column. In this example, we are dragging the column from the third position to the first position. So drag till the first column, as shown in the below picture.

Move Columns Example 1-3

  • Step 4: Once you reach the desired column, just leave the SHIFT key and left-click of the mouse. Now the current column (Dept) will be moved to the right, i.e., now Dept occupies the second column, i.e., “B.”

Move Columns Example 1-4

Step 5: As we can see in the above image, Emp ID is the first column, and all the other columns moved one position right to the column. Now select the Emp Name column and drag to first place once again.

Move Columns Example 1-5

#2 Move Columns using CUT & PASTE Method

We can drag the column by using our traditional CUT, COPY – PASTE method as well.

  • Step 1: For this first, we need to select the column that is required to swap, so I will select the column EMP ID here.

Move Columns Example 2

  • Step 2: Now press the shortcut key Ctr + X or right-click on the column and select CUT.

Move Columns Example 2-1

  • Step 3: After we cut the column now, we need to select the column where we need to insert it. In this example, I am selecting the first column.

Move Columns Example 2-2

  • Step 4: Now, I will right-click on the column and select “Insert Cut Cells.”

Move Columns Example 2-3

  • Step 5: As soon as you choose the option “Insert Cut Cell,” it will move the current column to the right, and the newly inserted column occupies the first column spot.

Move Columns Example 2-4

  • Step 6: Now select the Emp Name column and press Ctrl + X.

Example 2-5

  • Step 7: Now, select column B.

Example 2-6

  • Step 8: Right-click and choose “Insert Cut Cell.”

Example 2-7

  • Step 9: Now, we have data organized in order.

Example 2-8

Like this, we can move columns in excel from one position to another to change the position and arrange the data in order.

Note: the First option is a quite risky one because if you forget the option of holding the shift key, you may lose the data. However, it will intimate you before replacing it.

Example 2-9

Recommended Articles

This has been a guide to Move Columns in Excel. Here we learn how to Move or drag Columns in Excel and swap columns by using the CUT & PASTE method along with practical examples and downloadable templates. You may learn more about excel from the following articles –

  • Adding Columns in Excel
  • VBA Insert Columns
  • Freeze Columns in Excel
  • Group Columns in Excel
  • REPT Function in Excel
4 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download How to Move Columns Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More