Microsoft Office Tutorials and References
In Depth Information
Previewing worksheets before printing
view to change the alignment of the rows and columns on the page. When the columns
parallel the long edge of a piece of paper, the page is laid out in portrait mode; when the
columns parallel the short edge of a piece of paper, it is in landscape mode.
Changing between portrait and landscape mode can result in a better fit, but you might
find that not all of your data will fit on a single printed page. This is where the options
available on the Scaling button in the Backstage view come to the rescue. By using the options
on the Scaling button, 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 fit on a single page, or reduce the size
of the worksheet’s contents until all of the worksheet’s rows fit 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 displaying the Backstage view and then
clicking Print in the left pane. 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 view the next printed
page by clicking the preview image and 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, enter 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.
11
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 this mode, on the View tab, in the
Workbook Views group, click Page Break Preview.
 
Search JabSto ::




Custom Search