ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   SORTING AN EXCEL SPREADSHEET ROW BY ROW (https://www.excelbanter.com/excel-worksheet-functions/103473-sorting-excel-spreadsheet-row-row.html)

Patricia

SORTING AN EXCEL SPREADSHEET ROW BY ROW
 
I have 100 rows of numbers.
How do I select the 100 rows and make excel sort each row individually in
ascending order from left to right?

Peo Sjoblom

SORTING AN EXCEL SPREADSHEET ROW BY ROW
 
Not possible, you can only sort 3 rows at a time but if you want to sort
individually you need
to sort them row by row one at a time


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com



"Patricia" wrote in message
...
I have 100 rows of numbers.
How do I select the 100 rows and make excel sort each row individually in
ascending order from left to right?





All times are GMT +1. The time now is 08:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com