How to Paste Backwards in Excel: Reverse Cell Order

How-to basics · Updated November 21, 2026

To paste a list backwards in Excel for Microsoft 365, enter =SORTBY(A2:A6,ROW(A2:A6),-1) in an empty cell, replacing A2:A6 with your source range. Copy the reversed results, then choose Home > Paste > Values where you want the fixed copy. Excel has no built-in “paste backwards” command, so this formula creates the reverse order for you.

This is useful when you need the last item first, want to reverse a set of dates, or need to rearrange records without manually moving each row. The steps below cover a vertical list and a table of records, plus a separate formula for reversing cells across a row. Work in an empty area first so the results do not overwrite your source data.

What You’ll Need

  • A workbook open in Excel for Microsoft 365 on Windows. The SORTBY and SEQUENCE formulas below also work in Excel 2021 and later versions that include these functions.
  • A clear destination area with enough empty cells for the reversed results to spill into. If the cells are not empty, Excel may show a #SPILL! error.
  • The range you want to reverse, identified without its header if it has one. For example, use A2:A6 for five list items and leave a heading in A1.
  • Optional: a separate destination location if you want to keep the original and the reversed copy side by side.

Step-by-Step

  1. Identify the cells to reverse. Select the data range mentally or note its address. For a list in A2:A6, the first item is in A2 and the last is in A6. Do not include a heading such as “Date” or “Name,” or the heading will be treated as one of the items and moved to the bottom.
  2. Choose a blank starting cell. Click the cell where the first reversed item should appear. If your source is A2:A6, you could start in C2, provided C2:C6 are empty. Leave room for the entire output range; the formula returns five results and spills down five cells.
  3. Enter the reverse-order formula. Type =SORTBY(A2:A6,ROW(A2:A6),-1) and press Enter. Replace both references to A2:A6 with your actual source range. The first argument is the values to return; ROW(A2:A6) supplies their original row numbers; -1 tells Excel to sort those row numbers in descending order. For example, if A2:A6 contains Monday, Tuesday, Wednesday, Thursday, Friday, the spilled result is Friday, Thursday, Wednesday, Tuesday, Monday.
  4. Check that the output is complete and correctly ordered. Make sure the last source item is at the top of the result and the first source item is at the bottom. Confirm the output has the same number of cells as the source. If the source is a table with several columns, use the table version in the next step rather than reversing only one column.
  5. Reverse complete records when needed. If each row contains related details, such as a date, name, and amount in A2:C6, enter =SORTBY(A2:C6,ROW(A2:A6),-1) in a blank area with room for five rows and three columns. This sorts the whole row range by its original row number, keeping the values in each record together. Do not reverse each column independently, or names and their associated details can become mismatched.
  6. Copy the formula results. Select the full spilled result, not just the cell containing the formula. One way is to select the formula cell, then drag across or down to cover the whole output. You can also click the formula cell and use the spill-range selection shortcut Ctrl+A only when it selects the intended output; check the highlighted cells before copying. Press Ctrl+C on Windows.
  7. Paste as fixed values if that is what you need. Click the destination cell, open the Home tab, choose the Paste dropdown, and select Values. This pastes the displayed items without leaving the SORTBY formula linked to the original list. If you want the reversed result to update when the source changes, keep the formula instead of replacing it with values.
  8. For a horizontal row, reverse the columns instead. If the values are in A1:E1, choose an empty cell and enter =INDEX(A1:E1,1,SEQUENCE(1,COLUMNS(A1:E1),COLUMNS(A1:E1),-1)). It returns the rightmost cell first and the leftmost cell last. Replace A1:E1 with your row range. Copy the resulting row and choose Home > Paste > Values if you need a static copy.
  9. Remove the temporary formula only after checking the paste. Confirm the destination contains the right order and that any needed formatting is present. Then you can delete the helper formula and its spill range. Avoid deleting the original data unless you are certain the pasted result is complete and correct.

For an alternative that does not rely on SORTBY, add a temporary index beside a vertical list. If your values are in A2:A6, put 1 through 5 in B2:B6, select both columns, and use Data > Sort. Sort by the index column from largest to smallest, then remove the index if desired. This changes the original row order, so copy the data to a spare area first if you need to preserve it.

Common Mistakes

  • Including the heading in the formula range. A header is text like any other cell to the formula, so it can end up at the bottom. Start the range below the header, such as A2 instead of A1.
  • Reversing just one column of a multi-column table. This can separate names, dates, and amounts that belong to the same record. Use the full table width as the first SORTBY argument and use the matching row range as the sort key.
  • Expecting a copied formula to become a permanent copy. A formula result can change when the source changes. Choose Paste > Values when you want the current reversed order to remain fixed.
  • Pasting into a non-empty spill area. A dynamic-array formula needs clear cells for all its results. Move the formula or clear the destination cells; do not erase information you still need.
  • Sorting without selecting the entire record range. When using the index-column alternative, include every related column in the sort. If Excel asks whether to expand the selection, choose the option that expands it so rows stay intact.

Tips

  • Keep the source intact. Put the formula in a different area or on another worksheet. This gives you a chance to compare the reversed list with the original before replacing anything.
  • Use a clear label for the output. Add a note such as “Reversed copy” above the results, outside the formula spill range, so you can distinguish the temporary output from the source.
  • Decide whether the result should update. Keep the formula for a live view that responds to changes in the source. Paste values for a one-time snapshot, such as an export or a list being handed off to someone else.
  • Preserve formatting separately if necessary. Paste Values transfers the results rather than the source formatting. If the destination also needs number formats, borders, or colors, apply those separately or use the appropriate Paste Special option after checking what it will replace.
  • Check blanks and duplicates deliberately. The formulas reverse positions, including blank cells and repeated values. They do not remove duplicates or move blanks to a special location; they simply reverse the source order.

Troubleshooting

  • You see #SPILL!. Select the formula cell and look for a message identifying the blocked cells. Clear those cells or move the formula to an open area. Merged cells in the output area can also prevent a dynamic result from spilling.
  • You see #NAME? or an unrecognized-function message. Your Excel version may not support SORTBY or SEQUENCE, or the function name may be misspelled. Use the temporary index-and-sort method instead. In Excel for the web, the same formulas are available when signed in to a Microsoft 365 account, though the ribbon layout can differ.
  • The result is in the wrong direction. Check that the final SORTBY argument is -1. A sort order of 1 is ascending and would put the original first item at the top. For the horizontal INDEX formula, check that the SEQUENCE step is -1 and that its starting number is the number of columns in the selected range.
  • Only one cell was copied. A dynamic formula has one formula cell and a spill range. Select the whole displayed output before copying. If you only copy the formula cell, pasting it elsewhere may create another formula rather than a fixed list.
  • Rows no longer match after sorting. Undo immediately with Ctrl+Z if possible, then repeat with the entire record range selected. For a formula, make sure the first argument includes all the columns in each record and the row-number range covers exactly the same rows.
  • The Mac shortcut is different. On Excel for Mac, use Command+C to copy instead of Ctrl+C. Formula syntax is the same. Use the Home tab’s Paste options or Edit > Paste Special to choose Values; names and placement of controls can vary slightly by Mac release.

Frequently Asked Questions

Does Excel have a Reverse Paste button?
No. Excel does not provide a standard command that reverses clipboard contents as it pastes. Create a reversed output with a formula or sort by a helper index, then paste the result where you need it.

Can I reverse a list without changing the original?
Yes. Enter the formula in a separate blank area or on another worksheet. The original stays in place, and the formula displays the items in reverse order.

How do I paste the reversed result without formulas?
Copy the full formula output, select the destination, and choose Home > Paste > Values. The destination will contain the current results rather than a formula that refers back to the original range.

Can I reverse a whole table while keeping each row together?
Yes. Use a SORTBY formula whose first argument is the full table range and whose sort-by argument is ROW applied to the same rows. That reverses the record order while leaving the values across each row together.

Will this work for a row that runs left to right?
Yes. Use the INDEX and SEQUENCE formula for a horizontal range shown above. It reverses the column positions, so the rightmost value appears first.

What if my Excel version does not support these formulas?
Use a helper column with sequential numbers, select the complete data range, and sort the helper column from largest to smallest. Make a copy first if you need to retain the original order, and remove the helper column after confirming the result.

Related

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.