To reverse a range in Excel, it is fairly an easy job with SORTBY if you have dynamic array functions
=SORTBY(A2:A10, ROW(A2:A10), -1)
If you are still on drag and drop versions, here is the formula for drag and drop (Put this formula in a cell and drag it down)
=INDEX($A$2:$A$10, MAX(ROW($A$2:$A$10)-ROW($A2)+1))
The Excel file used can be downloaded from here – Tips & Tricks 197 – Reverse a Range