• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Part I: Everyday Worksheet Tasks > Printing Worksheets

Chapter 12. Printing Worksheets

  • Printer setup

    The first step in printing your worksheets is to install and set up your printer using the Printers folder in Windows 95.

  • Defining page setup

    Before you print your worksheet, you can specify many settings to set up your page for printing, including paper orientation, margins, centering, and headers and footers.

  • Print area and page breaks

    If you don't want to print all of a worksheet, you need to define the area of the worksheet to be printed. You can also preview Excel's automatic page breaks and adjust them if necessary.

  • Document previewing

    Save time and paper by previewing your document before you print it to make sure all your settings are correct.

  • Report Manager reports

    Compile the printouts from different worksheets with different print ranges, input scenarios and views into one report that can be printed with sequential page numbering.

  • Print documents

    Select the range of pages and number of copies you want to print in the Print dialog box.

Excel enables you to use the full capabilities of your printer. Excel reports printed from laser printers can look as though they have been typeset.

Figures 12.1 and 12.2 give you some idea of what you can produce. Excel can produce the equivalent of preprinted invoices or annual report-quality financial statements.

Excel saves you from the trial and error process of printing to see your results. Instead, you can preview the printed page on-screen before you send it to the printer. You also can adjust margins and column widths in the preview.

When you have many different reports or views to print from a worksheet, you can use the View, Custom Views command to assign a name and print settings to each different view. Views and the Custom Views command are described in Chapter 20, "Managing the Worksheet Display."

If your work involves multiple sheets or views that need to be printed in sequence, including sequential page numbers, use the Report Manager. The Report Manager enables you to list the different views and scenarios that you want printed. These views and scenarios are then printed as a single document. (Scenarios are stored collections of input values that enable you to print multiple test results. The Scenario Manager is described in Chapter 32, "Testing Multiple Solutions with Scenarios.") The Report Manager is described near the end of this chapter.

Figure 12.1. You can produce presentation-quality reports from an Excel worksheet.

Figure 12.2. What you see on-screen and in the print preview window shows you exactly how your printed page will appear.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint