 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / May 2007Multiple items on one sheet
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. > 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 [quoted text clipped - 19 lines] > 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. > 1) You can't sort merrged cells > 2) when adding borders select the area you want to add border before doing [quoted text clipped - 27 lines] > > 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. > Joel, > [quoted text clipped - 32 lines] > > > 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. > 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 [quoted text clipped - 37 lines] > > > > 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). > I guess what i'm saying I want each of the seperate areas to be its own > seperate spreadsheet but all on one page. [quoted text clipped - 40 lines] > > > > > Have fun this week everyone! > > > > > Congrats to Jane Doe leading with 9.5 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.