how can you reverse the order of a set of column data in excel?

Solution 1:

 

In the next column enter numbers 1 thru XXXXX (one per row), select both columns and sort descending by the second column

 

Solution 2:

 

Try the below formula and copy down as required

Parse formula below to cell B1, then expand to B7

=INDEX($A$1:$A$7,ROWS($A$1:$A$7)-ROW(A1)+1)