sorting numbers

[davisgravel]

I know almost nothing about excel, i'm trying to sort numbers in ascending order, left to right i have 5 columns of numbers and 1962 rows, can i sort multiple rows at one time? I can't even make it sort multiple rows by doing custom sort and adding levels

[#2]

@davisgravel Please follow the steps below to sort left to right.

[#3]

Thanks for your reply, I have been able to do what you're telling me but, when I sort any number of rows and then try to sort another selection of rows the previous rows that I sorted return to a jumbled state. Also, I have so many rows to sort, I would like to be able to sort a large number of rows at once, guess you would say a range of rows like 1 - 100 or 1 - 1000, is that possible? Without just adding levels 1, 2, 3, and so on. And once again, why does my first sort return to unsorted when i do a second sort?

[#4]

why does my first sort return to unsorted when i do a second sort?

Can you share some data and expected result for better understanding?

[#5]

@peiyezhu 

like this?

 

[#6]

Your pic shows what I'm trying to do, I can sort one row at a time but when I do a second row my first row returns to an unsorted row.

[#7]

@davisgravel 

=TRANSPOSE(SORT(TRANSPOSE(A1:C1)))

or online sql:

https://m.bilibili.com/video/BV1wT4y1n7jH?buvid=XX85E838539534AD650323D79CEE8DA100517&from_spmid=mai...