Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
How can I sort SSNs in Terminal Digit Order using Excel? | Excel Worksheet Functions | |||
How do I set the order of calculation of Data Tables in Excel? | Excel Worksheet Functions | |||
Excel countif based on size of numbers in one column in Access | Excel Worksheet Functions |