How to Reverse the Order of Data in Excel
Excel has a Sort button but no Reverse button. Whether you want a list flipped bottom-to-top or a row read right-to-left, here are the working methods — and a one-click one.
Last updated: August 2026
| Before | Reversed | |
|---|---|---|
| Jan, Feb, Mar | → | Mar, Feb, Jan |
| Row 1 … Row 100 | → | Row 100 … Row 1 |
Method 1 — the helper-column sort
- In a spare column next to your data, type
1,2,3… down the rows (drag the fill handle). - Select your data and the helper column, then Sort the helper column Largest to Smallest.
- The rows flip top-to-bottom. Delete the helper column.
Method 2 — SORTBY (Microsoft 365)
=SORTBY(A2:A100, SEQUENCE(ROWS(A2:A100)), -1) spills the range in reverse. Elegant, but it's a formula living in new cells — you'll paste-as-values to make it permanent.
The 1-click way — Tellsheet
Flip reverses your selection with no helper column and no formula. Choose row order (top ↔ bottom) to flip a list, or cells in each row (left ↔ right) to mirror data sideways — something Excel has no built-in command for. Previews before it applies, and is revertable from the change history. Pairs with Transpose and Natural Sort.
Frequently asked questions
How do I reverse a column in Excel?
Helper column numbered 1,2,3… sorted largest-to-smallest, or SORTBY on 365 — or Tellsheet's Flip in one click, no helper column.
How do I flip data left to right?
No native button exists. Flip's "cells in each row" mode reverses left-to-right directly.
Does reversing keep my other columns aligned?
Yes — select the whole table so every column moves together. Flip reverses the full selection's rows as a block.
Is transpose the same as reverse?
No — transpose swaps rows and columns; reverse keeps the shape but flips the order. See the Transpose guide if you need the former.
Related Excel guides
Reverse a list in one click
Flip reverses rows top-to-bottom or cells left-to-right — no helper column, right inside Excel.
Get Tellsheet free See pricing