How to swap the contents of two cells

How to swap the contents of two cells: 1. Open the Excel file and click on one of the cells whose contents need to be swapped; 2. Move the mouse to the edge of the cell, and the cursor changes to a four-way Arrow; 3. Hold down the Shift key, hold down the left mouse button and drag the cell to another cell to swap the contents of the two horizontal cells.

The operating environment of this tutorial: Windows 10 system, Microsoft Office Excel 2016 version, Dell G3 computer.

How to swap the contents of two cells?

1. First open the Excel file and click on one of the cells whose contents need to be exchanged.

#2. Move the mouse to the edge of the cell, and the cursor changes to a four-way arrow.

3. Hold down the Shift key and hold down the left mouse button to drag the cell to another cell. The dotted line marked in red in the picture below becomes vertical. .

#4. Finally, release the mouse to swap the contents of the two horizontal cells (if there are two cells in one column, the dotted line should be horizontal).

Recommended study: "Excel Tutorial"

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