Sorting multiple rows at once

[Yamasaki450]

Hello everyone

I would like to sort multiple rows at once from smallest to largest from left to right. I only want to sort data from column E to column K. See screenshot below...
What would be the easiest way to do this? i have about 2500 rows to sort...

Thanks.

 

[etaf]

when you goto sort
custom sort
click on options - you can sort - left to right

see section sort left to right

Sort data in a range or table - Microsoft Support

How to sort and organize your Excel data numerically, alphabetically, by priority or format, by date and time, and more.

support.microsoft.com

sorting a row

How to Sort in Excel Rows or Columns Avoid Sort Problems

How to sort in Excel lists. How to sort by row or by column. Easy steps to sort multiple columns, avoid problems. Sort in custom order. Video, workbook

www.contextures.com

 

[Yamasaki450]

I know this. But this is not practical for 2500 rows... Is there a formula for this? so i can just drag it down to row 2500?

 

[Fluff]

How about

=SORT(E2:K2,,,1)

 

[Yamasaki450]

How about

=SORT(E2:K2,,,1)

Thats exactly what i wanted. Thanks a lot... Have a nice day

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Yamasaki450]

How about

=SORT(E2:K2,,,1)

One more question... What would be formula for sorting from smallest to largest from right to left?

 

[Fluff]

If you mean sorting highest to lowest then just change the 1 to -1