How To Use Reverse List In Excel

Oct 27, 2020 • edited Oct 30, 2020

How To Use Reverse List In Excel

This article teaches you how to reverse a list in Excel. For example, we want to reverse the list in column A below.

1. Enter the value 1 into cell B1 and the value 2 into cell B2.

2. Select the range B1:B2, click the lower right corner of this range, and drag it down to cell B8.

Add List

3. Click any number in the list in column B.

4. To sort in descending order, on the Data tab, in the Sort & Filter group, click ZA.

Sort in Descending Order

Result. Not only the list in column B, but also the list in column A has been reversed.

Reversed List in Excel

#Tutorial#How To#Data Analysis#Sort

How To Use Regression Analysis in Excel

How to Use Sensitivity Analysis In Excel