Microsoft Office Tutorials and References
In Depth Information
Solving Page Break Problems
header or footer area and then re-create this header or footer on the second
page (now marked Even Page Header or Even Page Footer), this time in the first,
left-aligned section.
Solving Page Break Problems
The Page Break preview feature in Excel enables you to spot and fix page break
problems in an instant, such as when the program wants to split information
across different pages that you know should always be on the same page.
Figure 5-12 shows a worksheet in Page Break Preview with an example of a
bad vertical page break that you can remedy by adjusting the location of the
page break on Page 1 and Page 3. Given the page size, orientation, and margin
settings for this report, Excel breaks the page between columns K and L.
This break separates the Paid column (L) from all the others in the client list,
effectively putting this information on its own Page 3 and Page 4 (not shown
in Figure 5-12).
Figure 5-12:
Preview
page breaks
in a report
with Page
Break
Preview.
Search JabSto ::




Custom Search