Excel 2003

Creating sheet settings

The Sheet tab in the Page Setup dialog box provides additional print options that you may want to add to your worksheet.

Print area

By default, Excel prints from the A1 to the last occupied cell in a worksheet. You can specify a different range of cells to print.

Print titles

Prints column and row labels on each page of the printout. Specify these rows or columns in the Rows to Repeat at Top and Columns to Repeat at Left textboxes.

Print - gridlines

This determines whether gridlines are printed. However, turning off gridlines does not affect their appearance in Normal View.

Print - black and white

If you used colors in your worksheet but don't want to waste the ink in your color printer, use black and white.

Print - draft quality

Choose draft quality to print the worksheet without gridlines or graphics.

Print - row and column headings

Click this option to include row numbers and columns letters in your printed document.

Page order

This determines the order in which worksheets are printed.