Microsoft Excel 2007: Using Printing Options (Win)

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
• Printing Formulas
• Hiding Information
• Applying Additional Printing Options

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

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 BREAKS» 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 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.

1. From the Formulas command tab, in the Formula Auditing section, click SHOW FORMULASThe formulas are displayed.
2. 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.

1. From the Page Layout command tab, in the Page Setup group, click PAGE SETUP
   The Page Setup dialog box appears.
2. Select 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 qualityHINT: 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

Make sure to let me know in the comments below or on our Facebook page how you've got with it or Do you have any questions