Lesson#44: A Simple trick to paste in reverse order

Lesson#44: A Simple trick to paste in reverse order
Sometimes it needs to paste a list in reverse then a simple trick should keep in mind. A simple trick to paste in reverse order.

  1. Copy the list and paste it.
  2. Add an extra column beside this column.
  3. Add digits in this column.
  4.  Add filter above as shown in the picture.
  5.  Select the opposite order in which the digit column is. Here I have selected Sort Largest to Smallest.

paste in reverse order
paste in reverse order

paste in reverse order

See also  Lesson#153: How to insert blank rows after every row in sheet, No Formula method

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Leave a Reply

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

*