Page 310 - Excel 2013 All-in-One For Dummies

292 Solving Page Break Problems
Creating different even and odd page headers and footers
If you plan to do two-sided printing or copying of your spreadsheet report, you may want to define one header or footer for the even pages and another for the odd pages of the report. That way, the header or footer information (such as the report name or current page) alternates from being right-aligned on the odd pages (printed on the front side of the page) to being left-aligned on the even pages (printed on the back side of the page).
To create an alternating header or footer for a report, you click the Different Odd & Even Pages check box to put a check mark in it. (This check box is found in the Options group of the Design tab on the Header & Footer Tools contextual tab that appears when you’re defining or editing a header or footer in Page Layout view.)
After that, create a header or footer on the first page of the report (now marked Odd Page Header or Odd Page Footer) in the third, right-aligned sec- tion 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 page break problems in an instant as well as fix them, such as when the program wants to split onto different pages information that you know should always appear on the same page.
Figure 5-13 shows a worksheet in Page Break Preview with an example of a bad vertical and horizontal page break that you can remedy by adjusting the location of the page break on Pages 1 and 3. Given the page size, orientation, and margin settings for this report, Excel inserts a vertical page break between columns H and I. This break separates the April, May, and June sales on Page 1 from the Qtr 2 subtotals on Page 3. It also inserts a horizontal page break between rows 27 and 28, splitting the Net Income heading from its data in the rows below.
To correct the bad vertical page break, you need to move the page break to a column on the left several columns so that it occurs between columns E (with the Qtr 1 subtotals) and F (containing the April sales) so that the second quarter sales and subtotals are printed together on Page 3. To correct the bad horizontal page break, you need to move that break up one row so that the Net Income heading prints on the page with its data on Page 2.