Sort left to right rows

I need to sort data in a spreadsheet from left to right in multiple rows. The data starts in G6 and ends in j46. I would like to know how to do this. I cannot program a macro so if one is needed please explain how to edit the macro to be used in other spreadsheets where the data to be sorted in rows (left to right) starts in different cells. Thanks.

Thanks. But that is for doing it one row at a time, correct? I want to highlight everything and do it all at once. I have tried the "ctrl-Y" shortcut after doing one row but that does not work. That is why I thought I needed a macro. Sorry if I wasn't clear at first.

My problem is when I select "left to right", I have a drop-down for selecting which rows. I am unable to select them all. And if I don't select any, nothing happens. So can you talk me through what to do at this point? Thanks.

Here is a screen shot of where I am. If I don't select which row (on the left button) then nothing happens. And if I select a row, it only sorts that row. From what I can tell, this is not straightforward....

Can you post the workbook or part thereof?

It should clearly illustrate your problem and not contain any sensitive data.

I want to sort from high to low (left to right) the values in columns H-K, treating each row independently (ie each row represents a student). I have other workbooks to do this for with many more rows than this example. I should add that I was able to sort one row in Excel 2003, and then use ctrl-y to do all the other rows in one shot. That is not working on Excel 2007 which I am presently using. Thanks.

Thanks. Is there a simpler way to write that macro so it can be edited and adpated to other spreadsheets with more rows?

Sub Macro8()
'
' Macro8 Macro

Range("C2:H2").Select
Selection.Sort Key1:=Range("C2"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight, _
DataOption1:=xlSortNormal
End Sub


i had about 2000 rows in columns C to column H. (there are info till column P but I dont want them in the sort range)

how can i sort automatically each row through all 2000 row

the basic macro i recoreded it did not automatically go
Range("C2:H2").Select
Range("C3:H3").Select
Range("C4:H4").Select
.....
.....
.....
Range("C2000:H2000").Select

pls some expert help me to figure this out

many thx in advance

ps im using excel 2003

I am trying to sort multipe rows left to right but nothing work, amazing how little i know about excel or how hard it is sometimes to do "simple" stuff inexcel 2010


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
2 5 17 18 21 22 23 26 27 38 39 43 48 52 53 59 67 72 75 76
2 9 16 18 25 27 30 37 41 53 60 61 63 64 66 67 68 73 76 78
43 68 16 42 59 77 65 5 48 67 39 14 35 80 19 78 18 73 31 47
68 36 31 35 29 2 47 66 72 15 54 58 42 61 8 48 17 45 63 50
71 61 47 6 39 52 21 46 4 33 8 79 12 35 24 65 42 55 80 17
51 67 31 13 23 56 2 52 50 55 54 43 72 16 59 12 44 5 27 74
60 52 25 73 4 22 44 65 39 67 45 79 69 23 27 75 63 38 37 68