How do I reverse the order of a column or row?

  • Thread starter Thread starter LP
  • Start date Start date
L

LP

How do I reverse the order of a column or row without sorting the cells in
ascending or descending order?
 
Maybe you may add a column with a series of values 1, 2, 3 ,4 and so
on. Then sort the two column, sorting on the added column in descending
order. Eventually, delete the added column.
Regards.
Daniel
 
Use a help column/row and put 1,2,3 etc in the help column, then select both
column and sort descending by the help column, then remove the help column

--


Regards,


Peo Sjoblom
 
Without sorting but using a helper column and assuming you want to reverse
column A........

In the helper column enter =INDEX($A$1:$A$26,26-(ROW(A1)-1))

Copy down to row 100

To reverse row 1..............

=INDEX(1:1,26-(COLUMN(A1)-1))

Adjust ranges to suit


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reverse Order 1
Excel 2002 Worksheet: Can I sort the columns ? 3
iTunes Library text file imported into Excel 4
Sorting in Excel 2
how do i flip a column round in excel? 4
Reverse Order 3
The last two entries in a range won't sort 2
how to paste the date or the row in the reverse order 2

Back
Top