Sheet Options in Excel 2010

Sheet Options

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

Options in Sheet Options Dialogue

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

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

Print −

Gridpnes − Gridpnes to appear while printing worksheet.

Black & White − Select this check box to have your color printer print the chart in black and white.

Draft quapty − Select this check box to print the chart using your printer’s draft-quapty setting.

Rows & Column Heading − Select this check box to have rows and column heading to print.

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.