SharePoint 2007: The Definitive Guide

Printing from Excel Services

You can use different methods to print some or all of the spreadsheet data in a workbook.

Printing from Internet Explorer

This is a "quick and dirty" way to print information displayed in an Excel Web Access Web Part. The printed hard copy will include only the information currently displayed in your web browser. Any other information that you must scroll to view or that is on any other pages in the workbook will not be printed:

1. With the appropriate Web Part page open in your browser, go to the Web Access Web Part, and in the context menu that appears when you mouse over the workbook name, select "View in Web Browser."

2. When the workbook opens in the Web Part, navigate to the desired workbook page and area and then click File in the web browser's toolbar at the top.

3. To modify the page you want to print, select Page Setup in the File menu.

   Tip

   You can also click on Page Layout on the ribbon in Excel, as in Figure 18-11.

4. To modify the page's orientation, click the Layout tab and select either Portrait or Landscape.

   Tip

   This option is also available on the Page Layout ribbon, as in Figure 18-12.

5. To preview what this page will look like when printed, click Print Preview.

6. Click OK to close the dialog box, and then click File → Print to print the document.

If after viewing an Excel worksheet in Page Layout view you want to return to the Normal view, click the View tab on the ribbon and click Normal, as seen in Figure 18-13.

Printing a Saved Excel Workbook or Snapshot

Printing ...