How to Reverse Row Order in Microsoft Excel

[Raju Chacha]

I have got a file where each row contains data about a geographic location. The order they are in is from south to north. I now have a need to reverse the order. That is having them now list north to south. Thanks for your help.

[Go!pee]

One easy way is to insert a column to the left of the data input 1 in the first cell, input 2 in the second cell, input 3 in the third cell copy this down so that the number continuously increases. Sort the new column and the original data by the first column in descending order. May be this will help you out.