How to swap positions of two columns in excel

How to swap the positions of two excel columns: First open the excel table file; then move the mouse to cell B1, hold down the left button and drag down to cell B11; then move the mouse to cell B The right edge of the selected part of the column, and then hold down the Shift key; finally, hold down the left mouse button, move the mouse to the right edge of column C, and then release the left mouse button.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

For the convenience of explanation, we first enter part of the data, and now replace the data in the BC two columns.

We move the mouse to cell B1, hold down the left button and drag down to cell B11, that is, select the column data that needs to be changed.

Move the mouse to the right border of the selected part of column B. At this time, the mouse changes to a cross arrow, and then hold down the Shift key.

Hold down the left mouse button and move the mouse to the right edge of column C. A vertical indicator will appear.

Note, it is not a horizontal indicator.

# Release the left mouse button so that the data in the two columns BC can be quickly interchanged.

In addition, we can also click on the column label, press ctrl x to cut, and press ctrl v on other blank columns to paste. This makes it easy to swap.

For example, we first cut and paste column B to column E, and cut and paste column C to column F. This leaves column BC empty, and then puts the data in as needed.

[Recommended learning: Excel tutorial]

The above is the detailed content of How to swap positions of two columns in excel. For more information, please follow other related articles on the PHP Chinese website!