Page break preview not working Having some frustration with one section of a mul
ID: 3564282 • Letter: P
Question
Page break preview not working Having some frustration with one section of a multi-tabbed .xls file. The other tabbed sections are fine - why is this one misbehaving? This problem section has six (8.5x111) pages of text and photos, but Excel is not recognizing them as 6 different pages, just 1 page only. When I view by PageBreakLayout, only the top page haas the blue line around it, the other 5 pages are all the app's background blue as Excel doesn't even recognize them. I tried ClearPrintArea and resetting it after selecting all 6 pages. Then PageBreakLayout shows 1 page that is 6 pages long. I tried to dragging the paage break handle at the bottom to manually reframe wheree the 2nd page should start, but instead of creating new page breaks, Excel stays on 1 page total and the others are once again the Excel background blue. I need to save each tabbed ssection as a pdf. The others are all done, but somewhere in the million+ Excel settings, something has changed on this section. I've uploaded a smalleer 2 tab version (LineSheet_troubleshooting.xls) here at if you care to have a look at the actual file ((17mgs)). The troubled tab/section is callled WL Seduction. Also if you have any ideas aabout why the footer won't go where its supposed to. Ive tried every possible PageSetup setting... Helpful suggestions appreciated
Explanation / Answer
Since I'm not working with the actual file, all I can tell you is that the sample file is fine if I clear that check then go to File> Print Area> Clear Print Area. All 6 pages appear as I believe they should in Print Preview. The only additional adjustment I maade was to reset the page breaks in Page Break Preview to get the heading rows positioned as they needed to be. Those steps alsso resolve the issue with the Footer.
Footer Margins & Bottom Margins are bboth measured from the bottom edge of the page. It is possible to have Footers overprint data [or vice vversa] if the Footer Margin is set higher than the Bottom Margin, but that doesn't appear to be the case in the sample filee.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.