Pinterest Pixel

How to Move Columns in Excel – 3 Easy Ways!

In Excel, sometimes you need to move columns to enhance readability or to align with specific requirements.... read more

John Michaloudis
Posted on

Overview

How to Move Columns in Excel - 3 Easy Ways! | MyExcelOnline How to Move Columns in Excel - 3 Easy Ways! | MyExcelOnline

In Excel, sometimes you need to move columns to enhance readability or to align with specific requirements. In this article, we will go through the 3 Main Methods on How to Move Columns in Excel:

Let’s look at these methods thoroughly!

Select and Drag Columns

By far the easiest and most straightforward way to move columns in Excel is the Select and Drag Method. Here’s how to do it:

Right-click on the first column and click on Insert to insert 2 blank columns.
How to Move Columns in Excel - 3 Easy Ways!

Select the column(s) you want to move. To select a single column, click on the header letter of the column. To select multiple columns, hold down the “Ctrl” key while clicking on the column headers.

How to Move Columns in Excel - 3 Easy Ways!

Position your cursor over the selected column(s) until it turns into a four-sided arrow. (Or the gloved hand cursor on a Mac.)
How to Move Columns in Excel - 3 Easy Ways!

Click and hold the left mouse button, then Drag the column(s) to the desired location.
How to Move Columns in Excel - 3 Easy Ways!

See also  How to Change Audio Settings in Microsoft Teams

Release the mouse button to drop the column(s) into the new position.
How to Move Columns in Excel - 3 Easy Ways!

Cut and Paste Columns

Another useful way to move columns in Excel is the Cut and Paste method. Here’s how to do it:

Select the first column you want to move. Click on the header letter of the column to select it. Right-click on the selected column and choose “Cut” from the context menu, or use the keyboard shortcutCtrl + X” to cut the column.
How to Move Columns in Excel - 3 Easy Ways!

Select the column where you want to place the cut column. Click on the header letter of the target column. Right-click on the target column header and choose “Insert Cut Cells” from the context menu, or use the keyboard shortcut “Ctrl + Shift + V” to paste the cut column.
How to Move Columns in Excel - 3 Easy Ways!

The original column will be inserted into the new position, pushing the existing columns to the right.
How to Move Columns in Excel - 3 Easy Ways!

Using Sort Data Feature

See also  How to Autofit Columns Using Macros in Excel

Let’s say you want to move all of the columns this exact order: Country, First Name, Last, and Time. To move columns in Excel using the sort feature, you can follow these steps:

Right-click on the first row and click Insert.
How to Move Columns in Excel - 3 Easy Ways!

Label the columns in the order you want them to appear. In our case it will be Country (A), First Name (B), Last Name (C), and Time (D).
How to Move Columns in Excel - 3 Easy Ways!

Select the entire dataset that contains the columns you want to move. You can click and drag the mouse pointer to select the range, or you can press Command+A (⌘+A) to select the entire sheet if your dataset occupies the entire sheet.
How to Move Columns in Excel - 3 Easy Ways!With the dataset selected, go to the “Data” tab in the Excel ribbon at the top of the window. Look for the “Sort” button and click on it to open the Sort dialog box.
How to Move Columns in Excel - 3 Easy Ways!Choose the sort order for the selected column by clicking the Options button. If you want to move the column to the beginning, select “A to Z” (ascending) or “Smallest to Largest.” If you want to move the column to the end, select “Z to A” (descending) or “Largest to Smallest.”
How to Move Columns in Excel - 3 Easy Ways!

See also  Boost Your Excel Skills: How to Swap Columns in Excel Flawlessly

Click on the “Sort” button in the Sort dialog box to sort the data based on your selection. The column you chose to sort by will now be moved accordingly within the dataset.
How to Move Columns in Excel - 3 Easy Ways!

Note: The sort method can be useful when you want to move a column to a specific position relative to other columns in the dataset.

There you have it! By using the three main techniques described in this article you can effectively rearrange columns to enhance data organization and streamline your Excel workflow.

If you like this Excel tip, please share it
How to Move Columns in Excel - 3 Easy Ways! | MyExcelOnline How to Move Columns in Excel - 3 Easy Ways! | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...