How to Move Columns in Excel with Easy Methods

How to move columns in Excel

How to move columns in Excel is a common question asked by Excel users. In this user guide, you will be able to learn how to do it in a few simple steps.

Method 1 – Using the Shift key and Left mouse button

  • Select the column you suppose to move from the table.
How to move columns in Excel - Using shift key and left mouse button
  • Move your cursor to the edge of the column and a four arrow icon will appear.
  • Press and hold the Shift key.
  • Press and hold the left mouse button.
  • Drag and move the column to the place you suppose to move the column.
  • Release the Left mouse button when you see a bold line on the edge of the column where you suppose to shift the column.
  • Finally, release the Shift key.
Result image
Final result

Method 2 – Cut and Insert

  • Select the column.
Move columns in Excel - Cut and Insert method
  • Right-click and select Cut.
Cut the coulmn
  • Select the column where you suppose to move the column. ( The column will be moved before the selected column )
Select the column where you suppose to move the column
  • Right-click and select Insert Cut Cells.
Insert cut cells
  • Finally, the Age column will move before the Name column.
Move columns in Excel

Method 3 – Sort method to move columns in Excel

This method is more suitable to move columns in Excel for a table that has many columns.

  • Add a new row before the first row of the table.
  • Number the columns as the order after you move the column you suppose to move.
How to move columns in Excel - Sort method
  • Select all the content of the table.
Select the data
  • Visit the Data tab in the Menu and click on Sort.
Sort
  • Click Options on the dialogue box that pops up. Then select Sort left to right and click OK.
Click on Options
Click on Options
Select Sort left to right
Select Sort left to right
  • Select Row 1 from the Sort by drop-down menu list and click OK.
Select Row 1
  • Finally, delete Row 1.
Move columns in Excel

Visit and read the previous tutorial to learn about How to split cells in Excel.

Author of Get Basic Idea / Second year IT undergraduate.

Sandali Tharuki

Author of Get Basic Idea / Second year IT undergraduate.

Leave a Reply

Your email address will not be published. Required fields are marked *