To flip a list or table upside down in Excel, reverse the order of its rows: add a helper column with row numbers, then sort that column from largest to smallest. In Microsoft 365, you can also use a formula such as =SORTBY(A2:C4,SEQUENCE(ROWS(A2:A4)),-1) to display the rows in reverse order without changing the source data.
What flipping data upside down means
Most people asking how to flip Excel data upside down mean they want the last data row to become the first, the row above it to become second, and so on. For example, a list entered as Monday, Tuesday, Wednesday becomes Wednesday, Tuesday, Monday. The values within each row stay together; only the row order changes.
Excel does not have a single Reverse Rows command for a worksheet range. Sorting by a temporary sequence number is the dependable general method. A formula or Power Query can produce the same result in a different way. If by upside down you mean turning the letters or the whole worksheet image upside down, that is a different task: reversing rows does not rotate text or cells.
Reverse rows with a helper column
This method works in Microsoft 365 and older desktop versions of Excel, and is suitable for ordinary ranges and tables. First make sure every record is on one row and that any column headings are separate from the records.
- Insert a blank column beside the data and give it a clear heading, such as Original order.
- Enter 1 beside the first data row, 2 beside the next, and continue until every row has a number. For a long list, enter the first two numbers, select both cells, and drag the fill handle down to extend the sequence.
- Select the entire table or range, including all its data columns and the helper column. Do not select just the helper numbers.
- Choose Data > Sort. If Excel asks whether to expand the selection, choose to expand it so each row remains intact.
- In the Sort dialog, choose the helper-column heading under Sort by and select Largest to Smallest. Confirm that My data has headers is checked if your selection includes headings.
- Remove the helper column if you no longer need it.
For example, suppose A1:C4 contains headings Date, Item, and Qty, followed by 3/1, Apples, 12; 3/2, Pears, 8; and 3/3, Plums, 15. Number the three records 1, 2, and 3. Sorting the whole range by that helper column from largest to smallest puts the Plums row first, Pears second, and Apples last. Each date, item, and quantity stays together.
Use a reversing formula in Microsoft 365
A dynamic-array formula is useful when you want a reversed view while leaving the source range untouched. It spills the results into adjacent cells and updates when the referenced cells change. The SORTBY and SEQUENCE functions are available in Microsoft 365 and Excel 2021 or later.
With the three-column example in A2:C4 and no headings included in that range, enter this in an empty cell outside the source data:
=SORTBY(A2:C4,SEQUENCE(ROWS(A2:A4)),-1)
It returns the original third row first, then the second, then the first: 3/3, Plums, 15; 3/2, Pears, 8; and 3/1, Apples, 12. The -1 argument requests descending order for the generated sequence. Keep the spill area clear; if a cell in the output area is occupied, Excel displays a spill error. The formula does not include headings, so copy the headings above the result or include them separately.
This is a view, not a rearrangement of the source. If other formulas need to refer to the reversed output, point them to the spilled result. Do not type into the cells where the result spills, because those cells are controlled by the formula in its top-left cell.
Keep headings, rows, and records together
The most damaging mistake is sorting only one column. If you sort dates or helper numbers without the corresponding names, quantities, and other fields, the worksheet can show combinations that never belonged together. Select the complete data block before sorting, or choose Expand the selection when Excel prompts you.
Leave the header row out of the numbered records. If headings are accidentally included in the sort, a heading may move into the middle of the data. In the Sort dialog, mark My data has headers when appropriate, and confirm that the Sort by field shows the helper-column heading rather than the first data value.
Also check for blank rows, merged cells, and data immediately beside the range. Blank rows can make Excel detect only part of a list; merged cells can prevent sorting; and adjacent content may be included unexpectedly. A formatted Excel table can make the data boundary clearer. To make a table, select the data and use Insert > Table, checking that the table has headers when it does. Keep the helper column inside the table so it sorts with the records.
Reverse data with Power Query
Power Query is a good option for a repeatable import or transformation. Unlike a one-time sort, the query can be refreshed when its source changes, and the original source can remain as it was. In Excel for Microsoft 365 on Windows, select a cell in the data and choose Data > From Table/Range. If the range is not already a table, Excel prompts you to create one.
- In the Power Query Editor, choose Add Column > Index Column > From 1.
- Open the filter or sort menu on the new Index column and sort descending.
- Remove the Index column if it is not needed in the result.
- Choose Home > Close & Load to return the output to Excel.
The query sorts by the index created in the source order, so the last source record becomes the first output record. If you later refresh the query, it reads the source again and applies the same steps. Power Query labels and available connectors can vary by Excel edition and platform; on Mac, check the Data tab for the Power Query import and query tools available in that installation. For a small list that needs changing only once, the helper-column sort is usually simpler.
Choose the method that fits the job
- Helper column: Use this for a one-time change, compatibility with older Excel, or when you want the data physically reordered in place. Keep a copy first if the original order matters.
- Dynamic-array formula: Choose this for a live reversed display that should update as its source values change. It requires a version with SORTBY and SEQUENCE and enough empty cells for the result.
- Power Query: Choose this for repeatable data preparation, especially when the list is imported or refreshed regularly. It produces a query result rather than sorting the original cells in place.
There is no special cost to these built-in approaches beyond having an Excel version that includes the relevant feature. The practical trade-off is whether you need a permanent reorder, a live formula result, or a refreshable transformation.
Upside down is not the same as transpose
Reversing rows changes vertical order; transposing swaps rows and columns. For instance, a three-row list becomes a three-column list when transposed, but its sequence is not necessarily reversed. To transpose a copied range, use Home > Paste > Transpose from the Paste options, or use Paste Special and select Transpose. That is useful for changing layout, not for putting the bottom record on top.
Likewise, Excel can change the orientation of text in cells, but that does not flip the data order. Select the cells and use Home > Alignment > Orientation to choose a text direction. Rotating text may help fit a narrow heading; it will not reverse the records or turn a worksheet upside down.
Common problems and fixes
- Rows become mismatched: Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then repeat the sort with the entire data block selected.
- The heading moves with the records: Undo, select the data including its heading, and mark My data has headers in the Sort dialog. Alternatively, select only the data rows and make sure the range excludes the heading.
- The formula returns a spill error: Clear cells in the intended output area and check that the output does not overlap the source range or a merged cell.
- The result looks unchanged: Check that the helper sequence increases from top to bottom and that the sort order is Largest to Smallest, not Smallest to Largest.
- Dates or numbers sort oddly: Some entries may be stored as text. Check their cell values and formats before sorting; a text date may sort alphabetically rather than in chronological order.
Sorting is reversible with Undo immediately afterward, but later edits can make restoring the old arrangement difficult. If preserving the original order is important, duplicate the worksheet or save a separate copy before changing it. This is especially helpful when the data is a log, an imported record, or a list whose original sequence carries meaning.
Frequently Asked Questions
Can Excel reverse rows without a helper column?
Yes. In Microsoft 365 or Excel 2021 and later, use a SORTBY formula with SEQUENCE to create a reversed spill result. The helper-column method is more compatible and changes the selected data in place.
Can I flip only one column upside down?
You can sort a single column by itself, but do that only when its values are independent. If the column is part of a table of records, sort the entire table so the other fields remain attached to the correct values.
How do I reverse rows but keep the header at the top?
Exclude the header from the numbered data rows, then sort the complete range with the header recognized in the Sort dialog. With a formula, reference only the data rows and place or copy the headings above the spilled result.
Does flipping data upside down rotate the text?
No. Reversing row order changes which record appears first. To change text direction, select the cells and use Home > Alignment > Orientation instead.
Will the formula update when I add another row?
It updates when values in its referenced range change, but a fixed reference such as A2:C4 does not automatically include a new row entered beneath it. Use an appropriately sized range or an Excel table-based setup if the source will grow, and verify the formula includes the added records.
Related
- Excel Data Validation List: Can You Select Multiple?
- Excel Data Validation List: Remove Duplicates
- Excel Data Validation List Search: Setup and Fixes Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Double Space in Word for the Web, Step by StepTo double-space text in Word for the web, select the text, then choose Home > Line and Paragraph…
- Microsoft Excel CSV Import: Steps, Settings, and FixesTo import a CSV file into Microsoft Excel for Microsoft 365 on Windows, select Data > From Text/CSV,…
- Create a Fillable Template in Word: Step-by-StepTo create a fillable template in Word, turn on the Developer tab, add content controls such as text…
- Excel to PowerPoint Link: How to Keep Slides UpdatedTo create an Excel-to-PowerPoint link in Microsoft 365 for Windows, copy the cells or chart in Excel, then…
- Copy Paste in Excel: Keep Column Widths When PastingIn Excel for Microsoft 365 on Windows, copying cells does not normally copy their column widths. To match…
- Excel Column to Comma-Separated List: Easy MethodsIf your values are in A2:A20, enter =TEXTJOIN(", ",TRUE,A2:A20) in an empty cell to turn the column into…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.