How to swap upstream and downstream data in excel

The method of exchanging upper and lower row data in excel is as follows:

1. Open the Excel table document. In order to demonstrate well, first create a blank table Edit any text content within;

2. After editing the text content, if you want to exchange data between A2 and A3, first select the cell of A2;

3. After selecting the cell A2, place the mouse over the cell. When a cross-shaped symbol appears, hold down the "shift" key and drag it to the cell A3. The data exchange can be completed.

Recommended: "Excel Basic Tutorial"

The above is the detailed content of How to swap upstream and downstream data in excel. For more information, please follow other related articles on the PHP Chinese website!