Microsoft Office Tutorials and References
In Depth Information
My Page Was Set Up!
My Page Was Set Up!
About the only thing the slightest bit complex in printing a worksheet is
figuring out how to get the pages right. Fortunately, the command buttons in the
Page Setup group on the Ribbon’s Page Layout tab give you a great deal of
control over what goes on which page.
Three groups of buttons on the Page Layout tab help you get your page
settings exactly as you want them. The Page Setup group, the Scale to Fit group,
and the Sheet Options group are described in the following sections.
To see the effect of changes you make in the Worksheet area, put the
worksheet into Page Layout view by clicking the Page Layout button on the Status
bar while you work with the command buttons in the Page Setup, Scale to Fit,
and Sheet Options groups on the Page Layout tab of the Ribbon.
Using the buttons in the Page Setup group
The Page Setup group of the Page Layout tab contains the following
important command buttons:
✓ Margins button to select one of three preset margins for the report or
to set custom margins on the Margins tab of the Page Setup dialog box.
(See “Massaging the margins” that follows in this chapter.)
✓ Orientation button to switch between Portrait and Landscape mode for
printing. (See the “Getting the lay of the landscape” section, later in this
✓ Size button to select one of the preset paper sizes, set a custom size, or
change the printing resolution or page number on the Page tab of the
Page Setup dialog box.
✓ Print Area button to set and clear the print area. (See the nearby
“Understanding and using the print area” sidebar.)
✓ Breaks button to insert or remove page breaks. (See “Solving Page Break
Problems” later in this chapter.)
✓ Background button to open the Sheet Background dialog box where you
can select a new graphic image or photo to use as a background for the
current worksheet. (This button changes to Delete Background as soon
as you select a background image.)
✓ Print Titles button to open the Sheet tab of the Page Setup dialog box
where you can define rows of the worksheet to repeat at the top and
columns of the worksheet to repeat at the left as print titles for the report.
(See “Putting out the print titles” later in this chapter.)