Reverse order of rows in Excel

"Insert a column A, then put a counter in that row (1, 2, 3, 4). Then sort the spreadsheet on column A in descending order.

To expand on DLux' answer:

Instead of manually adding the 1, 2, 3, 4, you can:

Enter 1 on the first row, then a 2 on the cell directly below it
Select both cells
Move your mouse cursor to the bottom right corner of the cell that contains the ""2"". The cursor should change into a + sign.
Click and drag downwards. Excel will fill in the cells you drag over, and increment the values automatically.

This'll save you some time if you've got a large number of rows to reverse."

"A simple way to reverse the order of a row or a column:

If you have row elements of 1,2,3,4 then you want them to be in a row, but in the order 4,3,2,1 – like transposing, but 180 degrees instead of 90. To reverse a row use this:

=INDEX($I$4:$L$4,1,COUNT(I$4:$L$4))

The range to be reversed is I4:L4. Note that the first column in the count is not anchored so this value gets walked down from 4 to 3 to 2 to 1 as you copy the cell to the right.

To reverse the order of elements in a column you have:

=INDEX($I$4:$I$8,COUNT($I4:$I$8),1)

Now you see that the first row element is not anchored so the row count will decrease as the cell is copied down."