Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reverse the order of a column or row?
How do I reverse the order of a column or row without sorting the cells in
ascending or descending order? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reverse the order of a column or row?
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 How do I reverse the order of a column or row without sorting the cells in ascending or descending order? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reverse the order of a column or row?
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 "LP" wrote in message ... How do I reverse the order of a column or row without sorting the cells in ascending or descending order? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reverse the order of a column or row?
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 On Thu, 30 Oct 2008 15:16:10 -0700, LP wrote: How do I reverse the order of a column or row without sorting the cells in ascending or descending order? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reverse chart column and row order | Charts and Charting in Excel | |||
Reverse order of numbers in a column | Excel Discussion (Misc queries) | |||
Reverse column order with a macro | Excel Discussion (Misc queries) | |||
Reverse order in column | Excel Worksheet Functions | |||
How can I reverse the order of a column of numbers . . . | Excel Discussion (Misc queries) |