How do I reverse the order of a list in Excel?

Y

yoyudax

I have a large list which covers 4 fields. I need to reverse the order
leaving all fields intact. How do I accomplish this?
 
K

Ken Johnson

I have a large list which covers 4 fields.  I need to reverse the order
leaving all fields intact.  How do I accomplish this?
Click to expand...

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
 
M

Mathew P Bennett

there is is this functionality in the ASAP free add-in, plus lots more.
Google ASAP-Utilities. Very recommended.
I have a large list which covers 4 fields. I need to reverse the order
leaving all fields intact. How do I accomplish this?
Click to expand...

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
 

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

Excel Excel spreadsheets opening at top instead of bottom. 4
Reverse Order 2
Reverse Order 3
How do I reverse the order of a column or row? 3
paste in Reverse Order 3
Reversed Array 9
how to paste the date or the row in the reverse order 2
Reverse Time Series Order 4

Top