How to copy and paste data in reverse order in Excel?

There is no built in function to reverse a list of data in Excel. But this can be done in a few simple steps:

  1. In an empty column, put in the number 1 for the first
  2. Drag 1 down to create a list of numbers in increasing order (press Cntrl and drag down)
  3. Turn on the auto filter for the list of data to be reversed
  4. Select “Sort by Descending” on the column of numbers (Column B in this example)

  5. Turn off auto filter
  6. Delete the column of descending numbers

 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>