Its a problem of Excel , i will be glad if anyone can solve this.?

I want to sort ascending to descending. I have eight columns and i want to sort by the columns name "Total" which is last column, now the problem is this that a data for each No. is in four rows and i want when i sort with Column"Total", all rows of that particular No. move with it toghether. i tried but it moves only that row where the total is written and letf the other three rows. now i want when i sort all the rows move with that "total column" if anyone want he can chat with me on my yahoo id.