Organizing or rearranging data will always be necessary when working with a lot of information. That’s why learning how to move a column in Excel is essential. Let’s begin!
The columns are vertical fields in Excel Spreadsheet sorted from left to right by alphabet letters. You can move them one by one or a couple of them at a time; for that, you have three (3) standard methods by which you can perform this operation in Excel:
This technique is commonly used because it works with the main commands that most people already know (Ctrl + C to copy, Ctrl + x to cut, and Ctrl + V to paste). You only need to:
Note: This method also works if you only want to move some data in a column.
This method can be advantageous if you have a lot of columns full of information and you don’t want to create a new one or delete anything; you only need to follow the steps below:
Note: you’ll get a four-directional arrow once you get close to any side edges.
Note: If you don’t hold down the Shift Key, you will be overwriting instead of inserting data
In case of rearranging several columns quickly, this method can be handy, but it requires sorting rows too (remember that rows are sorted at the right-hand of the Excel Sheet from top to bottom by numbers):
Note: The little black arrow will point to the right for rows.
Finally, you can use these three methods also for rearranging data in Excel, or you can simply select the letter column or the number row, pick the “insert” option from the contextual menu when right-clicking, and copy and paste the information you need.
Anyway, all of this will depend on what you need to do. Are you ready to put this into practice? Well, good luck!