Add to a print area : Print « Workbook Worksheet « Microsoft Office Excel 2007 Tutorial






Click a cell. 
           Click the Page Layout tab. 
           Click the Print Area button. 
           Then click Set Print Area.
Click the Page Layout tab. Click the Print Area button
Click another cell. 
           Click the Page Layout tab. 
           Click the Print Area button. Click Add to Print Area.
Click Add to Print Area.








7.4.Print
7.4.1.Print commentsPrint comments
7.4.2.Print Part of a WorksheetPrint Part of a Worksheet
7.4.3.Print Row and Column Titles on Each PagePrint Row and Column Titles on Each Page
7.4.4.Print Gridlines, Column Letters, and Row NumbersPrint Gridlines, Column Letters, and Row Numbers
7.4.5.Fit a Worksheet on a Specific Number of PagesFit a Worksheet on a Specific Number of Pages
7.4.6.Set the Print AreaSet the Print Area
7.4.7.Add to a print areaAdd to a print area
7.4.8.Clear the Print AreaClear the Print Area
7.4.9.Preview a WorksheetPreview a Worksheet
7.4.10.Preview the worksheet from the Print dialog boxPreview the worksheet from the Print dialog box
7.4.11.Print All or Part of a WorksheetPrint All or Part of a Worksheet