Microsoft Office Tutorials and References
In Depth Information
Adjusting Page Layout
Drag sizing handles to adjust margins
in the print preview.
Viewing page breaks.
Each time you open the Page Break
preview, you will see a Page Break Preview
message. Check the Do Not Show This
Dialog again box to prevent the message
The Margins icon also displays column
handles. Drag these handles to resize the
column widths so that all of your data is
Manually Changing Page Breaks
If you want to see where Excel breaks your data
to a new printed page, you can select View >
Workbook Views > Page Break Preview. Not only
can you see blue dotted lines and page-number
labels (see Figure 9-16) to indicate the breaks,
you can change where the breaks occur.
Besides moving existing page breaks, you will
also be able to insert page breaks at any point
in the worksheet from the Page Break preview.
Page breaks can be placed vertically (between
columns) or horizontally (between rows). Select
the first cell in the row or column you want to
be placed on a new page and then choose Page
Layout > Page Setup > Breaks from the Ribbon.
Select Insert Page Break from the drop-down
menu. Excel adds a solid blue line to indicate a
manual page break as shown in Figure 9-17.
To move a page break, position the mouse over
the blue lines until the mouse pointer turns into
a double-headed arrow. Click and drag the page
break lines into the desired position. Excel will
adjust the page scaling so that the information
fits on the requested number of pages.