I have a spreadsheet where I keep track of student's marks for tests. At the
end of the term, I would like to sort the marks, without keeping them lined
up with the test number, so I can keep the top 5 marks for each student.

Example:

Student/test s1 s2 s3 s4 s5
test 1 7 8 0 2 10
test 2 10 5 10 8 9
test 3 9 8 9 10 5
test 4 2 5 10 8 8

In the above example I would want to sort each column so that they were
highest to lowest, without affecting the column with test 1 etc. I just want
to sort the marks to see the top so many, and grade based on that.

I used to block of the values only, and hit sort, and all columns would be
sorted, but that doesn't work in Excel 2007.

Any help would be appreciated.