How to Swap Columns Using Cut and Paste Columns Individually
If dragging multiple columns with your mouse seems difficult or time-consuming, an alternative method is cutting and pasting each individual column separately. Here’s how it works:
Step 1: Select a cell within the first column you want to move
Step 2: Press Ctrl + X or right-click and choose “Cut” from the context menu
Step 3: Choose where you want to paste this data
Choose where exactly you wish this cut / copied range to be inserted, make sure before selecting which during insert row/column shift terminology has been checked.
Step 4: Right-click on another empty cell where you want to duplicate the same content, then choose “Paste.”
Step 5: Select Special and Choose Insert Copied Cells
Step 6. Repeat these steps for 2-3 times
How to Swap Columns in Excel
Column swapping in Excel seems like a hectic task. Well, now it has been made a bit simple because of some new methods by which you can just swap the columns and do your need full work more efficiently. In this article, you will learn how to drag columns and how to move them. If you extensively use Excel tables in your daily work, you know that whatever logical and well-thought-out a table’s structure is, still you have to reorder your columns and credentials every now and then.
Table of Content
- How to Swap Columns in Excel
- How to Drag Columns in Excel
- How to Move Several Columns in Excel
- How to Swap Columns by Dragging Several Columns Using the Mouse
- How to Swap Columns Using Cut and Paste Columns Individually
- How to Swap Multiple Columns By Copying, Pasting, and Deleting in Excel
- How to Re-arrange Columns with Column Manager
- How to Swap Columns in Excel Shortcut