Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gimbalman
 
Posts: n/a
Default How do I reverse the row order in Excel, not based on content?

I need to flip an Excel worksheet containing many rows and columns 'top-to
tail', so that, for example, row 1 becomes row 1000 and vice-versa. This does
not fit the usual 'sort' criteria, as cell content is not relevant to the
order. Am I missing a simple trick here?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete at Sappi Fine Paper
 
Posts: n/a
Default How do I reverse the row order in Excel, not based on content?

Just insert a new column and fill it with the numbers 1 to 1000 (or however
many rows you have). There are several quick ways of doing this. Then sort
(descending) by that column. Then delete that column.

"Gimbalman" wrote:

I need to flip an Excel worksheet containing many rows and columns 'top-to
tail', so that, for example, row 1 becomes row 1000 and vice-versa. This does
not fit the usual 'sort' criteria, as cell content is not relevant to the
order. Am I missing a simple trick here?

  #3   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default How do I reverse the row order in Excel, not based on content?

Add a column immediately next to the data, with the numbers 1, 2, ....
Then sort descending.

HTH
Kostis Vezerides

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
How can I sort SSNs in Terminal Digit Order using Excel? postitnote Excel Worksheet Functions 19 June 10th 05 09:25 PM
How do I set the order of calculation of Data Tables in Excel? Charles Easton Excel Worksheet Functions 1 April 30th 05 10:35 PM
Excel countif based on size of numbers in one column in Access Kristjan_Thor Excel Worksheet Functions 3 March 17th 05 10:21 PM


All times are GMT +1. The time now is 04:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"