I have a landscape document that has 5 seperate areas on the sheet with
seperate information. I want gridlines in each seperate section but not in
between the area's. Then I want to sort each area By itself. Confused yet? I
did some cell merging to get to the point i'm at now but it will not let me
sort data in each area seperately because when I select gridlines to get them
in all the areas it put them between the area's and thinks it one document to
sort instead of seperate....

example:

Individual Scores Team Scores
NAME SCORE AVERAGE NAME
SCORE AVE
John Doe 5 8.5 Team 1
6 3.5
Jane Doe 2 9.5 Team 2
5 2.5
Bobby Doe 3 4.5 Team 3
4 5.5

League Notes:
Have fun this week everyone!
Congrats to Jane Doe leading with 9.5