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

Solving Page Break Problems 293
Figure 5-13:
Preview page breaks in a report in Page Break Preview.
Figure 5-13 illustrates how you can correct these two bad page breaks in Page Break Preview mode by following these steps:
1. Click the Page Break Preview button (the third one in the cluster of three to the left of the Zoom slider) on the status bar, or choose View➪Page Break Preview on the Ribbon, or press Alt+WI.
This takes you into a Page Break Preview mode that shows your work- sheet data at a reduced magnification (60 percent of normal in Figure 5-13) with the page numbers displayed in large, light type and the page breaks shown by heavy lines between the columns and rows of the worksheet.
2. Position the mouse or Touch pointer somewhere on the page break indicator (one of the heavy lines surrounding the representation of the page) that you need to adjust; when the pointer changes to a double- headed arrow, drag the page indicator to the desired column or row and release the mouse button.
For the example shown in Figure 5-13, I dragged the page break indicator between Pages 1 and 3 to the left so that it’s between columns E and F and the page indicator between Page 1 and 2 up so that its between row 26 and 27.
In Figure 5-14, you can see Page 1 of the report as it then appears in the Print Preview window.
Book II Chapter 5
Printing Worksheets