Excel 简明教程

Sheet Options in Excel 2010

Sheet Options

MS Excel 提供用于打印的各种表格选项，例如通常不会打印单元格网格线。如果希望打印输出包含网格线，请选择 Page Layout » Sheet Options group » Gridlines » Check Print 。

MS Excel provides various sheet options for printing purpose like generally cell gridlines aren’t printed. If you want your printout to include the gridlines, Choose Page Layout » Sheet Options group » Gridlines » Check Print.

sheet options

Options in Sheet Options Dialogue

  1. Print Area − You can set the print area with this option.

  2. Print Titles − You can set titles to appear at the top for rows and at the left for columns.

  3. Print − Gridlines − Gridlines to appear while printing worksheet. Black & White − Select this check box to have your color printer print the chart in black and white. Draft quality − Select this check box to print the chart using your printer’s draft-quality setting. Rows & Column Heading − Select this check box to have rows and column heading to print.

  4. Page Order − Down, then Over − It prints the down pages first and then the right pages. Over, then Down − It prints right pages first and then comes to print the down pages.