
1. Create a new column as a sorting basis, such as the descending index column;

2. Select all content and click [Data], [Sort] options;

3. Set keywords and select the sorting basis;
4. Click the [OK] button.

You can see that the original data has been flipped up and down.

Recommended tutorial:excel tutorial
The above is the detailed content of How to flip a column of data up and down in excel. For more information, please follow other related articles on the PHP Chinese website!