Home Computer Repair How To Swap Two Columns in Microsoft Excel

How To Swap Two Columns in Microsoft Excel

82

If you frequently use Excel tables, you may have to rearrange your columns from time to time. Sometimes you need to restructure some data, and other times you’ll want to place certain columns alongside each other for comparison.

This article will show you how to easily change the position of your Excel columns with just a few clicks.

Swap Two Columns with the Drag-And-Drop Method

If you try to simply drag the column from one place to another, Excel will only highlight the cells instead of moving them. Instead, you should click on the right location on the cell while holding the Shift key.