Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Reverse List in Excel

This chapter teaches you an easy way 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.

Worked Example:   Use Data Form to input, edit and delete records in Excel

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

Worked Example:   Add Outline to Data in Excel

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.

Worked Example:   Filter Data Based on Date in Excel

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

Leave a Reply

Your email address will not be published. Required fields are marked *