Report Print Layout

Re-size the Spreadsheet in a Report

A report may be displayed compressed to a smaller scale if it has many rows and columns.

Before printing your report, you can re-size the spreadsheet in it. For viewing or printing, you can drag to maximize or minimize a spreadsheet horizontally or vertically up to a factor of 2.

Select the handles of the frame that appears around the spreadsheet.

Adjust them to make the spreadsheet larger or smaller.

• To maximize it, drag it out to its full actual size (as large as it will go).
• To minimize it, drag it smaller to half its actual size (as small as it will go).

Save as PDF

• From the File tab menu, select Save as and select PDF file from the Save as type menu on the Save as dialog box.
• From the Home tab, select Save, then Save as PDF

Print Setup

From the File tab menu, select Print, then Settings to display the Print Setup dialog.

In the Orientation group at the lower right of this dialog, select the Portrait or Landscape option button to set the page layout for your report.

Print

From the File tab menu, select Print, then the Print icon.

Selecting this command displays the Output Options dialog box. Select one of the following options:

Objects (as they are sized in the Report window)

Full-sized Spreadsheet (on separate pages)

Use the current setting and do not display this dialog again

Click OK to display the Print Report dialog box.

Print Report dialog box

Click the Properties button to display the Printer's Properties dialog box.

The design of this dialog depends on the type of printer you've selected for your report. Most may have several tabs located at the top, one of which pertains to page layout.

Select the tab which displays the orientation, or layout, option buttons.

You can also save, or print your report to a PDF file  when you select Adobe PDF as your printer.

See also, Creating a New Report, Opening a Report, Adding Items to a Report, Printing a Report, and Saving a Report,