Microsoft Office Tutorials and References
In Depth Information
Defining the Print Area
Page Layout view of the Monthly Sales worksheet
page is too narrow
to fit al l of the
table c olumns in
portrai t orientation
print on four
In the worksheet’s current orientation, its contents do not ﬁ t on a single page and the
tables break across pages. You’ll change the orientation from portrait to landscape so that
the page is wide enough to ﬁ t all the table columns on one page.
To change to landscape orientation:
1. Click the Page Layout tab on the Ribbon.
2. In the Page Setup group, click the Orientation button, and then click Landscape .
The page orientation changes to landscape, making each page wide enough to
display all of the columns of each table.
Dei ning the Print Area
By default, all cells in the active worksheet containing text, formulas, or values are
printed. The region that is sent to the printer from the active sheet is known as the print
area . To print part of a worksheet, you can deﬁ ne the print area, overriding the default
setting. A print area can cover an adjacent or nonadjacent range in the current worksheet.
There are many different ways to deﬁ ne the print area, but it’s generally easiest to set the
print area in Page Break Preview. For example, if Tom wanted to print only the ﬁ rst table in
the Monthly Sales worksheet, you could deﬁ ne the print area to cover that range while in
Page Break Preview. You will go to Page Break Preview, and then set the print area.
To switch to Page Break preview and set the print area:
1. Click the Page Break Preview button on the status bar.
Trouble? If the Welcome to Page Break Preview dialog box opens, click the
2. Change the zoom level of the worksheet to 70% .
3. Select the range A1:K19 , which is the range of the first table.