| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 38217 | 2003-09-30 22:27:00 | Excel 2002 - reversing rows | alands (2496) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 179426 | 2003-09-30 22:27:00 | In a worksheet of 100 rows, how can I reverse the sequence so that row 100 becomes row 1, row 99 row 2, etc? | alands (2496) | ||
| 179427 | 2003-09-30 23:30:00 | If you make another column and number it 1 to 100 (just put the first few numbers in and then drag down, excel will fill in the rest) and then sort the sheet by that column in descending order (Data/Sort/descending) this will reverse the order of the columns. | Barnabas (4562) | ||
| 179428 | 2003-09-30 23:33:00 | You cant change the row or column headings. You can hide them is about it. Are you wanting to change the order of the data? If so, paste special - transpose can change from up-down to across and visa versa but not the order. To do that can be done by a macro or you could do something like this. Say you have 100 rows. In adj column put =a100, next row =a99 etc (use fill habndle to copy down). Now copy this row and paste-special values over the column you want reversed. |
parry (27) | ||
| 179429 | 2003-10-01 04:00:00 | Many thanks people. It was so obvious once you told me! | alands (2496) | ||
| 1 | |||||