Though you can just drag and drop (while holding the ‘Shift’ key) to move columns in the same worksheet, moving columns to a different worksheet is a different story.
In this case, you have to either cut (if you want to remove it from its previous sheet) or copy it (if you want to retain the column).
Back to our example. Let’s say we have a different worksheet with the employees’ usernames and we wanted to move the column to the first sheet between ‘First Name’ and ‘Deparment’.
Here’s what we want to achieve:
To start, select once again the column or the contents you want to move.
Let’s select the whole column.
Copy (‘Ctrl’ + ‘C’) or cut (‘Ctrl’ + ‘X’) the column. You can also right-click the selection and choose ‘Cut’ or ‘Copy’.
The next thing to do is go to the sheet where you want the columns to be copied.
Then, select and click where you want to insert the column.
If you want to copy the ‘Username’ column to the intended place, click the ‘Department’ column instead of ‘First Name’. The copied column will be inserted before (to the left) of the clicked column.
Congratulations! You have successfully moved an entire column to another worksheet!