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

1) You can't sort merrged cells
2) when adding borders select the area you want to add border before doing
the formating. I would recommmen d clearing all the borders and sttarting
from scratch. You can remove all borders on a worksheet by clicking the box
between column A and row 1 highlights entire worksheet). Then go into format
menu and select borders - None. Then highlight area that you want borders
and add new borders.

"loc" wrote:

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

Joel,

did that. now i have gridlines between all the different little areas on the
page? How do i get rid of them.

"Joel" wrote:

1) You can't sort merrged cells
2) when adding borders select the area you want to add border before doing
the formating. I would recommmen d clearing all the borders and sttarting
from scratch. You can remove all borders on a worksheet by clicking the box
between column A and row 1 highlights entire worksheet). Then go into format
menu and select borders - None. Then highlight area that you want borders
and add new borders.

"loc" wrote:

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

the gride line won't print. Are they really a problem? You may want to add
some background fill to make the spreadsheett easierr to managger. You can
grey out cells you don't want any entries. Color cells where you wantt
entries.

"loc" wrote:

Joel,

did that. now i have gridlines between all the different little areas on the
page? How do i get rid of them.

"Joel" wrote:

1) You can't sort merrged cells
2) when adding borders select the area you want to add border before doing
the formating. I would recommmen d clearing all the borders and sttarting
from scratch. You can remove all borders on a worksheet by clicking the box
between column A and row 1 highlights entire worksheet). Then go into format
menu and select borders - None. Then highlight area that you want borders
and add new borders.

"loc" wrote:

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

I guess what i'm saying I want each of the seperate areas to be its own
seperate spreadsheet but all on one page.

"Joel" wrote:

the gride line won't print. Are they really a problem? You may want to add
some background fill to make the spreadsheett easierr to managger. You can
grey out cells you don't want any entries. Color cells where you wantt
entries.

"loc" wrote:

Joel,

did that. now i have gridlines between all the different little areas on the
page? How do i get rid of them.

"Joel" wrote:

1) You can't sort merrged cells
2) when adding borders select the area you want to add border before doing
the formating. I would recommmen d clearing all the borders and sttarting
from scratch. You can remove all borders on a worksheet by clicking the box
between column A and row 1 highlights entire worksheet). Then go into format
menu and select borders - None. Then highlight area that you want borders
and add new borders.

"loc" wrote:

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

It doesn't really make too much of a diffference if thing are on one
worksheet or multiple worksheets. You can add page breaks so each area gets
printed on its own sheet. You have to judge which is the best way to setup
the spreadsheet(s).

"loc" wrote:

I guess what i'm saying I want each of the seperate areas to be its own
seperate spreadsheet but all on one page.

"Joel" wrote:

the gride line won't print. Are they really a problem? You may want to add
some background fill to make the spreadsheett easierr to managger. You can
grey out cells you don't want any entries. Color cells where you wantt
entries.

"loc" wrote:

Joel,

did that. now i have gridlines between all the different little areas on the
page? How do i get rid of them.

"Joel" wrote:

1) You can't sort merrged cells
2) when adding borders select the area you want to add border before doing
the formating. I would recommmen d clearing all the borders and sttarting
from scratch. You can remove all borders on a worksheet by clicking the box
between column A and row 1 highlights entire worksheet). Then go into format
menu and select borders - None. Then highlight area that you want borders
and add new borders.

"loc" wrote:

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