More Excel Help Needed

[wykikitoon 20708]

Guys

 

I have a spread sheet for our footy league, with the following data (just incase you dont know what a footy league looks like ).

 

Pld

Win

Draw

Lose

For

Against

Goal Dif

Points

 

Now, I am having problems sorting the teams out.

 

Currently top 3 look like this;

 

Team A 3 3 0 0 23 10 13 9

Team B 4 3 0 1 27 20 7 9

Team C 4 3 0 1 48 27 21 9

 

Now if I highlight the pts column its sorts them no prob, but how do I do it for the F A GD PTS columns?

 

TIA

[wykikitoon 20708]

Ahhh its right, sorted it, just wasnt using the sort command to the full.