Microsoft Office Tutorials and References
In Depth Information
Printing Workbooks
4. Choose Set Print Area.
Excel displays a dotted line around your print area.
5. Click the File tab and then click Print.
A print preview image of your chosen print area appears.
6. Click Print.
After you define a print area, you can see which cells are part of your print
area by clicking the downward-pointing arrow of the Name box and choosing
Print_Area.
After you define a print area, you can always add to it by following these steps:
1. Select the cells adjacent to the print area.
2. Click the Page Layout tab.
3. Click the Print Area icon in the Page Setup group.
A pull-down menu appears.
4. Choose Add to Print Area.
Excel displays a dotted line around your newly defined print area.
After you define the print area, you can always remove it by following these
steps:
1. Click the Page Layout tab.
2. Click Print Area.
A pull-down menu appears (refer to Figure 8-22).
3. Choose Clear Print Area.
Inserting (and removing) page breaks
One problem with large spreadsheets is that when you print them out, parts
may get cut off when printed on separate pages. To correct this problem, you
can tell Excel exactly where page breaks should occur.
To insert page breaks, follow these steps:
1. Move the cursor in the cell to define where the vertical and horizontal
page breaks will appear.
2. Click the Page Layout tab.
3. Click the Breaks icon in the Page Setup group.
A pull-down menu appears, as shown in Figure 8-23.
 
Search JabSto ::




Custom Search