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.
Using 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
-
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. -
From the Page Layout command tab, in the Page Setup group, click BREAKS
» select Insert Page Break
The page break appears in the worksheet.
Removing a Custom Page Break
-
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. -
From the Page Layout command tab, in the Page Setup group, click BREAKS
» select Remove Page Break
The page break is removed.
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.
-
From the Formulas command tab, in the Formula Auditing section, click SHOW FORMULAS
The formulas are displayed. -
To hide formulas, click SHOW FORMULAS again.
Hiding 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.
Applying 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.
-
From the Page Layout command tab, in the Page Setup group, click PAGE SETUP
The Page Setup dialog box appears. -
Select the Sheet tab
-
To print gridlines, in the Print section, select Gridlines
-
To print your worksheet in shades of black and white, in the Print section, select Black and white
-
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. -
To print row and column headings, in the Print section, select Row and column headings
-
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
-
Click OK
The changes are saved and the Page Setup dialog box closes.
