Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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 ajoutée par Mazhar Ahmed , Software Enginner , Xebia
Date de publication: 2017/10/05
أسامة الجغيمان
par أسامة الجغيمان , Sr Customer Services Rep , Saudi Electricity Company

Click the Data Sort Z to A

Ghulam Ali Raza  Jaffri
par 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
par 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