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

Posted on Posted in Excel Features, Excel Tricks No Comments Tagged with
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#31: Current dynamic calendar for whole Year
About

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 *

*