View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 299
Default 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?