1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel Printing

By Ted French, About.com

5 of 7

Excel Page Setup Dialog Box Sheet Tab

Page Setup dialog box

Page Setup dialog box

© Ted French

Excel Printing - Using the Page Setup Dialog Box (con't)

The Sheet Tab of the Page Setup Dialog Box has four areas of printing options.

  1. Print Area – Select a range of cells on the spreadsheet to print. Very useful if you are interested only in printing a small section of the worksheet.

  2. Print Titles – Used for printing certain rows and columns on every page - usually headings or titles.

  3. Print- The most commonly used options are -
    • Draft quality – Prints a quick, low quality draft copy.

    • Gridlines – For printing the worksheet gridlines – making it easier to read data on larger worksheets.

    • Row and column headings – Prints the row numbers and the column letters down the side and across the top of a each worksheet.

  4. Page order – Changes the order for printing pages on a multiple page spreadsheet. Normally Excel prints down the worksheet. If you change the option, it will print across.

5 of 7

Explore Spreadsheets

More from About.com

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel 101
  5. Excel Printing - Using the Sheet Tab Settings - Printing in Excel

©2008 About.com, a part of The New York Times Company.

All rights reserved.