Sort By Row (4,000 rows)

  • Thread starter Thread starter Tina Johnson
  • Start date Start date
T

Tina Johnson

I have a 4,000 row file with 30 columns. I want to sort
by rows. However, when I select all the data and sort by
rows, nothing happens. The only way that I can sort by
row is if I do it one at a time, two at a time, or three
at a time. How do I do it all at once?

By the way, when I select all the data at one time, I
click on the blank box in the corner to the left of the A
column and to the top of row 1.
 
Tina Johnson said:
I have a 4,000 row file with 30 columns. I want to sort
by rows. However, when I select all the data and sort by
rows, nothing happens. The only way that I can sort by
row is if I do it one at a time, two at a time, or three
at a time. How do I do it all at once?

By the way, when I select all the data at one time, I
click on the blank box in the corner to the left of the A
column and to the top of row 1.
Click to expand...

You can only sort by up to three at a time. Repeated use of this produces
the same effect.

For example, if you wanted to sort by column A, then by B, then by C, then
by D, then by E and then by F, you would first sort on the least significant
three (i.e. sort by column D, then by E, then by F) and secondly sort on the
most significant three (i.e. sort by column A, then by B, then by C).
 
Tina,

I don't know what version of Excel you have; but in the 2003, when you go to Data>>Sort>>Options button, you can sort by row. I don't remember if the XP version had that feature or, for that matter, earlier versions yet. Anywho, if your version doesn't allow it, I can only suggest, on a separate worksheet, copy and transpose 230 rows at a time to the new sheet. Why 230? That's the number of columns excel has. The rows become columns when you transpose.

Sorry I can't be more helpful,
Ron_D
 
Ron_D said:
Tina,

I don't know what version of Excel you have; but in the 2003, when you go
Click to expand...
to Data>>Sort>>Options button, you can sort by row. I don't remember if the
XP version had that feature or, for that matter, earlier versions yet.
Anywho, if your version doesn't allow it, I can only suggest, on a separate
worksheet, copy and transpose 230 rows at a time to the new sheet. Why 230?
That's the number of columns excel has. The rows become columns when you
transpose.
Sorry I can't be more helpful,
Ron_D
Click to expand...

Excel has 256 columns, not 230.
 
Back
Top