Happy new year to everyone,

I have a few hundred rows of data in 7 columns in which I want to turn it all upside down. How do I do that?

I also need to sort the same rows of data from smallest to largest (left to right) but the "Sort" function in Excel 97 only allow me to perform a row at a time. Is their a way it can perform all rows in one go?

Many thanks