Click "OK" to reverse the column order. Advertisement. Article continues below this ad. More For You. How to Calculate a Trimmed Mean in Excel. How to Calculate a Trimmed Mean in Excel.

Once you have the list in reverse order (Figure I), you have a bit of cleanup left: You can remove column 1 and the table. If you might need to resort at a later date, you repeat these steps.

Every now and then I have to reverse the order of a long list in Excel that is not in alphabetical or numerical order—a tedious job. Do you know of. ... and the whole list, in reverse, will fill the ...