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

  • Thread starter Thread starter yoyudax
  • Start date Start date
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?
 
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
 
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
 
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

Excel Excel spreadsheets opening at top instead of bottom. 4
Reversed Array 9
Reverse Order 2
Reverse Order 3
How do I reverse the order of a column or row? 3
Reversing the order of data separated by commas within a cell? 5
Column Order Reversal... 3
paste in Reverse Order 3

Back
Top