Sorting multiple rows

[danielcw]

Hi,
I have multiple rows of data I want to sort from left to right simultaneously.

12,4,7,8,1,6
9,12,5,3,2,10
8,4,1,9,15,10
etc.

To give:-
1,4,6,7,8,12
2,3,5,9,10,12
1,4,8,9,10,15

Can someone point me in the direction of how to do this in Excel?

Thanks in advance.
danielcw

 

[adulted]

Sorting

Hi danielcw,

Select each row independently. Select A1 through F1, Click Data Sort Answer the sort warning Continue with the Current selection, Click on Options, then choose Orientation Left to right, followed by OK


Hope this helps,
Paul