Reverse List in Excel

This article will teach you how to create a reverse list in Excel. For example, let’s reverse order the values ​​in the column А (see picture below):

1. Enter the value 1 in the cell B1 and the value 2 into the cell B2.
2. Highlight a range B1: B2, hold its bottom right corner and drag it down to the cell V8.
3. Click on any number from the list in the column B.
4. On the Advanced tab Data (Data) click the button Z-A (Z-A).

Result: We got a reverse list.

Note: Addressed not only a list in a column В, but also a list in a column А.