Home  >  Article  >  Topics  >  How to swap upstream and downstream data in excel

How to swap upstream and downstream data in excel

尚
Original
2019-07-22 15:31:2838066browse

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;

How to swap upstream and downstream data in excel

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

How to swap upstream and downstream data in excel

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.

How to swap upstream and downstream data in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn