How to Flip the Order of Cells in Excel Without Re-typing

To flip cells in Excel, add a helper column containing 1, 2, 3, and so on, select the entire list or table, then sort the helper column from largest to smallest. This reverses the order while keeping related row data together. If you have Microsoft 365 or Excel 2021, you can also use SORTBY to create a reversed copy without changing the original.

Flipping order means reversing the sequence—for example, turning Monday, Tuesday, Wednesday into Wednesday, Tuesday, Monday. It does not mean sorting alphabetically or numerically. Before you begin, decide whether you want to reverse one column, a whole table of records, or the values across a row. The distinction matters: sorting one column by itself can separate names from their associated dates, amounts, or other details.

What You’ll Need

An Excel workbook with the cells you want to reverse. Save a copy first if the order is important or the workbook contains linked formulas.
A blank column or row for temporary helper numbers if you are using the sort method. You can remove it after the reversal.
Excel for Microsoft 365 or Excel 2021 if you want to use the SORTBY formula method. The helper-number method works in older desktop versions too.

Step-by-Step

Identify the range and what must stay together. If you have a list of names with dates or values in neighboring columns, treat each record as a full row. Include all related columns in the range you will sort. For example, if names are in A2:A6, dates are in B2:B6, and scores are in C2:C6, the range to reverse is A2:C6, not just A2:A6. If you only need to reverse a standalone list, select that one column.
Add a helper column for a vertical list or table. Use an empty column immediately beside the data, or another blank column that is easy to include in the selection. Give it a heading such as Order if your data has headers. Enter 1 beside the first record, 2 beside the next, and continue until every record has a number. Do not number the header row. For example, beside five records in rows 2 through 6, put 1 through 5 in the corresponding helper cells.
Select the complete data range, including the helper values. For a table with headers in row 1 and records in rows 2 through 6, select all the columns containing the headers, records, and helper column. Selecting the entire table is the key to preserving each record. If Excel asks whether to expand the selection, choose the option that expands it so adjacent information moves along with the sorted data. Avoid selecting entire worksheet columns unless that is genuinely what you want to sort.
Open the sort controls. In Excel for Microsoft 365 on Windows, choose Data > Sort. If your selection has headers, make sure My data has headers is checked in the Sort dialog. In Sort by, choose the helper-column heading, such as Order. For a range with no headers, select the appropriate column letter or column number instead.
Sort the helper values from largest to smallest. Set Sort On to Cell Values and choose Largest to Smallest in the Order box. Click OK. The record that had the highest helper number should now be first, and the record that had 1 should be last. Check one or two rows to confirm that related details, such as dates and scores, moved with their names.
Remove the helper column if you no longer need it. Once the order is correct, you can delete the helper column. Select the helper column cells or its worksheet column and use Home > Delete > Delete Sheet Columns, taking care not to delete any original data. If you prefer, keep the helper values as a visible record of the original sequence. Save the workbook after checking the result.
For cells arranged across a row, use a helper row. Put sequential numbers above or below the values, select the values and helper numbers together, and choose Data > Sort > Options. In the Sort Options dialog, select Sort left to right and confirm. In the main Sort dialog, sort by the row containing the helper numbers, using Largest to Smallest. The values and their corresponding columns will reverse from left to right. Include any other rows that must stay aligned with those columns in the selected range.

The same sort controls are available in current Excel for Mac desktop editions, though dialog placement and some labels can vary slightly. In Excel for the web, the regular helper-column sort is suitable for a vertical range; if you cannot find the left-to-right sort option for a horizontal layout, use the formula method below or open the workbook in desktop Excel.

Formula option for a vertical range: With the original values in A2:A6 and an empty output area beginning at C2, enter =SORTBY(A2:A6,ROW(A2:A6),-1) in C2. In Microsoft 365 or Excel 2021, the formula spills into the cells below and returns the values in reverse row order. If A2:A6 contains Red, Blue, Green, Gold, Purple, the output is Purple, Gold, Green, Blue, Red. Keep the output area clear so the results can spill. This method creates a reversed copy; it does not rearrange the original cells.

Formula option for an entire table: With records in A2:C6 and an empty output area beginning at E2, enter =SORTBY(A2:C6,ROW(A2:A6),-1) in E2. The result is the same set of records in reverse row order, with each row kept intact. Use a sufficiently large blank output area for the three columns and five rows of results. If you have headers, copy or type the headers above the formula output separately; this formula sorts the specified data rows, not the header row.

Formula option for a horizontal sequence: With values in A1:E1 and an empty output area beginning at A3, enter =SORTBY(A1:E1,COLUMN(A1:E1),-1) in A3. It returns the values left to right in reverse order. If several rows of information must remain aligned with those columns, include the whole rectangular data range in the array argument and use the corresponding column numbers as the sort order. The formula examples use SORTBY, which is available in Microsoft 365 and Excel 2021; older versions can use the helper sort instead.

Common Mistakes

Sorting only the visible list column. If neighboring cells contain details for the same record, reversing just one column disconnects the details. Select the full table, including every related column, before sorting.
Sorting the helper column in the wrong direction. Smallest to Largest preserves the original order when helper numbers increase down the sheet. Choose Largest to Smallest to reverse it.
Including a header as if it were a record. A header such as Name or Order should stay at the top. Mark My data has headers in the Sort dialog, or select only the record rows and their helper values.
Leaving gaps or duplicate helper numbers. Duplicate numbers can make the order of those tied records unpredictable, while gaps can make checking the sequence harder. Use one unique, consecutive number for each record.
Putting a spill formula over existing data. Dynamic-array formulas need an empty output area. If cells block the spill range, Excel shows a spill error instead of displaying the full reversed result.
Expecting a formula to replace the source data. SORTBY returns a separate result. If you need the reversed sequence in place, use the helper sort, or copy the formula results and use Paste Special > Values over a destination you have checked.

Tips

Make a backup before sorting if the workbook is complex. Sorting can affect formulas that refer to the records, and a mistaken sort may be difficult to spot in a large table.
Use a temporary helper column with a clear heading so it is easy to choose the correct sort field. After sorting, check the first and last records against the original order.
If the original sequence has meaning—for example, it represents the order that items were entered—keep the helper numbers as an Original Order field. You can sort by that field later to restore the initial sequence.
When using a formula, put the result on a new worksheet or well away from the source. This makes comparison straightforward and avoids accidentally overwriting the cells being referenced.
For a table with filters, make sure the sort applies to the full table and all records, not merely the currently visible cells. Review any active filters before deciding whether the result should reverse only visible records or the complete list.
On Windows, Ctrl+Z undoes a sort immediately if you notice a mistake. On Mac, use Command+Z. Do not rely on undo after making several unrelated edits; it is safer to restore from the saved copy if needed.

Troubleshooting

The rows did not reverse. Check that you sorted the helper field and chose Largest to Smallest. If the result is still unchanged, confirm that the helper values increase in the same direction as the original records and that the correct range was selected.

Names and details no longer match. Undo at once with Ctrl+Z on Windows or Command+Z on Mac. Repeat the sort with the complete table selected. If Excel prompted you to expand the selection and you chose to continue with the current selection, that may have sorted only one column.

The header moved into the data. Undo the sort, then select My data has headers in the Sort dialog. Alternatively, select only the data rows and helper values, leaving the header row out of the selected range.

The formula returns a spill error. Clear cells in the expected output area, including cells that look blank but contain spaces or formulas. Make sure the formula is not inside an Excel table, where dynamic-array spilling may be restricted. If your Excel version does not support SORTBY, use the helper-column method.

The formula gives an unexpected sequence. Verify that the formula references exactly the cells you intend to reverse and that the output area is not overlapping the source. For a table, the sort-by range must cover the same number of rows as the data array. Check for hidden rows or blank cells that are part of the referenced range.

The sort options do not match these steps. Confirm that you are using the desktop Excel app and have opened Data > Sort rather than relying on a small filter menu. On Mac, the ribbon and dialog may look different, but the sort direction and range logic are the same. In Excel for the web, use a vertical helper-column sort or open the file in desktop Excel for left-to-right sorting.

Frequently Asked Questions

Can I reverse cells without changing the original list?
Yes. In Microsoft 365 or Excel 2021, use SORTBY in a blank area to create a separate reversed result. The helper sort changes the order of the selected source records, so make a copy first if you need to preserve the original arrangement.

Can I reverse a row from left to right?
Yes. In desktop Excel, add a helper row with increasing numbers, select the relevant range, then choose Data > Sort > Options > Sort left to right and sort the helper row largest to smallest. A SORTBY formula can also return a reversed horizontal copy in supported versions.

Will this work with dates or numbers?
Yes. The helper numbers determine the order, so the original cells can contain dates, numbers, text, or a mixture. Select all related cells together if the dates or numbers belong to other values in the same record.

Does sorting alphabetically flip the original sequence?
No. Alphabetical or numerical sorting orders cells by their contents, not by their original positions. Use the helper numbers to reverse sequence order regardless of what the cells contain.

Can I reverse only the visible rows in a filtered list?
Be cautious: sorting a filtered table may reorder the underlying records, not create a separate reversal of only the visible items. If you need a particular filtered subset reversed, copy that subset to a new range, add helper numbers there, and sort the copy.

How do I restore the original order later?
If you kept the helper numbers, sort the full table by that field from Smallest to Largest. If you removed the helper column and saved the reversed order, use Undo if it is still available or restore a saved copy of the workbook.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.