• Excel Video Tutorials

Sheet Options in Excel 2010


Advertisements

Sheet Options

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

  • 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

    • 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.

  • 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.

Useful Video Courses


Video

MS Excel Online Training

Most Popular

102 Lectures 10 hours

Pavan Lalwani

Video

Excel VBA Online Training

101 Lectures 6 hours

Pavan Lalwani

Video

Advanced Excel (Power Query) Online Training

Best Seller

56 Lectures 5.5 hours

Pavan Lalwani

Video

Excel Dashboard Crash Course

63 Lectures 3.5 hours

Yoda Learning

Video

Advanced Excel Crash Course

134 Lectures 8.5 hours

Yoda Learning

Video

Microsoft Excel Masterclass for Business Managers

33 Lectures 3 hours

Abhishek And Pukhraj

Advertisements