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 2007

Using Printing Options

There are several ways to customize your printing area, which can help create the exact printouts you desire. For more printing information, refer to Printing Basics and Chart Extras: Printing Chart and Worksheet Data.

return to topUsing Custom Page Breaks

Page breaks determine the boundaries of printable information. The dotted lines that appear represent the margins of the printer paper. When a document is printed, information on each side of the break will appear on different pages.

WARNING: Excel will print every page designated by a custom page break, including blank pages. Do not create more custom page breaks than you require.

Establishing a Custom Page Break

  1. Select the cell whose upper left corner is where you want the page break to appear
    EXAMPLE: If you want the page break to appear between columns L and M, and between rows 8 and 9, select the the cell M9.

  2. From the Page Layout command tab, in the Page Setup group, click BREAKSBreaks button» select Insert Page Break
    The page break appears in the worksheet.

Removing a Custom Page Break

  1. Select the cell whose upper left corner is where the page break you want to delete is located
    EXAMPLE: If the page break appears between columns L and M, and between rows 8 and 9, select the the cell M9.

  2. From the Page Layout command tab, in the Page Setup group, click BREAKSBreaks button» select Remove Page Break
    The page break is removed.

return to top Printing Formulas

Troubleshooting your worksheets can be easier if you print the formulas. In order to print the formulas, they must first be displayed.

Displaying the Formulas

Formulas are toggled on and off by the SHOW FORMULAS button.

  1. From the Formulas command tab, in the Formula Auditing section, click SHOW FORMULASShow Formulas button
    The formulas are displayed.

  2. To hide formulas, click SHOW FORMULAS again.

return to topHiding Information

To keep your printouts concise, you may want to hide some parts of the worksheet, including entire columns, rows, and selected cells. For more information, refer to Hiding Columns, Rows, and Cells.

return to topApplying Additional Printing Options

The Page Setup dialog box offers additional printing options for you. You may choose to print in color or print gridlines and headings. If you are printing drafts and want to conserve ink, you can print low-quality drafts. You may also edit how you want cell errors to appear in printouts. These options are all available in the Page Setup dialog box.

  1. From the Page Layout command tab, in the Page Setup group, click PAGE SETUPPage Setup button
    The Page Setup dialog box appears.

  2. Select the Sheet tab
    Page Setup dialog box displaying the Sheet tab

  3. To print gridlines, in the Print section, select Gridlines

  4. To print your worksheet in shades of black and white, in the Print section, select Black and white

  5. To print low-quality draft, in the Print section, select Draft quality
    HINT: Be sure to deselect Draft quality when you no longer want to print in this format.

  6. To print row and column headings, in the Print section, select Row and column headings

  7. To customize how cell errors will appear when printed, in the Print section, from the Cell errors as pull-down list, select the desired option

  8. Click OK
    The changes are saved and the Page Setup dialog box closes.

Excellence. Our Measure. Our Motto. Our Goal.