Microsoft Office Tutorials and References
In Depth Information
Getting Ready to Print a Worksheet
Making a worksheet fit on a page
Unless you tell it otherwise, Excel prints everything from cell A1 to the last
cell with data in it in the southeast corner of the worksheet. Usually, it isn’t
necessary to print all those cells because some of them are blank. And
printing an entire worksheet often means breaking the page up in all kinds of
awkward places. To keep that from happening, following are some techniques
for making a worksheet fit tidily on one or two pages.
As you experiment with the techniques described here, switch occasionally
to Page Layout view. In this view, you get a better idea of what your
worksheet will look like when you print it. To switch to Page Layout view, click
the Page Layout button on the status bar or View tab.
Printing part of a worksheet
To print part of a worksheet, select the cells you want to print, go to the
Page Layout tab, click the Print Area button, and choose Set Print Area on
the drop-down list. This command tells Excel to print only the cells you
selected. On the worksheet, a box appears around cells in the print area. To
remove the box from your worksheet, click the Print Area button and choose
Clear Print Area on the drop-down list.
Printing a landscape worksheet
If your worksheet is too wide to fit on one page, try turning the page on its
side and printing in landscape mode. In landscape mode, pages are wider
than they are tall. Landscape mode is often the easiest way to fit a worksheet
on a page.
To make yours a landscape worksheet instead of a portrait worksheet, go to
the Page Layout tab, click the Orientation button, and choose Landscape on
the drop-down list.
Seeing and adjusting the page breaks
Reading a worksheet is extremely difficult when it’s broken awkwardly
across pages. Where one page ends and the next begins is a page break. Use
these techniques to see where page breaks occur, adjust the position of
page breaks, and insert and remove page breaks:
✦ Viewing where page breaks occur: Click the Page Break Preview button
on the status bar or View tab. As shown in Figure 4-8, you switch to
Page Break Preview view. In this view, page numbers appear clearly on
the worksheet and dashed lines show you where Excel wants to break the