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

Centered text that does not stay centered 0
Merge Excel file into Word Document 3
Skipping the first row in a repeated header 0
Need some PWA help 0
Merging from an Excel file with graphics 1
Insert new photo album - photos are in reverse order 0
Outlook Web - Sorting Calendars by Alphabetical order? 0
Add additional information to excel form after original data entry 0

Top