1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel Printing

By , About.com Guide

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.
Explore Spreadsheets
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

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

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

All rights reserved.