This browser does not support basic Web standards, preventing the display of our site's intended design. May we suggest that you upgrade your browser?

Microsoft Excel 2003/2004

Other Printing Options

Excel provides many options for modifying how your worksheet will appear on a printed sheet. Most of these options are accessed through the Sheet tab of the Page Setup dialog box; for more information on the Sheet tab, refer to About the Excel Page Setup Dialog Box: Sheet Tab Options

return to topPrinting Gridlines

Gridlines (outlines of each cell) will not print by default in Excel 2003/2004. Depending on the purpose of the printout, you may or may not want to print the gridlines. For example, gridlines may be useful when you are developing a document such as a report, but you may not want the gridlines printed in the final report that you share with others.

  1. From the File menu, select Page Setup...
    The Page Setup dialog box appears.
    Page Setup dialog box

  2. Select the Sheet tab

  3. Under Print, select Gridlines

  4. Click OK

return to topPrinting Row and Column Headings

When both planning and troubleshooting a worksheet, you may find it helpful to print the column (A,B,C...) and row headings (1,2,3...). The column and row headings will not print in your worksheet unless you specify it.

  1. From the File menu, select Page Setup...
    The Page Setup dialog box appears.

  2. Select the Sheet tab

  3. Under Print, select Row and column headings

  4. Click OK

return to topRepeating Items on Each Page

When you are working with large worksheets, repeating information (like row or column descriptions) on subsequent pages can help improve the readability of your reports. Although the headers and footers, located in the margins, can be used for adding information, they may not provide you with the flexibility that you need. In the Page Setup dialog box, you can specify print titles for both columns and rows. After print titles have been defined, row headings will appear at the left of the page and column headings will appear at the top of the page when printing a multi-page worksheet.

Setting Print Titles for a Single Row and Column

  1. From the File menu, select Page Setup...
    The Page Setup dialog box appears.

  2. Select the Sheet tab

  3. Under Print titles, in the Rows to repeat at top text box, type an absolute row reference for the row you want to repeat
    EXAMPLE: If you want row 5 to repeat, type $5:$5
    OR
    1. Click COLLAPSE DIALOGCollapse Dialog box buttonorCollapse Dialog box button
    2. Select the row you want to repeat by clicking it
    3. Click RESTORE DIALOGRestore Dialog box buttonorExpand Dialog box button

  4. Under Print titles, in the Columns to repeat at left text box, type an absolute column reference for the column you want to repeat
    EXAMPLE: If you want column C to repeat, type $C:$C
    OR
    1. Click COLLAPSE DIALOGCollapse Dialog box buttonorCollapse Dialog box button
    2. Select the row you want to repeat by clicking it
    3. Click RESTORE DIALOGRestore Dialog box buttonorExpand Dialog box button

  5. Click OK

Setting Print Titles for Multiple Rows and Columns

  1. From the File menu, select Page Setup...
    The Page Setup dialog box appears.

  2. Select the Sheet tab

  3. Under Print titles, in the Rows to repeat at top text box, type the absolute row references for the rows you want to repeat
    EXAMPLE: If you want rows 3 and 4 to repeat, type $3:$4
    OR
    1. Click COLLAPSE DIALOGCollapse Dialog box buttonorCollapse Dialog box button
    2. Select the rows you want to repeat by clicking the desired first row and dragging to the desired last row
    3. Click RESTORE DIALOGRestore Dialog box buttonorExpand Dialog box button

  4. Under Print titles, in the Columns to repeat at left text box, type the absolute column references for the columns you want to repeat
    EXAMPLE: If you want columns C and D to repeat, type $C:$D
    OR
    1. Click COLLAPSE DIALOGCollapse Dialog box buttonorCollapse Dialog box button
    2. Select the rows you want to repeat by clicking the desired first row and dragging to the desired last row
    3. Click RESTORE DIALOGRestore Dialog box buttonorExpand Dialog box button

  5. Click OK

return to topChanging the Print Quality

You can change the quality of your printout to print at a higher resolution. Resolution is the number of dots per linear inch (dpi) that appear on the printed page.

  1. From the File menu, select Page Setup...
    The Page Setup dialog box appears.

  2. Select the Page tab

  3. From the Print quality pull-down list, select the resolution you want for your printout

  4. Click OK

Excellence. Our Measure. Our Motto. Our Goal.