In this article, we will look at three different ways to move a column in a Microsoft Excel worksheet. The following methods apply to Microsoft Excel 2019 and newer versions.
1. Use Drag and Drop to Move a Column in Excel
The “drag and drop” method is a simple yet effective method for moving any row or column. All you need to do is select and drag the desired column and drop it onto the right location while holding the Shift key.
2. Use Cut and Paste to Move Excel Columns
Although more suited for people who want to get work done by using the keyboard only, the cut-paste method can also be used with a mouse and keyboard combination. The entire column will then be highlighted with dotted edges on its sides. It shows that the section is being cut and is ready to be pasted. And there you have it. Your column has successfully been moved from one location to another.
3. Use Sort to Switch Columns in Excel
This method is ideal when you want to formulate and shape large data sets. However, it may not be the most suitable way of moving a column if you’re working with smaller data sets. Now, you’ll see that the columns are sorted successfully based on the inputs you gave, thereby moving the relevant column to the desired location.
How to Move a Table Column in Excel
Moving a table in Excel is simple. All you have to do is treat the entire table as a single cell. The same method applies if you want to move multiple columns at once – select the column headers while holding down the Shift key before you drag and drop them. Use Ctrl/Command (in macOS) instead of Shift to select non-contiguous columns.
Use Macros
These are not the only methods to move columns in Excel. Using Macros is also an option. However, that requires you to verify the process so that the automated dataset is accurate. Therefore, it’s best to use the methods we have discussed above. Image credit: ©dimarik16/123RF.COM
