Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reverse the order of a list in Excel?
I have a large list which covers 4 fields. I need to reverse the order
leaving all fields intact. How do I accomplish this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reverse the order of a list in Excel?
On Sep 3, 11:55*pm, yoyudax wrote:
I have a large list which covers 4 fields. *I need to reverse the order leaving all fields intact. *How do I accomplish this? Add a fifth column. Put 1 in the first row, 2 in the second then select both cells and fill down to the bottom of the list. Sort that column in descending order to reverse the table's order. Ken Johnson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reverse the order of a list in Excel?
there is is this functionality in the ASAP free add-in, plus lots more.
Google ASAP-Utilities. Very recommended. "Ken Johnson" wrote in message ... On Sep 3, 11:55 pm, yoyudax wrote: I have a large list which covers 4 fields. I need to reverse the order leaving all fields intact. How do I accomplish this? Add a fifth column. Put 1 in the first row, 2 in the second then select both cells and fill down to the bottom of the list. Sort that column in descending order to reverse the table's order. Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL - PASTE SPECIAL COULD HAVE AN OPERATION TO REVERSE ORDER | Excel Worksheet Functions | |||
Reverse plot order in Excel charts | Charts and Charting in Excel | |||
How do I reverse page order in excel workbook? | Excel Discussion (Misc queries) | |||
How do I reverse the row order in Excel, not based on content? | Excel Discussion (Misc queries) | |||
How do I reverse the order (sequence) of a column of data in Excel | Excel Worksheet Functions |