Microsoft Office Tutorials and References
In Depth Information
Changing between portrait and landscape mode can result in a better it, but you might
find that not all of your data will it on a single printed page. This is where the options
available on the Scaling button in the Backstage view come to the rescue. With the Scaling
button’s options, you can perform three tasks: reduce the size of the worksheet’s contents
until the worksheet can be printed on a single page, reduce the size of the worksheet’s
contents until all of the worksheet’s columns it on a single page, or reduce the size of
the worksheet’s contents until all of the worksheet’s rows it on a single page. You can
make the same changes (and more) by using the controls in the Page Setup dialog box.
To display the Page Setup dialog box, click the Page Layout tab, and then click the Page
Setup dialog box launcher.
Previewing Worksheets Before Printing
You can view your worksheet as it will be printed by clicking the File tab and then clicking
Print in the left pane. When you do, Excel displays the active worksheet in the Backstage
view, which includes a preview of the printed worksheet.
When Excel displays your worksheet in the Backstage view, it shows the active worksheet
as it will be printed with its current settings. At the bottom of the Backstage view, Excel
indicates how many pages the worksheet will require when printed and the number of
the page you are viewing.
Tip When you display a workbook in the Backstage view, you can see the next printed page
by pressing the Page Down key; to move to the previous page, press the Page Up key. You
can also use the Previous and Next arrows at the bottom of the Backstage view, type a page
number in the Current Page box, or scroll through the pages by using the vertical scroll bar
at the right edge of the Backstage view.
Changing Page Breaks in a Worksheet
Another way to affect how your worksheet will appear on the printed page is to change
where Excel assigns its page breaks. A page break is the point at which Excel prints all
subsequent data on a new sheet of paper. You can make these changes indirectly by
modifying a worksheet’s margins, but you can do so directly by displaying your document
in Page Break Preview mode. To display your worksheet in Page Break Preview mode, on
the View tab, in the Workbook Views group, click Page Break Preview.