Excel XP
Defining Page Setup Options
Creating Sheet Settings
The Sheet tab in the Page Setup dialog box provides additional print options 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
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
Determines the order in which worksheets are printed.
