Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How can we paste copied data in Excel in reverse order?

It is related with copy and pasting of selected data in reverse form. For instance if I copy data range from A1:A then data in this range should be paste in reverse order on new range.

user-image
Question added by Mazhar Ahmed , Software Enginner , Xebia
Date Posted: 2017/10/05
أسامة الجغيمان
by أسامة الجغيمان , Sr Customer Services Rep , Saudi Electricity Company

Click the Data Sort Z to A

Ghulam Ali Raza  Jaffri
by Ghulam Ali Raza Jaffri , Career Trainer , Amal Academy

In an empty column, placed in the number one for the first. Drag 1 right all the way down to create a listing of numbers in growing order (press Cntrl and drag down) Turn on the car clear out out for the listing of information to be reversed.

Firas Shahadi
by Firas Shahadi , Human Resources Director , SAUDI UNION

Great question

but what you mean by reverse order?

if you mean to sort in reverse order, you can sort (by columns or Rows) them by creating the new column and give that column the numbers of the order you would like to perform.

 

More Questions Like This