This is the easiest method to reverse a list in Excel. You just have to create a new column containing the numbers in ascending order and use this column to reverse the list. Let’s see how to do that.

Excel gives the answer 10. If you have a mathematical background, you’ll know why Excel gives a different answer to such a simple calculation — and why, technically, Excel is right. If you don’t have ...