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






  1. Microsoft Office Excel 2007 Tutorial
  2. Workbook Worksheet
  3. Print
Click the Office button. Click Print.
Click the Office button. Click Print.
Click the Name list arrow, and click the printer to use.
Click the Name list arrow, and click the printer to use.
To change printer properties, click Properties, select the options and then click OK.
To change printer properties, click Properties, select the options and then click OK.
Select whether to print the entire document or only the pages you specify.
Select whether to print the entire document or only the pages you specify.
Select whether to print the selected text or objects, 
           tables, the selected worksheets, or all the worksheets in the workbook with data.
Select whether to print the selected text or objects, tables, the selected worksheets, or all the worksheets in the workbook with data.
Click the Number of copies to specify the number of copies.
Click the Number of copies to specify the number of copies.








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