Jump to a step (3)
Reports and exports often list the newest month first. If you want to add each new month at the bottom, you need the whole table flipped, and cutting and pasting rows one at a time is slow and error-prone.
Excel has no single reverse button, but a helper column does the job. Number the rows 1, 2, 3 and so on, then sort that column in descending order and every row flips.
What you need
- Microsoft Excel (desktop or Excel for the web)
- A table or range of data with no blank rows
Step by step
0 of 3 done-
01
Add a helper column
Next to your data, add a new column and name it
Reverse. In the video the data hasMonth,YearandVisitorscolumns running from January 2024 back to November 2022. -
02
Number every row
Fill the helper column with 1, 2, 3 and so on down to the last row. With 15 data rows, fill 1 to 15. Type the first two numbers and drag the fill handle down to fill the rest quickly.
-
03
Sort the helper column from largest to smallest
Select a cell in the
Reversecolumn and sort it Largest to Smallest (descending). Excel sorts the whole table by that column, so the rows flip and January 2024 ends up at the bottom. You can now add February 2024 below it. Delete the helper column afterwards if you do not need it.
Tips and common problems
- Make sure the sort includes all your columns. If Excel asks, choose Expand the selection so the rows stay together.
- Remove any blank rows first, or Excel may only sort part of the data.
Questions
How do I reverse the order of rows in Excel?
Add a helper column numbered 1 to N next to your data, then sort that column Largest to Smallest. The whole table flips.
Is there a formula to reverse a list in Excel?
In Excel for Microsoft 365, =SORTBY(A2:C16,ROW(A2:C16),-1) returns the range in reverse order without changing the original data.
