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?