Multiple items on one sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Joel,

did that. now i have gridlines between all the different little areas on the
page? How do i get rid of them.
 
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.
 
I guess what i'm saying I want each of the seperate areas to be its own
seperate spreadsheet but all on one page.
 
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).
 
Back
Top