Fit a Worksheet on a Specific Number of Pages : Print « Workbook Worksheet « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Workbook Worksheet
  3. Print
Click the Page Layout tab. 
           Click the Height and the Width, 
           then select the number of pages to force a worksheet to print.
Click the Page Layout tab. Click the Height and the Width, then select the number of pages to force a worksheet to print.
Click the Scale to scale the worksheet using a percentage.
Click the Scale to scale the worksheet using a percentage.








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