Shuffling cells up in Excel (automatically)

[Mister0]

I've set up a simple Excel spreadsheet showing weekly results of a football league. Is there a way to automatically 'shuffle up' a row, according to the number of points a team currently has? What should I use in Excel.. pivot tables? If so, I'm in trouble cos don't know how to use them!

[YvonneM]

It is easier if the columbn you want to sort is the first or last column Highlight the column you want to sort into order then drag across so that all columns are highlighted do not select the heading you you have any then click on A to Z sort or Z to A which ever make sure when it is sorted it has taken all the information for each entry correctly if not clik on UNDO and try again

[lonzuk]

Here's some free software that does it for you.

it's pretty cool:

http://www.ngthomas.co.uk/ltrack.html