Filord is a powerful Excel utility designed to save you time and effort on routine tasks - find unique and duplicate values, reverse order of rows, get subtotals and more. Free installation, seven built in functions, no learning and skills required – get your issue solved in 15 minutes from now on.
Download (1.5 Mb)
Reverse Sorting in Excel file
This function reverse order of rows in the file, so the first row becomes the last, the last row becomes the first, second row becomes second-last, second-last becomes second, etc.
Example:
Initial table:
| A | B | C | |
| 1 | a | 212 | 10 |
| 2 | b | 475 | 15 |
| 3 | c | 585 | 20 |
| 4 | d | 585 | 35 |
| 5 | e | 990 | 25 |
| 6 | f | 500 | 15 |
Output table:
| A | B | C | |
| 1 | f | 500 | 15 |
| 2 | e | 990 | 25 |
| 3 | d | 585 | 35 |
| 4 | c | 585 | 20 |
| 5 | b | 475 | 15 |
| 6 | a | 212 | 10 |
learn more
We want you to find this page by the following keywords:
how to swap lines, excel swap rows, reversing order of rows in excel, reverse order of rows in the file, swap selected rows, reverse selected rows in MS Excel
how it works:
load file(s)
open Function Wizard
choose Sorting function
specify file number
press Run button to get the results
load file(s)
open Function Wizard
choose Sorting function
specify file number
press Run button to get the results
