Print Part of a Worksheet : Print « Workbook Worksheet « Microsoft Office Excel 2007 Tutorial






Click the Page Layout tab. 
           Click the Page Setup Dialog Box Launcher.
Click the Page Layout tab. Click the Page Setup Dialog Box Launcher.
Click the Sheet tab. 
           Type the range you want to print.
Click the Sheet tab. Type the range you want to print.
Or click the Collapse Dialog button, 
           select the cells you want to print
Or click the Collapse Dialog button, select the cells you want to print
Then click the Expand Dialog button to restore the dialog box.
Then click the Expand Dialog button to restore the dialog box.








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